Getting started

QueryBench is a native database workspace for PostgreSQL, MySQL, SQLite, DuckDB, ClickHouse, MongoDB and Redis. This page gets you from download to your first query in a few minutes.

Install

• macOS: open the DMG and drag QueryBench to Applications. Both Apple Silicon and Intel Macs are supported.
• Windows: run the installer. QueryBench uses the WebView2 runtime that ships with Windows 10 and 11. Current Windows builds are not code-signed yet: if SmartScreen shows Windows protected your PC, choose More info, then Run anyway.
• Linux: extract the tar.gz archive and run QueryBench/querybench. GTK 4.14+ and WebKitGTK 6 are required. A Secret Service keyring is required for password storage.
• iOS and Android: install from the store link on the download page.

First launch

QueryBench always starts on the Connections screen. An empty installation shows No connections yet and a New button. Choose an engine from the logo grid, fill in the form and press Save. Selecting a saved connection opens the database and enters the workspace.

Use Test connection before saving if you want to check credentials, TLS and SSH settings without leaving the form.

The workspace

• The colored connection header shows environment, connection name, engine, database and the selected object. While connected the header shows the connection's status color (green by default). Orange means connecting, red means disconnected, and clicking a red header reconnects. A blue line inside the bottom edge indicates activity, including queries in background tabs.
• The sidebar lists schemas, tables, views, stored functions and query history. Disclosure chevrons expand real column information without opening the table.
• Single-click a table to preview it in an italic tab. Double-click to pin it. Previews replace each other while pinned tabs stay open.
• The plus button after the last tab opens a new SQL or command tab. Double-clicking empty tab-strip space does the same.
• The padlock in the toolbar toggles Edit / No-Edit; Discard, Review and Commit sit next to it. Production connections start locked.

Your first query

Open a SQL tab, type a statement and press ⌘ Enter (or Ctrl Enter). Results stream into the grid in pages of 100 to 1,000 rows. ⇧ ⌘ Enter runs every statement in the editor in order.

-- Explore your data
SELECT *
FROM "main"."customers";

Where things are stored

Desktop metadata and the sample database live in your user configuration directory, for example ~/Library/Application Support/QueryBench on macOS. Connection metadata is written atomically with mode 0600 in a 0700 directory. Passwords are never in that file; they go to the operating system credential store under the service name QueryBench.