← 返回 Skills 市场
237
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install 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...
安全使用建议
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.
功能分析
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.
能力评估
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.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install sqlite-reader - 安装完成后，直接呼叫该 Skill 的名称或使用
/sqlite-reader触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
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.
元数据
常见问题
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... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 237 次。
如何安装 sqlite-reader？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install sqlite-reader」即可一键安装，无需额外配置。
sqlite-reader 是免费的吗？
是的，sqlite-reader 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
sqlite-reader 支持哪些平台？
sqlite-reader 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 sqlite-reader？
由 SenKnight（@senknight）开发并维护，当前版本 v1.0.0。
推荐 Skills