π¦ ClawHub
sqlite-reader
by @senknight
Read and query SQLite database files. Use when user wants to inspect or extract data from .sqlite files, especially OpenClaw's main.sqlite memory database. S...
TERMINAL
clawhub install sqlite-readerπ About This Skill
name: sqlite-reader description: Read and query SQLite database files. Use when user wants to inspect or extract data from .sqlite files, especially OpenClaw's main.sqlite memory database. Supports basic SELECT queries, table listing, and schema inspection.
SQLite Reader Skill
Quick Start
To read a SQLite file:
1. Use read_sqlite tool (not yet implemented - need to create script first)
2. Or use the provided Python script in scripts/read_sqlite.py
Available Tools
Currently no direct tool exists, but I'll create a Python script that can:
Usage Examples
List all tables
python scripts/read_sqlite.py --list-tables C:\path\to\database.sqlite
Show table schema
python scripts/read_sqlite.py --schema C:\path\to\database.sqlite users
Execute SELECT query
python scripts/read_sqlite.py --query "SELECT * FROM sessions LIMIT 5" C:\path\to\database.sqlite
Implementation Plan
I need to create:
1. scripts/read_sqlite.py - Python script for SQLite operations
2. references/schema.md - SQLite schema reference
π‘ Examples
To read a SQLite file:
1. Use read_sqlite tool (not yet implemented - need to create script first)
2. Or use the provided Python script in scripts/read_sqlite.py