14 POSTS
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.
2025/05/06 - Jacob Matson
MotherDuck lands on Tableau Cloud: Live, Fast Analytics Unleashed
Use MotherDuck to power your Tableau Cloud, Server, and Desktop dashboards.
2025/03/07 - Jacob Matson, Andrew Witten
Using MotherDuck at MotherDuck: Loading Data from Postgres with DuckDB
Duckfooding MotherDuck with the postgres scanner
2025/01/16 - Jacob Matson
Local dev and cloud prod for faster dbt development
Spark the Joy of beautiful local development workflows with MotherDuck & dbt
2024/12/19 - Jacob Matson, Aditya Somani
Window Functions in Motherduck: An Analytical Approach
Supercharge your window functions with MotherDuck SQL
2024/11/01 - Jacob Matson
The Data Warehouse powered by DuckDB SQL
Learn how DuckDB and MotherDuck transform data into business insights. DuckDB’s fast SQL processing meets MotherDuck’s cloud integration, creating a flexible, powerful data warehouse solution to solve complex business challenges and drive impact.
SUBSCRIBE
Subscribe to MotherDuck Blog
