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...
--- 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: - List all tables in the database - Show table schema - Execute SELECT queries - Export data to CSV/JSON ## Usage Examples ### List all tables ```python python scripts/read_sqlite.py --list-tables C:\path\to\database.sqlite ``` ### Show table schema ```python python scripts/read_sqlite.py --schema C:\path\to\database.sqlite users ``` ### Execute SELECT query ```python 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
don't have the plugin yet? install it then click "run inline in claude" again.