dashboard-bootstrap

Extracts SQL and metrics from BI dashboards into reference SQL and semantic models via plugins.

1.7k|248|Updated Jul 4, 2025
One-click install
npx skills add https://github.com/Datus-ai/Datus-agent --skill dashboard-bootstrap
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dashboard-bootstrap
Source: https://github.com/Datus-ai/Datus-agent/tree/main/datus/resources/skills/dashboard-bootstrap
Command: npx skills add https://github.com/Datus-ai/Datus-agent --skill dashboard-bootstrap

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Teams often have valuable business logic locked inside BI dashboards, and manually rewriting dashboard queries into reusable reference SQL and semantic metrics is slow and error-prone. This Skill automates that bootstrap process through an installed BI plugin while enforcing strict validation and confirmation gates.

Core Features & Use Cases

  • Plugin-driven dashboard export: Selects a BI plugin, profile, and dashboard, then exports stable query candidates with checksums and source identities.
  • Independent reference SQL and metric routing: Sends exported SQL to the gen_sql_summary agent for reference SQL indexing and to the semantic_modeling agent for metric and semantic model authoring.
  • Datasource identity matching: Matches each query's credential-free source identity to configured Datus datasources, deferring or blocking ambiguous matches instead of guessing.
  • Use Case: A data engineer connects a Metabase or similar BI plugin, selects a sales dashboard, confirms the generation manifest, and automatically builds indexed reference SQL plus Dosi semantic metrics for the matched datasource.

Quick Start

Ask the agent to bootstrap reference SQL and metrics from a specific BI dashboard using the installed plugin and confirm the generation manifest it presents.

Frequently Asked Questions about dashboard-bootstrap

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I import SQL from a BI dashboard into Datus?

Use the dashboard bootstrap workflow with an installed BI plugin that supports listing dashboards, exporting query SQL, and reporting checksums. After selecting the plugin, profile, and dashboard, confirm the generation manifest and the workflow routes exported SQL to the gen_sql_summary agent.

How do I generate semantic metrics from dashboard queries?

Select metric candidates independently from reference SQL candidates during the bootstrap workflow. Exported SQL is grouped by matched datasource and business domain, then sent to the semantic_modeling agent, which authors Dosi YAML models and metrics against the active datasource.

What plugins work with dashboard bootstrap?

Any installed plugin whose bundled skill documents dashboard listing, stable query candidate listing, selective or full-dashboard export with a manifest, per-query file and checksum reporting, and credential-free source identity reporting. If no plugin meets this contract, the workflow stops and names the missing capabilities.

Why does dashboard bootstrap stop before exporting SQL?

The workflow enforces a confirmation gate: it prints a generation manifest and stops unless auto_run was explicitly requested. Discovery is read-only before confirmation, so export commands are never invoked for preview, probing, or validation.

What happens when a dashboard query matches multiple datasources?

The query is marked ambiguous and metric generation stops for it until the user explicitly resolves the datasource. Reference SQL may still proceed, and queries matching a non-active datasource are deferred to a later run rather than switching the shared datasource.

Can dashboard bootstrap create subagents for a dashboard?

Yes, as an optional final step when the create-subagent skill is available. It creates a gen_sql node and an attribution gen_report node scoped only to successfully built artifacts for the active datasource, using validated canonical subject references.