← Back to Skills Marketplace
SQL to BI Builder
by
bamboo9805
· GitHub ↗
· v1.2.0
· MIT-0
266
Downloads
0
Stars
0
Active Installs
5
Versions
Install in OpenClaw
/install sql-to-bi-builder
Description
Convert a markdown file containing SQL queries (for example `sql.md`) into a BI dashboard specification and UI scaffold. Use when user asks to build analytic...
Usage Guidance
This skill appears to do what it claims: parse SQL markdown and emit a dashboard spec, a static UI scaffold (which loads fonts/echarts from public CDNs), and a local FastAPI demo backend that serves synthetic preview data. Before running: ensure you use a dedicated working directory or specify an output path you control (the scripts write files and may start local services), install Python 3.11 in a virtualenv as instructed, and inspect the generated services/start scripts if you plan to run them (the demo backend enables CORS and listens on localhost by default). There are no hidden network exfiltration signals or credential requests, but avoid feeding real production credentials or sensitive SQL containing secrets into any demo outputs without reviewing how you store/share the generated files.
Capability Analysis
Type: OpenClaw Skill
Name: sql-to-bi-builder
Version: 1.2.0
The skill bundle is a legitimate tool designed to transform SQL queries within markdown files into functional BI dashboard prototypes. It contains a pipeline of Python scripts (e.g., parse_sql_md.py, infer_semantics.py, and generate_service_bundle.py) that handle SQL parsing, metadata extraction, and the generation of a FastAPI backend and a static frontend. While the tool executes shell scripts and manages virtual environments, these actions are consistent with its stated purpose of local service generation and deployment. No indicators of data exfiltration, unauthorized persistence, or malicious prompt injection were identified.
Capability Assessment
Purpose & Capability
The name/description match the actual files and behavior: parsing sql.md, inferring semantics, recommending charts, building dashboard.json, scaffolding a frontend, and emitting a demo FastAPI backend. No environment variables, external credentials, or unrelated binaries are required.
Instruction Scope
SKILL.md directs only local actions (create venv, run the included Python scripts, write outputs to user-specified paths, and optionally start local demo services). The instructions reference repository-local files and tooling (pyproject, .python-version) for correctness; they do not instruct reading unrelated system files or sending data to external endpoints. The frontend scaffold does reference public CDNs for fonts and echarts (normal for a UI demo).
Install Mechanism
There is no install spec; the skill is instruction-plus-scripts and runs in a Python venv. All code is bundled with the skill; no remote downloads or archive extraction are performed by the skill itself (aside from typical CDN usage in generated frontend HTML).
Credentials
The skill declares no required environment variables or credentials and the scripts do not attempt to read secrets. Runtime notes ask for Python 3.11 and optional dev deps (PyYAML) which are proportional to the parsing/generation tasks.
Persistence & Privilege
The skill does not request always:true and will not auto-inject itself. It writes generated artifacts to an output directory specified by the user and can start local services; this is expected for a scaffold generator and does not modify other skills or system-wide agent settings.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install sql-to-bi-builder - After installation, invoke the skill by name or use
/sql-to-bi-builder - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.2.0
Fix: Theme Studio visibility on medium screens; update docs
v1.1.2
Fix: Theme Studio visibility on medium screens; update docs
v1.1.1
Fix: Theme Studio visibility on medium screens; update docs
v1.1.0
UI-upgrade documentation sync (KPI strip, focus layout, midnight theme) and usage updates
v1.0.0
Initial public release
Metadata
Frequently Asked Questions
What is SQL to BI Builder?
Convert a markdown file containing SQL queries (for example `sql.md`) into a BI dashboard specification and UI scaffold. Use when user asks to build analytic... It is an AI Agent Skill for Claude Code / OpenClaw, with 266 downloads so far.
How do I install SQL to BI Builder?
Run "/install sql-to-bi-builder" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is SQL to BI Builder free?
Yes, SQL to BI Builder is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does SQL to BI Builder support?
SQL to BI Builder is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created SQL to BI Builder?
It is built and maintained by bamboo9805 (@bamboo9805); the current version is v1.2.0.
More Skills