Querious 5 · Early Release

The PostgreSQL client for Mac. Native. Fast. Built by hand for macOS.

Querious 5 is a native PostgreSQL GUI for macOS. Edit data, write SQL, design schemas, watch activity and locks, back up with pg_dump, and let the Query Assistant write the SQL, all in one beautiful Mac app.

Free trial. Requires macOS 13.2 or later. Works with MySQL too.

PostgreSQL on the Mac

Everything you do with PostgreSQL, in one native app.

Querious is a PostgreSQL client, SQL editor, schema designer, and server monitor. It's deeply integrated with PostgreSQL throughout every view, not a thin wrapper around a generic database tool.

Browse and edit data

Filter, sort, and edit table rows in place. Follow foreign keys with the Relationships sidebar.

Write and run SQL

Multiple editors, context-aware autocomplete, saved queries, and a search path selector for schemas.

Design your schema

Edit columns, indexes, keys, constraints, sequences, triggers, views, materialized views, and functions.

Monitor the server

Live activity, locks, pg_stat_statements, replication, index usage, extensions, variables, and roles.

Back up and restore

A friendly interface for pg_dump and pg_restore, plus SQL, CSV, Tab, and JSON export.

Ask the Query Assistant

Describe the query you want in plain language. It writes SQL for your schema, and never sees your data.

PostgreSQL server tools

See what your PostgreSQL server is really doing.

Every connected session, what it is doing, and for how long, on a live chart. Cancel queries or terminate connections.

Read the documentation

Find out which sessions are blocking which, and monitor every open lock.

Read the documentation

Rank query patterns by cumulative time using pg_stat_statements.

Read the documentation

Confirm replicas are keeping up: WAL streaming, standbys, replication slots, and archiver health.

Read the documentation

Discover unused and redundant indexes.

Read the documentation

Scan a schema for structural problems that tend to cause trouble later.

Read the documentation

PostgreSQL Activity view in Querious showing sessions by state
PostgreSQL Locks view in Querious
PostgreSQL Statements view ranking queries by time
PostgreSQL Replication view in Querious
PostgreSQL Index Usage view in Querious
Schema diagnostics in Querious
Getting started

How to connect to PostgreSQL from your Mac.

  1. Open Querious 5 and choose File / New Connection (or click the + button in the connection window).
  2. Choose PostgreSQL as the connection type.
  3. Enter the host and port (5432 by default) or choose a Unix socket, then enter the user (role) name, password, and database name.
  4. Choose how the connection is secured: none, SSL, or an SSH tunnel.
  5. Click Connect. Save the connection to reuse it with one click later.
Full connection documentation
The Querious PostgreSQL connection settings
Support at a glance

What Querious 5 supports in PostgreSQL.

AreaSupported in PostgreSQL
TablesContent, columns, indexes, keys, constraints, sequences, triggers
Other objectsViews, materialized views, functions, procedures, custom types
SchemasSchema focus in the sidebar, search path, diagnostics, info, index usage, relationships
Server viewsStatus, activity, locks, statements, replication, index usage, extensions, variables, roles
Import / exportCSV, Tab, SQL import; CSV, Tab, SQL, JSON export; pg_dump and pg_restore
ConnectionsTCP/IP, Unix socket, SSL, SSH tunnel, password from a shell command
AIQuery Assistant (generates SQL; never executes it or reads table data)
Not yet for PostgreSQLDuplicate and database structure Compare (available for MySQL)
Questions

PostgreSQL on Mac: frequently asked questions

What is Querious for PostgreSQL?

Querious 5 is a native macOS PostgreSQL client. It lets you browse and edit table data, write and run SQL with autocomplete, edit schema structure, monitor server activity, locks, statements, and replication, import and export data, run pg_dump and pg_restore, and generate SQL with an AI Query Assistant.

Is Querious a native Mac app or a cross-platform app?

It is a native Mac app, made exclusively for macOS. It is not built with Java or Electron and it does not run in a web view, so it behaves like other Mac apps: standard windows and tabs, menus, keyboard shortcuts, and Dark Mode.

Which PostgreSQL features does Querious support?

Tables (content, columns, indexes, keys, constraints, sequences, triggers), views and materialized views, functions and procedures, custom types, schema diagnostics, import and export (CSV, Tab, SQL, and JSON export), pg_dump and pg_restore, and server views for status, activity, locks, statements, replication, index usage, extensions, variables, and roles. Duplicate and Compare are currently MySQL-only.

Can Querious connect through an SSH tunnel or SSL?

Yes. PostgreSQL connections can use SSL or be tunneled through SSH, and can connect over TCP/IP or a Unix socket. The password can be fetched from a shell command, such as a password manager's command-line tool.

Does Querious work with Postgres.app, Homebrew, Docker, and Amazon RDS?

Yes, with any PostgreSQL server that Querious can reach over TCP/IP or a Unix socket. That includes local installations from Postgres.app and Homebrew, containers running in Docker, and cloud-hosted servers such as Amazon RDS. For pg_dump and pg_restore, Querious finds the tools installed by Postgres.app, Homebrew, and other common locations.

Can the Query Assistant see my PostgreSQL data?

No. The Query Assistant only generates SQL. It never runs queries and never has access to the data in your tables. If you allow it, it can read your schema's structure (table and column names and CREATE statements) so the SQL it writes fits your database.

Can I also use Querious for MySQL?

Yes. Querious 5 works with PostgreSQL, MySQL, and MariaDB in the same app, and can open SQLite files too.

What does Querious 5 require?

macOS 13.2 or later. Querious 5 is currently an early release.

Try Querious 5 with your PostgreSQL databases.