Build cloud data apps from prompts with Claude Code and MotherDuck

Watch MotherDuck's Alex Monahan connect Claude Code to MotherDuck and build a live data app from one prompt.

Who it's for: Analysts and data engineers who want DuckDB in the cloud.

The problem: The modern data stack stitches separate tools together, which adds overhead and leaves an agent without the full picture.

Alex adds the hosted MotherDuck MCP connector with no local setup. From one prompt, the agent writes a Flight, a scheduled Python job loading Disney World wait times, and a Dive, a React app comparing live waits with history. When the Flight fails, the DuckDB error message shows the fix.

Takeaways:

  • Have the agent explore your data with SQL first.
  • Expect to iterate.
  • Review important Dives through Git.
  • Try DuckLake for simpler lakehouse tables.

Resources