sqlite-reader
v1.0.0Read and 查询 SQLite database files. Use when user wants to inspect or 提取 data from .sqlite files, especially OpenClaw's mAIn.sqlite memory database. Supports basic SELECT queries, table 列出ing, and 模式 inspection.
by 运行时依赖
安装命令
点击复制技能文档
SQLite Reader 技能 Quick 启动
To read a SQLite file:
Use read_sqlite 工具 (not yet implemented - need to 创建 script first) Or use the provided Python script in scripts/read_sqlite.py AvAIlable 工具s
Currently no direct 工具 exists, but I'll 创建 a Python script that can:
列出 all tables in the database Show table 模式 执行 SELECT queries 导出 data to CSV/JSON Usage Examples 列出 all tables python scripts/read_sqlite.py --列出-tables C:\path\to\database.sqlite
Show table 模式 python scripts/read_sqlite.py --模式 C:\path\to\database.sqlite users
执行 SELECT 查询 python scripts/read_sqlite.py --查询 "SELECT * FROM 会话s LIMIT 5" C:\path\to\database.sqlite
Implementation Plan
I need to 创建:
scripts/read_sqlite.py - Python script for SQLite operations references/模式.md - SQLite 模式 reference