motherduckdb/agent-skills / plugins/motherduck-skills-claude/skills/motherduck-build-dashboard
motherduck-build-dashboard
VerifiedBuild a MotherDuck dashboard as a Dive, choosing the analytical story, metrics, and section queries.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 4.4 KB |
| artifacts/dashboard_story_example.py | script | 3.0 KB |
| artifacts/dashboard_story_example.ts | script | 2.8 KB |
| references/DASHBOARD_IMPLEMENTATION_GUIDE.md | markdown | 20.2 KB |
| references/DASHBOARD_PATTERNS.md | markdown | 24.0 KB |
| references/EXECUTION_REFERENCE.md | markdown | 1.6 KB |
artifacts/dashboard_story_example.py
View on GitHubimport json
import sys
from pathlib import Path
import duckdb
sys.path.append(str(Path(__file__).resolve().parents[3]))
from scripts._lib.motherduck_artifact_utils import artifact_session
def one(conn: duckdb.DuckDBPyConnection, sql: str) -> dict:
cursor = conn.execute(sql)
columns = [col[0] for col in cursor.description]
row = cursor.fetchone()
return dict(zip(columns, row))
def many(conn: duckdb.DuckDBPyConnection, sql: str) -> list[dict]:
cursor = conn.execute(sql)
columns = [col[0] for col in cursor.description]
return [dict(zip(columns, row)) for row in cursor.fetchall()]
def main() -> None:
with artifact_session(slug="motherduck-build-dashboard", database_keys=["analytics"]) as session:
conn = session.conn
orders_table = session.table("analytics", "main", "orders")
conn.execute(
f"""
CREATE TABLE {orders_table} (
order_id INTEGER,
order_date DATE,
category VARCHAR,
customer_id INTEGER,
revenue DOUBLE
)
"""
)
conn.executemany(
f"INSERT INTO {orders_table} VALUES (?, ?, ?, ?, ?)",
[
(1, "2026-01-03", "Database", 101, 1200.0),
(2, "2026-01-07", "Compute", 102, 800.0),
(3, "2026-02-11", "Database", 101, 1600.0),
(4, "2026-02-21", "Sharing", 103, 400.0),
(5, "2026-03-03", "Compute", 104, 2200.0),
(6, "2026-03-18", "Database", 105, 900.0),
],
)
result = {
"backend": session.describe(),
"story": "Revenue and product mix",
"kpis": one(
conn,
f"""
SELECT
SUM(revenue) AS total_revenue,
COUNT(DISTINCT order_id) AS order_count,
COUNT(DISTINCT customer_id) AS customer_count
FROM {orders_table}
""",
),
"trend": many(
conn,
f"""
SELECT strftime(date_trunc('month', order_date), '%Y-%m') AS month,
SUM(revenue) AS revenue
FROM {orders_table}
GROUP BY 1
ORDER BY 1
""",
),
"breakdown": many(
conn,
f"""
SELECT category, SUM(revenue) AS revenue
FROM {orders_table}
GROUP BY 1
ORDER BY revenue DESC
""",
),
"detail": many(
conn,
f"""
SELECT strftime(order_date, '%Y-%m-%d') AS order_date,
category,
revenue
FROM {orders_table}
ORDER BY order_date DESC
LIMIT 5
""",
),
}
print(json.dumps(result, indent=2))
if __name__ == "__main__":
main()
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |