Skip to main content

Alex Monahan

Alex Monahan's photo

Developer Advocate

Alex joins us from Intel where he worked as a data scientist building a DuckDB-powered analytics platform.

36 BLOG POSTS AND VIDEOS

Introducing Dive Apps: Superpowers for AI Builders

Introducing Dive Apps: Superpowers for AI Builders

Oct 29, 2026 • Alex Monahan

MotherDuck is launching Dive Apps: fully custom data apps that can write-back anywhere. Build them with your agent and they run on the MotherDuck data warehouse. Use Dive Apps to replace SaaS apps, automate your operations, or bring humans into the loop to steer your agents.

"DuckLake Performance Optimization: Faster Queries From Your Lakehouse" video thumbnail

64:46

DuckLake Performance Optimization

Oct 27, 2026 • Alex Monahan, Matt Martin

Alex Monahan and Matt Martin, co-authors of O'Reilly's DuckLake: The Definitive Guide, walk through how to make DuckLake queries faster: finding the bottleneck, partitioning and sorting so queries skip files and row groups, tuning Parquet settings together, and keeping the catalog lean.

Stream

SQL

MotherDuck Features

"Behind the Agent: How Hazel Built an AI Coworker for Consumer Brands" video thumbnail

51:02

How Hazel Built an AI Coworker

Oct 21, 2026 • Alex Monahan

Patrik Devlin, co-founder and CTO of Hazel, joins host Alex Monahan to show Hazel in a demo account and walk through the stack behind it: Fivetran and dlt into S3, dbt in MotherDuck, and a separate database for every customer.

Stream

MotherDuck Features

AI, ML and LLMs

Data Pipelines

Build It Yourself: What You'll Make at the Data Outpost Workshops

Build It Yourself: What You'll Make at the Data Outpost Workshops

Oct 5, 2026 • Alex Monahan

Data Outpost kicks off on November 4, 2026 in San Francisco with 11 hands-on workshops from MotherDuck, Vercel, Sigma, Prefect, Estuary, Airbyte, Reducto, Braintrust, and Together AI. Here's what you'll build in each one: your own agents, the data pipelines they need, and the skills to run them in production.

AI Needs Data, Data Needs AI: What You'll Learn at Data Outpost

AI Needs Data, Data Needs AI: What You'll Learn at Data Outpost

Oct 1, 2026 • Alex Monahan

Data Outpost is an AI and data conference in San Francisco. Its main day, November 5, 2026, has 13 talks and panels from teams at Canva, Stripe, DoorDash, Posit, dbt and more. Here's what each session covers, from agents that write back to context layers, SQL harnesses, and AI for regulated data, and what you'll walk away with.

dbt Charts on MotherDuck: Declarative Dashboards

dbt Charts on MotherDuck: Declarative Dashboards

Sep 21, 2026 • Alex Monahan

Define your dashboards in YAML with dbt Charts, then the same dbt build that runs your pipeline deploys them to MotherDuck Dives. Just 2 config changes! Your Dives will refresh live whenever your stakeholders take a look. See how we constructed the dbt package as well.

Agents Don’t Query Like Humans Do

Agents Don’t Query Like Humans Do

Sep 2, 2026 • Alex Monahan

We analyzed a slice of MotherDuck query history and found agents ran 29 times more queries than humans last month, a gap that has roughly doubled every month. The average organization now has twice as many agents as human users. Agents are the dominant consumers of the data platform, and our systems can't afford to stay the same.

Agentic SQL for Free with Qwen3.8 27B and DuckDB

Agentic SQL for Free with Qwen3.8 27B and DuckDB

Aug 28, 2026 • Alex Monahan

If your laptop has 16GB of RAM, your agent can write SQL locally for free with Qwen3.8 27B. On the DABstep SQL benchmark, Qwen beat GPT 5.6 Luna and cost under 50 cents in electricity, over 17x less. Add DuckDB and you have a data analyst that runs on your own machine. This post covers the benchmark results and walks through the setup, including which quantized model to download for your laptop.

"Do AI Agents Need a Semantic Layer?" video thumbnail

60:29

Do AI Agents Need a Semantic Layer?

Aug 26, 2026 • Alex Monahan, Jacob Matson

Do AI agents need a semantic layer? Evals comparing plain-text context with a Malloy semantic layer show where each wins, and what it costs.

Stream

AI, ML and LLMs

BI & Visualization

SQL

AI Writes the Semantic Layer

AI Writes the Semantic Layer

Aug 20, 2026 • Jacob Matson, Alex Monahan

We proved that AI agents could build a semantic layer. The more interesting result was that the semantic layer itself became disposable. Q&A pairs are unreasonably effective at capturing business intent and give agents something concrete to iterate with. If code can be regenerated, where should your company accrue knowledge?

Scalable Data Apps with MotherDuck & Replit

Scalable Data Apps with MotherDuck & Replit

Aug 18, 2026 • Alex Monahan

AI agents make building data apps easy, but what about deploying them or making sure they scale? Replit provides a way for just about anyone to build real applications, and MotherDuck is the easiest way to help them scale to larger data sizes. Load data with MotherDuck Flights and you can query millions to billions of rows on the fly!

Vibe Code Data Apps with Vercel V0 & MotherDuck

Vibe Code Data Apps with Vercel V0 & MotherDuck

Aug 13, 2026 • Alex Monahan

Use an agent to build data apps with the combo of Vercel V0 and MotherDuck! V0 makes prototyping and deployment easy, while MotherDuck Flights provide seamless data ingestion and MotherDuck handles up to billions of rows. Your agent can even sign up for MotherDuck for you! See a full example app and the prompt that kickstarted it!

OpenAI Just Made Analytics 10x Cheaper

OpenAI Just Made Analytics 10x Cheaper

Aug 1, 2026 • Alex Monahan, Jacob Matson

Since OpenAI slashed the price of GPT 5.6 Luna by 80% this week, low latency AI-powered answers are finally feasible for less than half a penny per answer, AI and DB costs included. For data questions, GPT 5.6 Luna is intelligence too cheap to meter. Well documented context, rigorous evals, and a fast analytical engine are now the determining factors.

Developer Dad Does Disney: Vacationing in the Personal Software Era

Developer Dad Does Disney: Vacationing in the Personal Software Era

Jul 16, 2026 • Alex Monahan

Waiting in line is no fun! While standing in line at Disney World, a developer dad built a custom data app to pick the perfect next ride. It combines live APIs, historical wait times, and weather data into personal software with MotherDuck's MCP, Dives, and Flights.

DuckLake Architecture Deep Dive

DuckLake Architecture Deep Dive

Jul 10, 2026 • Alex Monahan

DuckLake is a next generation data lakehouse and open table format. It is significantly simpler and faster than Apache Iceberg or Delta Lake because it uses a SQL database for storing the catalog and metadata. This post covers an architecture deep dive with a detailed Q&A section. DuckLake consists of 3 components: storage, catalog, and compute. Each can be scaled independently, hosted locally with ease, and deployed to the cloud for production. MotherDuck offers managed DuckLake lakehouses for additional simplicity and performance.

Flight Plans: Templates for AI-Native Data Pipelines

Flight Plans: Templates for AI-Native Data Pipelines

Jun 18, 2026 • Alex Monahan

Build full data pipelines by prompting your AI agent, no Python required. MotherDuck Flights are perfect for data ingestion, transformation, and activation. Flight Plan templates show you and your agent how to ingest from Postgres, sync Google Sheets, and send Slack alerts.

Announcing DuckLake 1.0 on MotherDuck

Announcing DuckLake 1.0 on MotherDuck

Apr 16, 2026 • Alex Monahan

MotherDuck now supports DuckLake 1.0, the open table lakehouse format designed for simplicity and low latency. Learn what's new in the 1.0 release, including data inlining, clustering, bucket partitioning, geometry and variant types, plus multi-engine support. Learn how DuckLake compares with Apache Iceberg and Delta Lake.

"Zero-Latency Analytics in Your Application with Dives" video thumbnail

60:41

Zero-Latency Analytics in Your Application with Dives

Apr 9, 2026 • Alex Monahan, Garrett O'Brien

BI tools were never built to be app interfaces — they're rigid, clunky, and add complexity to your user experience. Dives offer a different approach: interactive data apps you create with natural language that can be embedded directly into your applications. In this session, Alex Monahan walks through how to build a Dive and embed it in your app, with help from AI agents. You'll learn how to create interactive visualizations with natural language queries, embed Dives into your app with a secure sandbox, set up the auth flow so your users get read-only access without exposing credentials, and choose between server-side and dual execution with DuckDB-Wasm. Whether you're building customer-facing analytics or internal tools, this webinar shows you the full workflow from query to production-ready embed. See how Claude Code + Dives can get you from zero to a working data app fast.

Webinar

MotherDuck Features

BI & Visualization

App Development

"What's New in DuckDB 1.5!" video thumbnail

58:00

What's New in DuckDB 1.5!

Apr 7, 2026 • Alex Monahan, Jacob Matson

Alex Monahan and Jacob Matson walk through DuckDB 1.5's biggest features including the VARIANT type, redesigned CLI, built-in GEOMETRY, and faster joins.

Webinar

"All About DuckLake: The O'Reilly Book" video thumbnail

55:29

All About DuckLake: The O'Reilly Book

Apr 2, 2026 • Alex Monahan, Matt Martin

Matt Martin and Alex Monahan, coauthors of O'Reilly's DuckLake: The Definitive Guide, discuss what DuckLake is, how it simplifies lakehouse architecture, and why it replaces file-based metadata with a SQL database. Includes a live Q&A and the release of Chapter 1.

Webinar

Ecosystem

Don't Fear the Agents - AI on the Data Lakehouse

Don't Fear the Agents - AI on the Data Lakehouse

Mar 24, 2026 • Alex Monahan

Learn how MotherDuck's Hosted DuckLake combines lakehouse scale (borrowing the best ideas from Apache Iceberg and Delta Lake) with low latency and agent sandbox isolation, making it the simplest data lakehouse for AI-powered agentic workflows.

DuckDB 1.5 Features I am Excited About

DuckDB 1.5 Features I am Excited About

Mar 9, 2026 • Alex Monahan

DuckDB 1.5 is both faster and easier to use! JSON analysis can be up to 100x faster thanks to the VARIANT type and JSON shredding. Real-world queries are faster, including both basic and complex queries. Writes to Azure are supported, and checkpoint concurrency is dramatically improved.

Claude Code + Dives = Any data UI

Claude Code + Dives = Any data UI

Mar 2, 2026 • Alex Monahan

Learn how to build custom interactive data visualizations using MotherDuck Dives and Claude Code. From setup to sharing, create refreshable React and SQL-powered visuals with natural language prompts.

"The MCP Sessions - Vol 2: Supply Chain Analytics" video thumbnail

The MCP Sessions - Vol 2: Supply Chain Analytics

Jan 21, 2026 • Jacob Matson, Alex Monahan

Jacob and Alex from MotherDuck query data using the MotherDuck MCP. Watch as they analyze 180,000 rows of shipment data through conversational AI, uncovering late delivery patterns, profitability insights, and operational trends with no SQL required!

Stream

AI, ML and LLMs

MotherDuck Features

SQL

BI & Visualization

Tutorial

"DuckLake: Making BIG DATA feel small (Coalesce 2025)" video thumbnail

DuckLake: Making BIG DATA feel small (Coalesce 2025)

Oct 14, 2025 • Jacob Matson, Alex Monahan

MotherDuck’s managed DuckLake data lakehouse blends the cost efficiency, scale, and openness of a lakehouse with the speed of a warehouse for truly joyful dbt pipelines. They will show you how!

Talk

Just Enough SQL to be Dangerous with AI

Just Enough SQL to be Dangerous with AI

Aug 4, 2025 • Jacob Matson, Alex Monahan

Learn essential SQL to verify AI-generated queries. Master SELECT, JOIN, and CTEs to safely analyze data with LLMs. Includes DuckDB examples and safety tips

"Taming file zoos: Data science with DuckDB database files" video thumbnail

Taming file zoos: Data science with DuckDB database files

Jun 2, 2025 • Alex Monahan

Tame "file zoos" with DuckDB! This talk reveals how DuckDB seamlessly integrates with Python to read/write diverse files (CSV, Parquet), organize data efficiently, enable larger-than-memory analysis, and streamline your workflows.

Python

Talk

"Local Dev, Cloud Prod with Dagster and MotherDuck" video thumbnail

0:52:48

Local Dev, Cloud Prod with Dagster and MotherDuck

Apr 22, 2024 • Alex Monahan, Colton Padden

Develop locally and ship to production confidently with Dagster data pipelines, Evidence dashboards powered by DuckDB and Markdown, and the MotherDuck cloud data warehouse.

YouTube

Data Pipelines

"No SQL standard for 7 years ?!" video thumbnail

0:00:47

No SQL standard for 7 years ?!

Jan 22, 2024 • Mehdi Ouazza, Alex Monahan

This short of Mehdi with Alex Monahan discusses the lack of evolution of the SQL standard. “(SQL) stands for Structured Query Language, not Standard Query Language”

YouTube

Short

SQL

"Friendly SQL with DuckDB" video thumbnail

0:54:38

Friendly SQL with DuckDB

Jan 5, 2024 • Alex Monahan, Mehdi Ouazza

Explore friendly and even friendlier SQL & DuckDB with Mehdi annd Alex Monahan! They discuss history, its future role in data and show some tips and tricks.

YouTube

SQL

Quack & Code

SUBSCRIBE

Subscribe to MotherDuck Blog