- 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:
- Use
read_sqlitetool (not yet implemented - need to create script first) - 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:
- List all tables in the database
- Show table schema
- Execute SELECT queries
- Export data to CSV/JSON
Usage Examples
List all tables
python scripts/read_sqlite.py --list-tables C:\path\ o\database.sqliteShow table schema
python scripts/read_sqlite.py --schema C:\path\ o\database.sqlite usersExecute SELECT query
python scripts/read_sqlite.py --query "SELECT * FROM sessions LIMIT 5" C:\path\ o\database.sqliteImplementation Plan
I need to create:
scripts/read_sqlite.py- Python script for SQLite operationsreferences/schema.md- SQLite schema reference