pgquelGitHub
Open source · Free forever

A PostgreSQL client
built for developers

pgquel is a free, open-source PostgreSQL desktop client built with Tauri 2 and Rust. It runs natively on macOS, Windows, and Linux — no Electron, no subscription, no Node.js server at runtime.

macOS · Windows · Linux

query_1.sqlusers.sqlanalytics.sql

Tables

users
orders
products
sessions
events
1
2
3
4
5
6
7
SELECT u.id, u.email, u.created_at,
count(o.id) AS order_count
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE u.created_at > '2024-01-01'
GROUP BY u.id
ORDER BY order_count DESC;
1,284 rows · 42msExport CSV

Why not TablePlus or Postico?

Great tools. But they're paid, closed-source, or Electron-based. pgquel is none of those things.

Truly native

Built with Tauri 2 and Rust. Starts instantly. Uses ~30MB RAM, not 300MB.

Secure by default

Passwords stored in your OS keychain. Nothing sensitive ever hits SQLite.

Free forever

No subscription. No seat limits. No nags. Open source under MIT.

Handles big results

Virtualized result rendering — scroll through 100k rows without lag.

Everything you need, nothing you don't

Focused feature set for developers who spend real time in Postgres.

SQL editor

Monaco · Multi-tab

Monaco-powered editor with full syntax highlighting, multi-tab support, and query history of your last 1,000 queries.

Schema explorer

Tables · Indexes · FK

Browse tables, columns, indexes, and foreign keys without writing a single query.

Command palette

⌘K

Keyboard-first navigation. Jump to any table, connection, or query from anywhere.

Connection manager

Keychain · Favorites

Organize connections with favorites. Credentials never leave your OS keychain.

CSV export

One click

Export any result set to CSV in one click. No row limits.

Cross-platform

macOS · Win · Linux

Single codebase. Native binaries for macOS, Windows, and Linux.

Frequently asked questions

What is pgquel?
pgquel is a free, open-source PostgreSQL desktop client for macOS, Windows, and Linux. It is built with Tauri 2 and Rust, which means it runs as a true native application — not inside an Electron wrapper. It includes a Monaco-powered SQL editor, a schema explorer, virtualized result rendering, and OS keychain credential storage.
Is pgquel really free?
Yes. pgquel is MIT-licensed and free forever. There is no subscription tier, no seat limit, and no premium features locked behind a paywall. The full source code is available on GitHub.
How is pgquel different from TablePlus or Postico?
TablePlus and Postico are paid, closed-source applications. pgquel is open-source and free. It is also built with Tauri and Rust rather than Electron, so it starts faster and uses significantly less memory — typically under 50 MB compared to 300+ MB for Electron-based clients.
Does pgquel store my database passwords?
pgquel stores database passwords in your operating system keychain (Keychain on macOS, Credential Manager on Windows, libsecret on Linux). Passwords are never written to SQLite or any other plaintext storage on disk.
Which operating systems does pgquel support?
pgquel supports macOS, Windows, and Linux. Native binaries are distributed for each platform through the GitHub releases page.
Can pgquel handle large query results?
Yes. pgquel uses virtualized table rendering for query results, so you can scroll through tens of thousands of rows without performance degradation. Query results can also be exported to CSV with no row limit.

Open source, built in public

pgquel is MIT-licensed. Read the code, file issues, contribute fixes. No vendor lock-in, no black box.

011bq/pgquel