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, motherduck-create-dive, and motherduck-design-dive; use motherduck-duckdb-sql as supporting reference when exact syntax matters.

Start Here: Is a MotherDuck Server Active?

• If a remote MotherDuck MCP server or local MotherDuck server is active, use it.
• Discover the target database or workspace from the active context. Ask only when multiple plausible targets remain and the choice would materially change the dashboard.
• Explore the live data model before choosing the dashboard structure:
  • available tables and views
  • business grain
  • key metrics
  • key dimensions
  • date columns
  • likely joins

The discovered data model should determine the dashboard story and sections.