← Back to Skills Marketplace
sqlskills

SQL Report Generator

by SQLSkills · GitHub ↗ · v1.0.1 · MIT-0
cross-platform ✓ Security Clean
191
Downloads
1
Stars
0
Active Installs
2
Versions
Install in OpenClaw
/install sql-report-generator
Description
生成生产级SQL查询结果与图表报告,支持表格、矩阵、切片器、多格式导出及统计分析驱动的自动洞察建议。
Usage Guidance
This package appears coherent and self-contained for generating reports from local data. Before installing: (1) run in an isolated Python virtualenv, install the listed dependencies and add 'scipy' if missing; (2) review the full code (especially any truncated files) for network calls or telemetry before running on sensitive data; (3) follow SKILL.md's guidance to manually review generated HTML/PDF outputs (sanitization, PII exposure) before sharing; (4) if you plan to link this with other skills (sql-master, sql-dataviz), check those skills' credential requirements and network behaviours — this report generator itself does not request credentials.
Capability Analysis
Type: OpenClaw Skill Name: sql-report-generator Version: 1.0.1 The sql-report-generator skill bundle is a comprehensive and legitimate tool for creating data-driven reports and dashboards. The codebase consists of statistical analysis logic (scripts/ai_insights.py), a large library of industry-standard dashboard templates (scripts/dashboard_templates.py), and UI components for HTML report generation (scripts/interactive_components.py). The security review found no evidence of data exfiltration, malicious execution (such as eval/exec or unauthorized shell commands), or harmful prompt injection. The use of base64 encoding is strictly limited to embedding matplotlib-generated charts into HTML reports, and the dependencies listed in requirements.txt are standard data science libraries.
Capability Assessment
Purpose & Capability
Name/description match included files: many dashboard templates, report-generation scripts, and an 'ai_insights' module that performs local statistical analysis. The requested resources (Python libs) align with the stated purpose; templates and examples all concern report/layout/chart generation.
Instruction Scope
SKILL.md instructs installing Python dependencies and running packaged Python modules to produce HTML/PDF/JSON reports and insights. The runtime instructions focus on report construction, exporting, and local analysis; they do not instruct the agent to read unrelated system files or send data to external endpoints. The SKILL.md even mandates review of outputs before delivery and forbids hand-writing insights for real data.
Install Mechanism
There is no formal install spec in the registry (instruction-only), and SKILL.md relies on a platform helper (skillhub_install) or pip. All source files are bundled in the skill. This is generally fine, but note the slight mismatch: requirements.txt omits 'scipy' while some examples and ai_insights.py import scipy.stats; SKILL.md lists scipy in manual install commands. You should install dependencies in a virtual environment and verify the dependency list before running.
Credentials
The skill requests no environment variables, credentials, or special config paths. The code imports common Python data libraries (pandas/numpy/matplotlib/jinja2/scipy) which are proportionate to data analysis and report generation.
Persistence & Privilege
Skill is not always-enabled and does not request platform privileges. It is user-invocable and can be run locally; nothing in the bundle attempts to persistently modify other skills or system-wide settings.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install sql-report-generator
  3. After installation, invoke the skill by name or use /sql-report-generator
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.1
sql-report-generator v1.0.1 - Skill 名称由 `report-generator` 更名为 `sql-report-generator`,以便与数据分析流程和相关组件(sql-master、sql-dataviz)统一命名规范。 - 所有相关 Python 包导入示例、协作说明等同步改为新名称(如 `from sql_report_generator.scripts...`)。 - SKILL.md 内协作流程、快速开始示例等文档内容完全替换为新名称,保持一致性和易用性。 - 其余功能说明、依赖、核心能力、文件结构等内容不变。
v1.0.0
SQL Report Generator 1.0.0 - 新增报告生成智能体 - 覆盖17个行业、36个预设看板模板 - 内置AI洞察分析引擎(无需API) - 支持交互式组件:表格、矩阵、切片器、导航
Metadata
Slug sql-report-generator
Version 1.0.1
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 2
Frequently Asked Questions

What is SQL Report Generator?

生成生产级SQL查询结果与图表报告,支持表格、矩阵、切片器、多格式导出及统计分析驱动的自动洞察建议。 It is an AI Agent Skill for Claude Code / OpenClaw, with 191 downloads so far.

How do I install SQL Report Generator?

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

Is SQL Report Generator free?

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

Which platforms does SQL Report Generator support?

SQL Report Generator is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created SQL Report Generator?

It is built and maintained by SQLSkills (@sqlskills); the current version is v1.0.1.

💬 Comments