Design a MotherDuck Dive
Use this skill for the visual system and interaction design of a Dive. Pair it with motherduck-create-dive for current React and useSQLQuery mechanics, and with motherduck-build-dashboard when the task also includes defining the analytical story and SQL.
Design Contract
Every designed or redesigned Dive must:
- start at a 320 px viewport and enhance upward
- use fluid containers and responsive grids instead of fixed desktop widths
- expose a light/dark theme control with token-based chart and UI colors, using the system preference as the initial default when practical
- reserve a predictable filter surface: visible on wide screens and a drawer or sheet on narrow screens
- keep charts inside bounded, responsive containers with readable labels at every breakpoint
- use a restrained business-analytics visual language: neutral surfaces, compact hierarchy, visible axes, quiet borders, and limited decoration
- make each KPI component useful on its own with value, label, comparison context, and a small trend or progress visual when the data supports it
- keep customer variation in data, labels, logo, and theme tokens rather than changing the information architecture
- support keyboard use, visible focus, 44 px touch targets, sufficient contrast, and non-color status cues
Avoid ornamental gradients, glass effects, glowing accents, oversized hero metrics, decorative bento layouts, excessive pills, floating shapes, and prose that sounds like a marketing landing page.
Workflow
- Inspect the existing Dive, supplied design paper, screenshots, and live schema before proposing a layout.
- If MotherDuck MCP is available, call
get_dive_guide before writing Dive code and again before any save or update if the guide may have changed. Use it for current runtime and query contracts; use this skill for the responsive shell when generic styling examples conflict with the user's explicit design requirements.
- Define the audience, primary decision, metric hierarchy, filter dimensions, and reuse boundary.
- Sketch the 320 px composition first: header, filter trigger, compact one- or two-column KPI group, primary chart, supporting sections, and detail view.
- Expand that composition into tablet and desktop grids without changing reading order.
- Implement semantic design tokens, theme switching, reusable cards, responsive chart wrappers, and filter state.
- Validate query correctness separately, then preview the complete Dive with loading, empty, error, long-label, and dense-data states.
- Run the screenshot, inspection, iteration, and evidence workflow in
references/VISUAL_QA_PLAYBOOK.md.
- Verify the viewport and theme matrix in
references/RESPONSIVE_DIVE_DESIGN_SYSTEM.md before saving or updating the Dive.
For answer, review, or planning requests, return the requested design artifact without changing a Dive. For build or redesign requests, implement and preview the in-scope Dive; save or update it only when the request includes that operation.
Deliverable
Provide:
- the information hierarchy and component map
- filter behavior on mobile, tablet, and desktop
- breakpoint and reflow rules
- light/dark token roles and chart palette
- reusable component boundaries and customer-specific inputs
- accessibility and responsive QA results
- a versioned evidence bundle with desktop, mobile, theme, and filter screenshots plus a short iteration report
Do not call a design mobile-friendly based only on responsive CSS. Report the viewports and states actually checked.
Open Next
- Read
references/RESPONSIVE_DIVE_DESIGN_SYSTEM.md for the layout grid, component anatomy, theme tokens, filter model, anti-patterns, and QA checklist.
- Read
references/VISUAL_QA_PLAYBOOK.md for the repeatable screenshot, visual inspection, iteration, and reviewer handoff loop.
Related Skills
motherduck-create-dive for the current component contract, preview, save/update, and required resources
motherduck-build-dashboard for the analytical story, section queries, and end-to-end dashboard workflow
motherduck-explore for discovering real dimensions and filter candidates
motherduck-query for validating the SQL behind each visual state
1---2name: motherduck-design-dive-23description: Design or redesign a MotherDuck Dive as a responsive, reusable analytics interface. Use when a Dive must be mobile-friendly from the start, support light and dark modes, reserve space for filters, use restrained Power BI-style information design, embed small charts inside metric components, or work across customers without one-off layout changes.4argument-hint: [dive-or-design-goal]5license: MIT6metadata:7 source: https://skillmd.com/skills/majiayu000/motherduck-design-dive-28---910# Design a MotherDuck Dive1112Use this skill for the visual system and interaction design of a Dive. Pair it with `motherduck-create-dive` for current React and `useSQLQuery` mechanics, and with `motherduck-build-dashboard` when the task also includes defining the analytical story and SQL.1314## Design Contract1516Every designed or redesigned Dive must:1718- start at a 320 px viewport and enhance upward19- use fluid containers and responsive grids instead of fixed desktop widths20- expose a light/dark theme control with token-based chart and UI colors, using the system preference as the initial default when practical21- reserve a predictable filter surface: visible on wide screens and a drawer or sheet on narrow screens22- keep charts inside bounded, responsive containers with readable labels at every breakpoint23- use a restrained business-analytics visual language: neutral surfaces, compact hierarchy, visible axes, quiet borders, and limited decoration24- make each KPI component useful on its own with value, label, comparison context, and a small trend or progress visual when the data supports it25- keep customer variation in data, labels, logo, and theme tokens rather than changing the information architecture26- support keyboard use, visible focus, 44 px touch targets, sufficient contrast, and non-color status cues2728Avoid ornamental gradients, glass effects, glowing accents, oversized hero metrics, decorative bento layouts, excessive pills, floating shapes, and prose that sounds like a marketing landing page.2930## Workflow31321. Inspect the existing Dive, supplied design paper, screenshots, and live schema before proposing a layout.332. If MotherDuck MCP is available, call `get_dive_guide` before writing Dive code and again before any save or update if the guide may have changed. Use it for current runtime and query contracts; use this skill for the responsive shell when generic styling examples conflict with the user's explicit design requirements.343. Define the audience, primary decision, metric hierarchy, filter dimensions, and reuse boundary.354. Sketch the 320 px composition first: header, filter trigger, compact one- or two-column KPI group, primary chart, supporting sections, and detail view.365. Expand that composition into tablet and desktop grids without changing reading order.376. Implement semantic design tokens, theme switching, reusable cards, responsive chart wrappers, and filter state.387. Validate query correctness separately, then preview the complete Dive with loading, empty, error, long-label, and dense-data states.398. Run the screenshot, inspection, iteration, and evidence workflow in `references/VISUAL_QA_PLAYBOOK.md`.409. Verify the viewport and theme matrix in `references/RESPONSIVE_DIVE_DESIGN_SYSTEM.md` before saving or updating the Dive.4142For answer, review, or planning requests, return the requested design artifact without changing a Dive. For build or redesign requests, implement and preview the in-scope Dive; save or update it only when the request includes that operation.4344## Deliverable4546Provide:4748- the information hierarchy and component map49- filter behavior on mobile, tablet, and desktop50- breakpoint and reflow rules51- light/dark token roles and chart palette52- reusable component boundaries and customer-specific inputs53- accessibility and responsive QA results54- a versioned evidence bundle with desktop, mobile, theme, and filter screenshots plus a short iteration report5556Do not call a design mobile-friendly based only on responsive CSS. Report the viewports and states actually checked.5758## Open Next5960- Read `references/RESPONSIVE_DIVE_DESIGN_SYSTEM.md` for the layout grid, component anatomy, theme tokens, filter model, anti-patterns, and QA checklist.61- Read `references/VISUAL_QA_PLAYBOOK.md` for the repeatable screenshot, visual inspection, iteration, and reviewer handoff loop.6263## Related Skills6465- `motherduck-create-dive` for the current component contract, preview, save/update, and required resources66- `motherduck-build-dashboard` for the analytical story, section queries, and end-to-end dashboard workflow67- `motherduck-explore` for discovering real dimensions and filter candidates68- `motherduck-query` for validating the SQL behind each visual state