OrcaQ is a free, open-source (MIT) database editor for macOS and Linux. Besides DuckDB, it connects to PostgreSQL, MySQL, SQLite, SQL Server, Redis, MongoDB and other databases. OrcaQ opens DuckDB database files through the official DuckDB Node.js client, so no separate driver is needed.
DuckDB support in OrcaQ is in beta, and it is available in the desktop app only. On macOS it requires Apple Silicon.
Installing OrcaQ
Download the latest desktop build (.dmg for macOS, .AppImage or .deb for Linux) from the OrcaQ releases page and install it.
Connecting to a DuckDB Database
- Open OrcaQ, create or open a workspace, and click Add Connection.
- In Select Database Type, choose DuckDB and click Next.
- Give the connection a name, then click Browse next to Database File and select your
.duckdbfile. To start from an empty database, click New database file, pick a file name and a folder, and OrcaQ creates the file for you. -
Click Test to check that the file can be opened, then click Create.
DuckDB allows only one process to write to a database file at a time. Close other programs that have the file open, such as the DuckDB CLI, before you connect.
- Open the connection. The sidebar lists the schemas of the database with their tables, views and macros.
- Open a raw query tab, write SQL, and run it. Large results are streamed to the result grid, and a running query can be cancelled.
Now you are ready to query DuckDB with OrcaQ.