Getting Started

Get up and running with QueryArk in four steps.

1

Download & Install

Grab the latest release from the download page. Open the installer for your platform — DMG on macOS, EXE/MSI on Windows, or AppImage/deb/rpm on Linux.

2

Create a Connection

Click "New Connection" in the sidebar. Pick your database type, fill in host, port, credentials, and click Test to verify. You can also paste a connection URL to auto-fill the form.

3

Browse Your Schema

Once connected, expand the schema tree in the sidebar. Click a table to open it in a data tab, or right-click for options like viewing structure, DDL, or opening in the ER diagram.

4

Run Your First Query

Press Ctrl+N to open a new query tab. Write SQL in the editor with autocomplete, then press Ctrl+Enter to execute. Results appear in the data grid below.

Connecting to Databases

QueryArk supports 16 database engines. Select one below for connection details.

Keyboard Shortcuts

Default keyboard shortcuts. All shortcuts are customizable in-app via Ctrl+K.

General

New Query Tab Ctrl+N
Command Palette Ctrl+P
Toggle Sidebar Ctrl+B
Refresh Schema F5
Toggle Theme Ctrl+Shift+T
Keyboard Shortcuts Ctrl+K

Tabs

Close Tab Ctrl+W
Next Tab Ctrl+Tab
Previous Tab Ctrl+Shift+Tab

Editor

Run Query Ctrl+Enter
Format SQL Ctrl+Shift+F
Save Query Ctrl+S

Features Overview

A quick look at what QueryArk offers.

Query Editor

CodeMirror 6-powered SQL editor with schema-aware autocomplete, multi-dialect highlighting (PostgreSQL, MySQL, SQLite, MSSQL, Cassandra), multi-statement execution, query formatting, saved queries, and query history.

Data Grid

Spreadsheet-like grid with inline editing, multi-cell selection, drag-fill, column sorting/filtering/resizing, find & replace, foreign key dropdowns, and export to CSV, JSON, SQL, or Markdown.

Schema Browser

Expandable tree with schemas, tables, views, functions, sequences, and types. Virtual scrolling handles thousands of tables. Includes table stats, DDL viewer, favorite tables, and multi-schema visibility.

Visual Tools

Interactive ER diagrams with zoom/pan, visual query builder for JOINs and GROUP BY, table structure diff and data diff across environments, and automatic migration script generation.

Security

SSH tunneling through bastion hosts, SSL certificate configuration, OS keychain integration for passwords (macOS Keychain, Windows Credential Manager, Linux Secret Service), and connection URL parsing.

Productivity

Query result charts (bar, line, pie), parameterized query execution, query profiling with optimization hints, auto-suggested indexes, workspace profiles, result bookmarks, and query snippet templates.