A specialized automation tool that converts markdown-based SQL query collections into functional BI dashboard prototypes, complete with backend and frontend services.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install sql-to-bi-builder
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-to-bi-builder 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 to BI Builder?
SQL to BI Builder is a high-productivity skill designed to bridge the gap between raw data queries and visual business intelligence. By analyzing structured markdown files containing SQL blocks, it intelligently infers metrics, dimensions, and time grains to recommend the most effective chart types. This Openclaw Skills component automates the tedious process of manual dashboard assembly, allowing developers to move from query to a live, service-based prototype in minutes.
The tool doesn't just suggest visuals; it generates a complete service bundle. This includes a FastAPI-based backend and a responsive frontend UI scaffold. It is particularly effective for rapid prototyping, internal tool generation, and data-driven demo creation where speed and technical accuracy are paramount.
SQL to BI Builder Use Cases
- Rapidly prototyping analytics dashboards from existing SQL query libraries.
- Generating full-stack BI interfaces with automated backend API and frontend scaffolding.
- Converting complex SQL WHERE predicates into functional UI filter metadata.
- Standardizing the transition from raw data exploration to production-ready visualization layers.
How SQL to BI Builder Works
- The skill parses markdown SQL blocks into a normalized query catalog for structured processing.
- It performs semantic inference to identify metrics, dimensions, and temporal granularity.
- P0 filter candidates are extracted from SQL DSL predicates to create structured filter metadata.
- Chart types are automatically recommended based on the inferred data semantics.
- A comprehensive dashboard specification is built, including layout coordinates and widget sizing.
- The system generates a UI scaffold and a full service bundle comprising both frontend and backend services.
- Users launch the generated services using provided shell scripts to view the live BI dashboard.
SQL to BI Builder Setup
To use this skill within the Openclaw Skills ecosystem, ensure Python 3.11 is available in your PATH. Execute the following commands from the skill folder:
# Create the virtual environment
bash scripts/setup_venv.sh
# Activate the environment
source .venv/bin/activate
# Run the full pipeline to generate services
python scripts/run_pipeline.py --input /path/to/sql.md --out /path/to/out --with-services
SQL to BI Builder Data Schema & Taxonomy
The skill generates a series of JSON artifacts and directory structures to organize the BI metadata:
| File/Folder | Description |
|---|---|
| query_catalog.json | Contains parsed query units and core metadata. |
| semantic_catalog.json | Details field roles, grain hints, and extracted DSL filters. |
| chart_plan.json | Maps each query to a recommended visualization type. |
| dashboard.json | The final definition for rendering, including global filters and layout. |
| services/ | Contains the generated FastAPI backend and frontend application code. |
SQL to BI Builder Advanced Features
- Multi-step pipeline execution for granular debugging of parser, semantic, and layout rules.
- Advanced filter support for multiple date formats including ISO-8601, Unix timestamps, and custom string patterns.
- UI Upgrade features (2026-03) including KPI summary strips, 'Midnight Ops' theme presets, and switchable layout modes.
- Automated service generation producing ready-to-run start_backend.sh and start_frontend.sh scripts.
SKILL.md
Loading
Related Openclaw Skills
Open Anything
A cross-platform utility that translates natural language requests into the correct OS commands for opening files, directories, and web URLs.
Proxy Management Skill
A local-first proxy inventory engine for organizing assets, tracking health, and planning intelligent routing without cloud dependencies.
WeChat to Notion
A powerful AI automation tool that fetches WeChat articles and archives them into a structured Notion database with automated analysis.
Harness Engineering
Harness Engineering is a methodology to evolve repositories for maximum AI agent legibility through repo-local artifacts and executable governance.
Ultralytics YOLO Vision Tools
A comprehensive computer vision toolkit for AI agents to perform object detection, segmentation, and motion tracking using the latest YOLO architectures.
Markdown to HTML & PDF Converter
A local processing tool for seamless conversion between Markdown, HTML, and PDF formats.
Featured*
