A local, single-user PostgreSQL GUI client. Run it against your own database and get a fast, keyboard-friendly web UI for browsing schemas, running queries, and managing your cluster — no account, no server to deploy, no telemetry.
npx usepostgrexThis starts a local server on http://localhost:3003. Open it in your browser and connect with your PostgreSQL credentials.
Use a different port with PORT:
PORT=8080 npx usepostgrex
- Schema browser — tables, views, materialized views, foreign tables, indexes, sequences, functions, procedures, triggers, rules, policies, types, domains, operators and more, across every schema in the database.
- Cluster management — databases, roles, tablespaces, and replication slots.
- SQL editor — run arbitrary queries against the connected database, with results shown as a table or a chart.
- Terminal — a
psql-style console in the browser. - Import / Export — move data in and out of tables.
- Monitoring — live activity, locks, and cumulative statistics.
- Administration — server configuration, connections, backups, and logs.
- Node.js 20 or later
- A reachable PostgreSQL server (local or remote)
postgrex is built for local, single-user use: it runs on your machine, serves one browser at a time, and holds your connection credentials in an encrypted, httpOnly cookie for the life of the session — nothing is written to disk or sent anywhere else. It isn't designed to be exposed to the network or shared across multiple concurrent users.