motherduck-create-dive

Create interactive MotherDuck Dives with live SQL queries, theming, and embedding support.

Updated Oct 15, 2019
One-click install
npx skills add https://github.com/kkkaoru/dotfiles --skill motherduck-create-dive-kkkaoru
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: motherduck-create-dive
Source: https://github.com/kkkaoru/dotfiles/tree/main/.agents/skills-stroage/motherduck-create-dive
Command: npx skills add https://github.com/kkkaoru/dotfiles --skill motherduck-create-dive-kkkaoru

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Building persistent, shareable analytics views on MotherDuck requires coordinating live SQL validation, React/Recharts presentation, theming, loading states, and save-or-embed workflows, which is error-prone without a structured guide. ## Core Features & Use Cases - Live SQL-backed Dives: Build Dives using useSQLQuery with fully qualified, validated queries against real MotherDuck schemas, including loading, empty, and error states for every section. - Theming and Design Guidance: Start from named theme directions like Corporate Dashboard, Tufte Minimal, or FT Salmon, with a detailed reference covering Recharts components, Tailwind utilities, color palettes, and chart-selection rules. - Save, Version, and Embed: Manage Dives as code, inspect version history via list_dives and read_dive, and embed read-only Dives using short-lived server-side sessions. - Use Case: A data analyst needs a shareable revenue dashboard on MotherDuck; this Skill validates the SQL, builds a multi-query Dive with KPIs, charts, and tables, previews it locally, and saves it with a consistent theme. ## Quick Start Ask the assistant to create a MotherDuck Dive showing monthly revenue by category from your database, with a Corporate Dashboard theme and loading states for each section.

Frequently Asked Questions about motherduck-create-dive

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

FAQPage Schema
How do I create a MotherDuck Dive with live SQL queries?

Validate your SQL against the live schema first, then build the Dive using useSQLQuery hooks with one query per visual section. Call get_dive_guide via MotherDuck MCP if available, preview locally, and save only after loading and error states work.

What chart library do MotherDuck Dives use?

Dives use Recharts components wrapped in ResponsiveContainer, including BarChart, LineChart, PieChart, AreaChart, and ScatterChart. Tables are recommended for fewer than eight categories, and Pie charts only for two to six slices.

Can I embed a MotherDuck Dive in my own application?

Yes, embedding uses a backend-created session so the browser only receives a short-lived token, never admin credentials. Embedded Dives are read-only, sessions expire after 24 hours, and a Business plan is typically required.

How do I update an existing Dive without losing previous versions?

Every saved update creates a new version. Use list_dives to check current_version and read_dive with a version number to inspect historical content before overwriting, treating older versions as read-only unless restoring.

When should I use a Dive instead of a full analytics app?

Use a Dive for persistent, shareable, read-only live analytics surfaces. Move to a custom app approach when you need writes, custom backend contracts, non-Dive routing, or richer authorization and per-customer isolation.