← Back to Skills Marketplace
rm-ra

sql-doc

by rm-ra · GitHub ↗ · v1.0.1 · MIT-0
cross-platform ⚠ suspicious
269
Downloads
0
Stars
0
Active Installs
2
Versions
Install in OpenClaw
/install sql-doc
Description
通过数据库API查询表数据,对指定数据进行分析并生成包含多维度信息的Word格式分析报告。
Usage Guidance
This skill is internally inconsistent: SKILL.md tells you to curl an internal API and then run a Python script, but the provided analyze_data.py only uses a hard-coded sample dataset (it doesn't read the curl output). Before installing or running, verify these points: 1) Confirm you intended to contact the internal endpoint 192.168.5.85:8000 and that doing so is allowed and safe — the skill's examples reference police incident data which may be sensitive or regulated. 2) The script requires python-docx but no install steps are provided; run in an environment with required Python packages or update the skill to declare/install dependencies. 3) Decide how API results should be passed to the script (save curl output to a file and modify the script to read it, or update the script to call the API itself). 4) Because the code and instructions don't match, inspect and test the skill in an isolated environment before using on real data; review/modify the SQL examples to avoid accidental exfiltration of sensitive records. If you need this to actually query and process live API results, ask the maintainer (or modify the script) so the script reads JSON output from the API rather than using embedded sample data.
Capability Analysis
Type: OpenClaw Skill Name: sql-doc Version: 1.0.1 The skill bundle facilitates raw SQL execution via curl commands to an internal IP (192.168.5.85), which presents a significant security risk for unauthorized data access or manipulation. Additionally, the analyze_data.py script contains hardcoded sensitive information, including what appear to be Chinese citizen ID numbers and records of domestic disputes, raising privacy and data handling concerns. While no clear evidence of intentional data exfiltration to external domains was found, the combination of raw SQL capabilities and the processing of PII makes this bundle high-risk.
Capability Assessment
Purpose & Capability
The declared purpose (query a database API and generate a Word report) matches the general contents, but there are important mismatches: SKILL.md uses the skill name 'db-analyst' while registry shows 'sql-doc'; analyze_data.py contains a hard-coded sample dataset rather than code that reads the API response, so the script as provided will not process results from the curl commands described in SKILL.md. The Python script also imports python-docx (from package 'docx') but no dependencies or install steps are declared.
Instruction Scope
SKILL.md instructs the agent to run curl against http://192.168.5.85:8000/query (an internal/private IP) and to run a python script at /root/.openclaw/workspace/skills/db-analyst/analyze_data.py. However, SKILL.md never shows how to pipe/save the curl output or how the script will read it. The script does not perform any network calls or read stdin/files — it uses embedded static data — so the instructions and the code are not integrated. The mapping file and examples include SQL queries that could access sensitive police records; the skill does not limit or sanitize queries.
Install Mechanism
There is no install spec (instruction-only), which limits risk from arbitrary installs. However, the script requires the python-docx library (import docx) and expects to run under Python3; these dependencies are not declared. No code is downloaded at install time beyond the provided files.
Credentials
The skill requests no environment variables, no credentials, and no config paths, which is proportionate. Note: SKILL.md directs network requests to a specific internal IP (192.168.5.85), which is not an environment variable but is potentially sensitive and should be verified.
Persistence & Privilege
The skill is not always-enabled and does not request elevated platform privileges. It writes a report to /root/.openclaw/workspace/分析报告.docx (inside the workspace) — this is expected for a report generator and does not modify other skills or system configuration.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install sql-doc
  3. After installation, invoke the skill by name or use /sql-doc
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.1
No changes detected in this version.
v1.0.0
- 首发版本,提供数据库分析与Word报告生成功能。 - 支持通过curl命令查询数据库API并获取表数据。 - 提供关键词-表名映射文件,便于快速定位查询目标。 - 包含Python脚本实现数据分析和Word格式报告自动生成。 - 分析报告涵盖数据总览、纠纷类型/原因、地点、时间分布、处置单位等多项内容。
Metadata
Slug sql-doc
Version 1.0.1
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 2
Frequently Asked Questions

What is sql-doc?

通过数据库API查询表数据,对指定数据进行分析并生成包含多维度信息的Word格式分析报告。 It is an AI Agent Skill for Claude Code / OpenClaw, with 269 downloads so far.

How do I install sql-doc?

Run "/install sql-doc" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is sql-doc free?

Yes, sql-doc is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does sql-doc support?

sql-doc is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created sql-doc?

It is built and maintained by rm-ra (@rm-ra); the current version is v1.0.1.

💬 Comments