Agoston Fung
Back to posts
• 2 min read

My favourite DuckDB extensions

databases data tools duckdb
A code card on a yellow background showing DuckDB extensions in action: LOAD azure / postgres / postgres_scanner; ATTACH 'postgresql://...' AS postgres_db (TYPE POSTGRES); CREATE SECRET for Azure with credential_chain; then INSERT INTO postgres_db.users SELECT * FROM read_json_auto('az://users/*.json') JOIN role ON id = role.user_id.
Table of Contents

Three categories I keep reaching for lately 🚀

Azure / AWS ☁️

  • Connect straight to S3 or Azure Storage and query files directly
  • Use secure, modern auth like RBAC, tokens and CLI creds

JSON / CSV 📄

  • Load and explore semi-structured or flat files from anywhere
  • Automatic schema inference that feels like magic
  • Use asterisk wildcard to easily load multiple files

Postgres / MySQL 🗄️

  • Attach external databases as if they were part of DuckDB
  • Join and query across multiple systems without friction
  • Stream data both ways for fast ETL and rapid prototyping

Still not on the “ducktrain”? Have a look at duckdb.org.

Originally posted on LinkedIn.

My AI productivity: 4,200 lines of code per day
Stuck on a problem? Walk away.