Skip to main content

Beyond Charts: Building Interactive Data Apps with MotherDuck Dives

Mar 26, 2026Featuring: ,

What you'll learn

MotherDuck Dives let you build interactive data applications on top of your data warehouse without a separate frontend framework. This session walks through the full workflow, from querying data to publishing a shareable app.

What are Dives?

Dives are MotherDuck's built-in tool for creating interactive data apps. Instead of exporting query results to a separate BI tool, you write React components that pull data directly from your MotherDuck databases. The result is a live app your team can use without waiting on data engineering to hand something off.

Building your first Dive

The session covers how to get started: writing SQL queries in MotherDuck, wrapping results in React components, adding filters, drill-downs, and parameter controls. If you've used tools like Evidence or Streamlit, Dives will feel familiar, but everything runs inside MotherDuck itself.

Going beyond dashboards

Dives get more interesting once you move past standard charts. You can build calculators, data entry forms, custom reporting tools, internal apps that pull from multiple data sources. The talk shows real examples, like a customer health scoring tool and an operational monitoring setup, all backed by live SQL queries against your data warehouse.

Sharing and collaboration

Every Dive gets a shareable URL. You can publish them to your team, embed them, or keep them private for your own analysis. The session covers how sharing works and how to manage access for different audiences.

FAQS

Dives are interactive data apps that run inside MotherDuck. You write React components that query your data warehouse in real time, and you get live apps with charts, tables, filters, and whatever other UI you want. They're a way to build something more useful than a static dashboard without spinning up a separate frontend.

You need a MotherDuck account and some familiarity with SQL. Dives use React for the frontend, but you don't need much React experience to get started. The patterns are simple enough that you can build useful apps with just SQL knowledge and basic component templates.

Yes. Every Dive has its own URL you can send to teammates or stakeholders. You control who has access, and viewers can interact with live data without writing SQL. You can also share the underlying data that powers a Dive with your organization.

Related Videos

"Jev for Analytics: 5 Use Cases on Real Data" video thumbnail

43:57

Oct 8, 2026

Jev for Analytics: 5 Use Cases

Mehdi Ouazza uses MotherDuck's prompt_jev() to turn text columns into columns you can GROUP BY. He classifies 100,000 consumer complaints, then walks through five use cases on real data: AI agent logs, Hacker News sentiment, sales calls, and two kinds of job-ad analysis.

Stream

MotherDuck Features

AI ML and LLMs

"Virtual Workshop: Build a Data Agent in 60 Minutes" video thumbnail

51:58

Oct 1, 2026

Build a Data Agent in 60 Minutes

Jacob Matson walks through a working data chat agent he built: MCP tools, an agentic loop, a tuned system prompt, hard-coded read-only guardrails, and telemetry. He demos it live against a real dataset, walks through the actual codebase, then shows the same backend re-platformed into a Slack bot.

Stream

MotherDuck Features

AI ML and LLMs

Data Pipelines

"We Classified 100,000 Rows in 40 Seconds: Introducing prompt_jev()" video thumbnail

49:02

Sep 29, 2026

prompt_jev(): SQL-Native Text Classification

MotherDuck's new prompt_jev() function runs text classification directly from SQL using Jev, a decision-focused model from typesafe.ai. In a live demo, Jacob Matson, Dumky de Wilde, and Hamilton Ulmer showed it filtering, disambiguating, and re-ranking real data without leaving SQL. The number they kept coming back to: 100,000 rows classified at 89% accuracy in 40 seconds, compared to 32 minutes and $37.58 for a comparable LLM call.

Stream

MotherDuck Features

AI ML and LLMs

Data Pipelines