17 POSTS
2025/12/23 - Jacob Matson
What If We Don't Need the Semantic Layer?
What if AI could discover your business logic by mining query history instead of requiring manual metric definitions? Explore how LLMs are replacing static semantic layers with systems that learn from actual usage.
2025/12/16 - Garrett O'Brien, Jacob Matson
MotherDuck Integrates with PlanetScale Postgres
Run analytics 200x faster on PlanetScale Postgres with MotherDuck integration. Keep millisecond transactions while pushing analytical queries to serverless compute.
2025/12/12 - Jacob Matson
Calling All SQL Sleuths: The Christmas Heist Awaits
Christmas presents have vanished! Use your SQL skills to solve the mystery on DBQuacks and win prizes. 15 challenges. One leaderboard.
2025/09/03 - Jelte Fennema-Nio, Jacob Matson
Announcing Pg_duckdb Version 1.0
PostgreSQL gets a DuckDB-flavored power-up for faster analytical queries without ever leaving Postgres.
2025/08/22 - Jacob Matson
Nine Keyboard Shortcuts for SQL Flow State
Tired of clicking? Master 9 essential SQL keyboard shortcuts to achieve a true flow state and make your data analysis faster and more joyful. Learn to run queries, comment, format, and even use AI without leaving your keyboard.
2025/08/04 - Jacob Matson, Alex Monahan
Just Enough SQL to be Dangerous with AI
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
2025/07/25 - Hamilton Ulmer, Jacob Matson
MotherDuck's Latest AI Features: Smarter SQL Error Fixes and Natural Language Editing
Stay in flow with MotherDuck's latest features. Real-time SQL feedback and natural language editing.
2025/06/27 - Jacob Matson
I Made Cursor + AI Write Perfect SQL. Here's the Exact Setup
Stop debugging AI-generated SQL queries. Learn the exact Cursor + MotherDuck setup that makes AI write working SQL on the first try, with step-by-step instructions.
2025/06/16 - Jacob Matson, Aditya Somani
PostgreSQL and Ducks: The Perfect Analytical Pairing
Learn how to integrate PostgreSQL with DuckDB and MotherDuck for faster analytics. Compare DuckDB Postgres Extension, pg_duckdb, and CDC approaches with practical examples and best practices for each method.
2025/05/27 - Jacob Matson
Breaking the Excel-SQL Barrier: Leveraging DuckDB's Excel Extension
Now in MotherDuck & DuckDB, its never been easier to join in your data from spreadsheet sources.
SUBSCRIBE
Subscribe to MotherDuck Blog
