DuckDB SQL IDE
qStudio has great support for DuckDB. It allows easily creating, opening and querying DuckDB databases.
Create New DuckDB Database
To create a new duckdb database, go to File -> New DuckDB Database
![Create new DuckDB Database](images/duckdb-new-database.png)
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](images/duckdb-file-association.png)
Double clicking a .duckdb or .db file will open it automatically in qStudio:
![DuckDB Databases open in qStudio](images/duckdb-files.png)
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](images/duckdb-qstudio.png)
Query Shortcuts
![Query Shortcuts](images/query-shortcuts.png)