Scratch is a swiss army knife for big data.

Local MCP server for DuckDB and MotherDuck

Modern SQL client

Edit database tables like Vim buffers. Staged mutations + live SQL preview, transaction undo, schema browser + ER diagrams + DDL, FK navigation, cross-database federation, data profiling, SQL notebooks, AI SQL via Anthropic/OpenAI/Gemini/Ollama, Parquet/CSV/remote files. PostgreSQL · SQLite · MySQL · DuckDB · MotherDuck

Examples for the MotherDuck WASM Client library, enabling MotherDuck integration for WebAssembly-powered DuckDB

A Beginner's Guide to DuckDB's Python Client

Personal project for setting up an open source data warehouse.

All the SQL a Pythonista needs to know: an introduction to SQL and DataFrames with DuckDB

AI-powered geopolitical news intelligence platform. Ingests 100K+ daily events from GDELT, stores in MotherDuck (DuckDB), orchestrates with Dagster, and features an AI chat interface with Text-to-SQL. Full data engineering stack at $0/month.

Data engineering demo project for Danish Parliament (Folketing) open data — dlt extraction, dbt + DuckDB/MotherDuck transformation, Delta Lake export to Microsoft Fabric OneLake

Stock Advisor

A `dbt` project to analyze data snapshots from OpenAlex

Production-ready SQLAlchemy dialect for DuckDB and MotherDuck with operational defaults and migration support from duckdb_engine.

Fun times!

Digimon TCG tournament tracker - player standings, deck meta, store directory, and tournament results

A Streamlit connection to MotherDuck 🦆

Production-grade ELT pipeline classifying VIX volatility regimes. Features incremental models, SCD-2 snapshots, recursive CTEs, and Slim CI/CD. Stack: dbt, DuckDB/MotherDuck, Python.

energy data platform for our solar panels at home

Showcasing different ways of syncing local DuckDB data to MotherDuck (serverless DuckDB)

Curated list of new, forked and redesigned MCP servers to be used in conversational agents