qStudio has great support for DuckDB. It allows easily creating, opening and querying DuckDB databases.

DuckDB Database Tool

Create New DuckDB Database

To create a new duckdb database, go to File -> New DuckDB Database

Create new DuckDB Database

Load Existing Database

To open an existing duckdb database, go to File -> Open Database

Or by using our installer, in windows .duckdb files become associated with qStudio and you can simply click to open them.

DuckDB File Association

Double clicking a .duckdb or .db file will open it automatically in qStudio:

DuckDB Databases open in qStudio

Running Queries

Once you have selected a DuckDB file/server as the current connection you can use the below keyboard shortcuts to run commands against the file as shown below.

DuckDB qStudio

Query Shortcuts

Query Shortcuts