Motherduck Build Dashboard

---
name: motherduck-build-dashboard
description: Build a live MotherDuck dashboard as a Dive. Use when composing one shareable KPI, trend, and breakdown story over existing MotherDuck data, especially when the result should stay a saved workspace artifact rather than a full application.
license: MIT
---

# Build an Analytics Dashboard

Use this skill when the user wants a multi-section Dive-backed dashboard with a clear analytical story, not just a single chart.

This is a use-case skill. It orchestrates `motherduck-explore`, `motherduck-query`, and `motherduck-create-dive`; use `motherduck-duckdb-sql` as supporting reference when exact syntax matters.

## Start Here: Is a MotherDuck Server Active?

Always determine this before designing the dashboard.

- If a **remote MotherDuck MCP server** or **local MotherDuck server** is active, use it.
- If the target database is unclear, ask which database or workspace the dashboard should run against.
- Explore the live data model before choosing the dashboard structure:
  - available tables and views
  - business grain
  - key metrics
  - key dimensions
  - date columns
  - likely joins… install to load the full skill