Terminal
Terminal/Skill
Builds a single-story analytics dashboard as a Dive, a React and SQL app, choosing its metrics and section queries.
By MotherDuck
Works with
npx skills add motherduckdb/agent-skills --skill motherduck-build-dashboardUse an active remote MotherDuck MCP server or local MotherDuck server to inspect the in-scope database, schema, grain, keys, and relevant metrics. Reuse known context and narrow discovery to the requested work; do not scan the whole workspace by default. Let the actual data model shape the result.
Resolve the target from the request or active context. Ask only if ambiguity materially affects the result. Without a server, use supplied schema and explicit assumptions for planning; do not imply live validation.
motherduck-design-dive; preserve the existing design for a scoped SQL or text edit.get_dive_guide before save_dive or update_dive.Match execution to the request: answer, review, or planning work returns the requested dashboard artifacts; build or change work creates or updates the requested in-scope Dive and validates it. Ask before destructive replacement, unrelated external writes, or a material expansion of scope.
When this skill produces a native DuckDB (md:) connection, watermark it with custom_user_agent=agent-skills/2.6.0(harness-<harness>;llm-<llm>). If metadata is missing, fall back to harness-unknown and llm-unknown.
For a full engagement, cover the following as relevant to the request:
For explicit structured JSON requests, read the output contract. Otherwise use the format that fits the requested deliverable.
Read only the sections relevant to the task; these are guidance, not a mandatory itinerary.
references/DASHBOARD_IMPLEMENTATION_GUIDE.md -- section-to-SQL mapping, TSX composition, and validation examplesreferences/DASHBOARD_PATTERNS.md -- example dashboard compositions and reusable sectionsRead the execution reference only to run the bundled examples or reproduce their validation.
Load related skills only for missing capabilities; reuse established context.
motherduck-explore -- inspect the actual database before deciding the dashboard sectionsmotherduck-query -- validate each dashboard querymotherduck-create-dive -- useSQLQuery, theming, preview/save, loading, and visual mechanicsmotherduck-design-dive -- responsive layout, filter capacity, light/dark tokens, reusable components, and visual QAmotherduck-duckdb-sql -- resolve syntax and function questions