Queriez Logo Queriez
Download

User Manual

Welcome to the Queriez documentation. Learn how to install the app, manage your databases, and master the keyboard shortcuts to boost your productivity.

Installation Guide

Getting Queriez running on your machine is straightforward. Follow the instructions for your operating system, or visit our dedicated detailed installation page for more help.

macOS

  1. Download the macOS .dmg installer and open it.
  2. Drag Queriez.app into your Applications folder.
  3. Security Bypass:

    If Gatekeeper blocks the app, go to System Settings > Privacy & Security, scroll down, and click "Open Anyway".

Windows

  1. Download the Windows .exe installer.
  2. Double-click the installer to begin.
  3. Security Bypass:

    If Microsoft SmartScreen appears, click "More info" below the text, then click the "Run anyway" button.

Linux

  1. Download the Linux .AppImage file.
  2. Make the file executable using the terminal: 
    chmod +x Queriez.AppImage
  3. Double-click the file to run the application, or execute it via terminal.

Creating a Connection

Queriez supports PostgreSQL, MySQL, and SQLite. Adding a new database connection is simple and secure.

  1. Press Cmd + N (or Ctrl + N) or click the "+" icon in the sidebar.
  2. Select your database engine (PostgreSQL, MySQL, or SQLite).
  3. Fill in your host, port, username, database name, and password.
  4. Click Test Connection to verify your credentials, then click Save.
lock
OS Keyring Security

Your passwords are never stored in plain text. Queriez encrypts and safely stores all your database passwords directly in your native OS Keyring (macOS Keychain or Windows Credential Manager).

Usage Tutorials

code

1. The Query Editor

The query editor is powered by CodeMirror, offering lightning-fast syntax highlighting and autocomplete.

  • Partial Execution: If you have multiple SQL statements in one tab, you can execute just one by highlighting the specific lines you want to run, and pressing Cmd + Enter. If nothing is highlighted, the entire script runs.
  • Multi-Window: Need more screen space? Press Shift + Cmd + N to break out a connection into an entirely new, isolated window.
grid_on

2. The Data Grid

The Data Grid allows you to manipulate data without writing UPDATE or DELETE queries.

  • Inline Editing: Double-click any cell to instantly edit its value. Press Enter to save the change locally. (Note: You must click the green "Save Changes" button on the toolbar to commit changes to the database).
  • Set to NULL: Select a cell and press Backspace or Delete to instantly empty it and mark it as NULL.
  • Delete Rows: Highlight one or more rows by clicking the row number on the left, then press Cmd + Delete (or Ctrl + Backspace) to stage them for deletion.
monitor_heart

3. Server Monitoring

Keep track of your database's health directly from the app.

  • Click the Activity icon in the sidebar to view the System Monitor (RAM usage, active threads).
  • Right-click a connection in the sidebar and select "Show Server Activity" to view a live 3-second auto-refreshing dashboard of all running queries on the server. You can click Kill on any stuck query to terminate it instantly.
save

4. Backup & Export

Extracting data out of Queriez is designed to be seamless.

  • Export Results: Run a query, then click the Export button above the Data Grid to download the result set as CSV, JSON, Excel (XLSX), or SQL INSERT statements.
  • Native Backup: Right-click any database in the sidebar and select Backup. Queriez uses the native pg_dump and mysqldump engines under the hood, supporting on-the-fly GZIP compression and the ability to continue on syntax errors during restoration.

Keyboard Shortcuts

Queriez is designed to be highly responsive to keyboard combinations, heavily boosting your productivity.

Note: On Windows and Linux, the Cmd key is generally mapped to Ctrl.

Global & Navigation

Action Mac Shortcut Win/Linux
New Query Tab Cmd + T Ctrl + T
Close Current Tab Cmd + W Ctrl + W
Switch Tabs Ctrl + Tab Ctrl + Tab
Command Palette Cmd + K Ctrl + K
Open Settings Cmd + , Ctrl + ,
New Connection Cmd + N Ctrl + N
New Window Shift + Cmd + N Shift + Ctrl + N

Query Editor

Action Mac Shortcut Win/Linux
Run Query (or selection) Cmd + Enter Ctrl + Enter
Toggle Comment Cmd + / Ctrl + /
Indent Line(s) Tab Tab

Data Grid Viewer

Action Shortcut
Inline Edit Double Click
Save Edit Enter
Cancel Edit Esc
Set to NULL Backspace / Delete
Delete Row(s) Cmd + Delete
Select All Cmd + A