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.
• Linux: download the AppImage, run chmod +x QueryBench.AppImage and start it. 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. Green means connected, orange means connecting, red means disconnected. 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 title bar toggles Edit / No-Edit. 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.