A comprehensive data analysis suite that integrates database connectivity, SQL execution, interactive visualization, and AI-powered report generation.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install sql-database-toolkit
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install sql-database-toolkit using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is SQL Database Toolkit?
The SQL Database Toolkit is a professional-grade integration of sql-master, sql-dataviz, and sql-report-generator. It provides a seamless end-to-end workflow for developers and data analysts using Openclaw Skills, moving from initial database connection to final executive reporting. It supports a wide array of databases including MySQL, PostgreSQL, and SQLite, alongside local file formats like CSV, Excel, and Parquet.
By combining these Openclaw Skills into a unified pipeline, users can leverage natural language to SQL translation, automated anomaly detection, and professional-grade visualizations. Whether you are building interactive HTML dashboards or generating static reports for stakeholders, this toolkit provides the necessary abstractions to handle complex data lifecycles efficiently.
SQL Database Toolkit Use Cases
- Building automated business intelligence pipelines from SQL databases to HTML reports.
- Performing AI-driven trend analysis and anomaly detection on financial or sales data.
- Creating interactive KPI dashboards with Power BI-style aesthetics for executive reviews.
- Migrating and analyzing local file data (CSV/Excel) using standard SQL syntax.
- Optimizing database queries and generating natural language insights for technical teams.
How SQL Database Toolkit Works
- Connect to a data source using the database_connector for SQL engines or the file_connector for local formats.
- Execute SQL queries to filter, aggregate, and transform data into pandas DataFrames.
- Apply the ai_insights module to automatically detect outliers, correlations, and key performance indicators.
- Utilize the ChartFactory to generate either static PNG images or interactive Plotly-based HTML charts.
- Assemble all components into a professional report using industry-specific templates and the DashboardBuilder.
SQL Database Toolkit Setup
Install the core dependencies and database drivers using the following command:
pip install pandas numpy sqlalchemy pymysql psycopg2-binary matplotlib seaborn plotly scipy jinja2
Ensure that your environment has the appropriate fonts installed for Chinese character rendering (e.g., Microsoft YaHei on Windows) to maintain visual consistency in reports produced by these Openclaw Skills.
SQL Database Toolkit Data Schema & Taxonomy
The toolkit organizes its operations through a modular architecture to ensure data integrity across the pipeline:
| Layer | Key Components | Data Output |
|---|---|---|
| Connection | database_connector, file_connector | SQLAlchemy Engine / Pandas DataFrame |
| Processing | SQL Pipeline, AI Insights | Statistical Summaries / JSON Meta |
| Visualization | Static (Matplotlib) / Interactive (Plotly) | Base64 PNG / HTML Components |
| Reporting | Template Engine, Dashboard Builder | Unified HTML / PDF Reports |
SQL Database Toolkit Advanced Features
- Multi-dialect support for 6+ major database systems including ClickHouse and SQL Server.
- Extensive template library containing over 90 industry-specific report layouts.
- High-level UnifiedPipeline for one-click file-to-report automation.
- Customizable aesthetic themes including Power BI, Alibaba, Tencent, and Bytedance styles.
- Automated KPI card generation with built-in trend and percentage change calculations.
SKILL.md
Loading
Related Openclaw Skills
Graph-RAG Memory Skill
A temporal Graph-RAG system providing AI agents with persistent, queryable long-term memory through a Mixture-of-Experts knowledge graph architecture.
PDF Translator
A sophisticated translation engine that preserves complex document layouts by leveraging LaTeX reconstruction and direct arXiv source integration.
Mind-Wander
An autonomous background reasoning agent that explores open questions and hypotheses using local models without consuming your primary token budget.
Hyperliquid Names (HLN) API
An AI agent skill designed to interact with the Hyperliquid Names API for domain resolution, profile lookups, and HyperEVM integration.
OpenClaw Pilot
OpenClaw Pilot is an instruction-first skill that compiles rough ideas into a human-readable blueprint and a clean, machine-ready OpenClaw execution packet.
MD Viewer
A secure, LAN-accessible web viewer designed to render Markdown files into a clean, e-reader optimized interface for immediate reading across devices.
Featured*
