How to Install DuckDB: A Complete Step-by-Step Guide

DuckDB is a powerful, in-process SQL OLAP database management system designed for fast analytical query processing. It is lightweight and easy to install, perfect for data scientists, analysts, and developers looking to work with data efficiently. This tutorial will guide you through the process of installing DuckDB on different platforms so you can get started quickly.

Prerequisites

Basic knowledge of command line or terminal usage.
Access to a computer running Windows, macOS, or Linux.
Internet connection to download installation packages.
Python or R installed (optional, for bindings).

Step 1: Choose Your Installation Method

DuckDB offers several ways to install, depending on your needs. The common methods are:

Using pre-built binaries or installers
Installing via package managers like pip for Python or CRAN for R
Building from source (advanced users)

Step 2: Installing DuckDB on Windows

For Windows users, the easiest way is to install DuckDB using Python’s pip if you use Python, or use the standalone binaries.

a) Using Python pip

pip install duckdb

After installation, you can open a Python terminal and test by running:

import duckdb
con = duckdb.connect()
con.execute('SELECT 42').fetchall()

b) Using Standalone Binaries

Visit the DuckDB official site (Official site) and download the Windows binary. Extract it and run duckdb.exe to start the command-line client.

Step 3: Installing DuckDB on macOS

macOS users can install DuckDB via Homebrew or Python pip.

a) Using Homebrew

brew install duckdb

This installs the DuckDB shell and the necessary libraries.

b) Using Python pip

pip install duckdb

Then verify the install by running DuckDB Python commands as shown above.

Step 4: Installing DuckDB on Linux

Linux users have multiple options, including package managers or building from source.

a) Using Python pip

pip install duckdb

b) Using Package Managers

Depending on your distribution, some may have DuckDB packages available. Alternatively, use the downloadable binaries from the official site.

c) Building from Source

Advanced users can build from source for customized installations:

git clone https://github.com/duckdb/duckdb.git
cd duckdb
git submodule update --init
mkdir build && cd build
cmake ..
make
sudo make install

Step 5: Using DuckDB

Once installed, you can start using DuckDB in different environments:

Command Line Interface: Run duckdb in your terminal to launch the shell.
Python: Import duckdb module and connect as shown earlier.
R: Install the R package via CRAN and use library(duckdb).

Troubleshooting Tips

If you get a “command not found” error, ensure that the DuckDB binary is in your system PATH.
For Python installs, verify your Python environment is active and up to date.
Check firewall or antivirus blocks if installation downloads fail.
Refer to the official DuckDB documentation (Official site) for the latest updates.