← Back to Skills Marketplace
237
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install 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. S...
Usage Guidance
This skill appears to do what it says: a small, local Python utility for inspecting SQLite files. Before using it, review the script yourself (it is included) and run it on a copy of any sensitive database. Be aware the script will execute arbitrary SQL you provide — do not run untrusted queries or point it at unknown database files. If you want extra safety, run the script in a sandboxed environment or container and verify file permissions for any exported CSVs. The only minor oddity is the SKILL.md text that claims the script 'needs to be created' even though scripts/read_sqlite.py is present.
Capability Analysis
Type: OpenClaw Skill
Name: sqlite-reader
Version: 1.0.0
The skill provides a utility to query SQLite databases, specifically targeting the application's internal 'main.sqlite' file which contains session and user data. The implementation in 'scripts/read_sqlite.py' contains a SQL injection vulnerability in the 'get_table_schema' function where the 'table_name' argument is directly interpolated into PRAGMA statements. While the tool's functionality aligns with its stated purpose, the combination of high-privilege data access and unsafe query construction presents a significant security risk.
Capability Assessment
Purpose & Capability
Name/description (read and query SQLite files, including OpenClaw main.sqlite) match the included Python script which performs table listing, schema inspection, SELECT queries, and CSV export. No unexpected binaries, credentials, or config paths are requested.
Instruction Scope
SKILL.md describes running scripts/read_sqlite.py and example commands, which is consistent with the script. One minor inconsistency: SKILL.md states a 'read_sqlite' tool is 'not yet implemented' and says 'need to create script first', but the repository already includes scripts/read_sqlite.py. The script also allows executing arbitrary SQL supplied by the user (expected for this tool) — exercise caution with untrusted queries/databases.
Install Mechanism
No install spec is provided (instruction-only with included script). No external downloads or package installs are required; the script uses only Python standard libraries (sqlite3, json, csv, argparse, os).
Credentials
No environment variables, credentials, or config paths are required. The script operates on a database file path supplied by the user, which is appropriate for the stated purpose.
Persistence & Privilege
Skill does not request persistent/always-on presence. Defaults allow autonomous invocation (platform default) but there are no other special privileges or modifications to other skills or system configs.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install sqlite-reader - After installation, invoke the skill by name or use
/sqlite-reader - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release of sqlite-reader skill.
- Allows users to read and query SQLite database files.
- Supports listing tables, viewing schemas, and running basic SELECT queries.
- Usage examples provided for listing tables, displaying schema, and querying data via a Python script.
- Plans for tool and script implementation to aid data inspection and export.
Metadata
Frequently Asked Questions
What is sqlite-reader?
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... It is an AI Agent Skill for Claude Code / OpenClaw, with 237 downloads so far.
How do I install sqlite-reader?
Run "/install sqlite-reader" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is sqlite-reader free?
Yes, sqlite-reader is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does sqlite-reader support?
sqlite-reader is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created sqlite-reader?
It is built and maintained by SenKnight (@senknight); the current version is v1.0.0.
More Skills