Announcing the ADBC Scanner Extension for DuckDB

We’re excited to introduce our newest DuckDB community extension: ADBC Scanner — a fast, flexible way to connect DuckDB to external databases using Arrow Database Connectivity (ADBC).

With ADBC’s column-oriented, Arrow-native design, you get efficient data movement without the overhead of traditional drivers like ODBC or JDBC.

What you can do with ADBC Scanner:

🔗 Query SQLite, PostgreSQL, Snowflake, GizmoSQL, BigQuery, Trino, SQL Server, MySQL, and more — directly from DuckDB 📥 Bulk-insert data from DuckDB into external systems using efficient Arrow-based transfer 💾 Use full transaction support (commit/rollback) 🔍 Introspect remote databases: list tables, columns, schemas 🔐 Run parameterized queries for safe, efficient access

ADBC Scanner connects DuckDB’s blazing-fast analytics to your existing database infrastructure — no ETL pipelines required.

Learn more: https://query.farm/duckdb_extension_adbc_scanner.html

Try it out by connecting to GizmoSQL at: https://github.com/gizmodata/gizmosql/blob/main/docs/adbc_scanner_duckdb.md

Originally posted on LinkedIn.