Option A: Download Command Line Interface

  1. Download duckdb_cli-windows-amd64.zip
  2. Unzip and run duckdb.exe
  3. Try running: CREATE TABLE T AS SELECT RANDOM(); SELECT * FROM T;
DuckDB Windows Command Line

Option B: Download as part of qStudio IDE

DuckDB qStudio

QStudio SQL always bundles the latest duckdb as part. Downloading qStudio provides an installer and an editor with syntax highlighting etc.

  1. Download qStudio using setup.exe
  2. Run qStudio from the start menu.
  3. Go File -> New DuckDB Database
  4. Make sure your new database is the currently selected server
  5. Try running: CREATE TABLE T AS SELECT RANDOM(); SELECT * FROM T;. Ctrl+Q runs the current query at the cursor.
  6. See our DuckDB Tutorials to learn more
Create new DuckDB Database

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.

Query Shortcuts

Query Shortcuts