DuckDB ODBC extension

March 23, 2026 ยท View on GitHub

Extension documentation.

ODBC functions API reference.

Building

Dependencies:

  • Python3
  • Python3-venv
  • GNU Make
  • CMake
  • unixODBC

Building is a two-step process. Firstly run:

make configure

This will ensure a Python venv is set up with DuckDB and DuckDB's test runner installed. Additionally, depending on configuration, DuckDB will be used to determine the correct platform for which you are compiling.

Then, to build the extension run:

make debug

This produces a shared library in target/debug/<shared_lib_name>. After this step, a script is run to transform the shared library into a loadable extension by appending a binary footer. The resulting extension is written to the build/debug directory.

To create optimized release binaries, simply run make release instead.