Fig. 2Explain, visually
See the hot path before production does.
Every node sized by cost. Sequential scans on big tables glow red. Click any branch to pin the SQL that produced it. Catch the bad plan locally instead of in the on-call channel.
Vol. IIThe pgen field manual2026
Write Postgreslike you think.
A desktop Postgres client for the keyboard-first. Real SQL editor, fast schema browser, and an AI grounded in your live schema.
macOS · windowsuniversal · x64 · arm64bring your own api key
Fig. 1Composer · prompt → sql → rows
pgen
prod.us-east-1
db.prod.internal:5432
Filter objects...
public
Tables12
customers1.2M
orders8.4M
iduuid
customer_iduuid →
total_centsint8
created_atts
line_items42M
Views4
Functions6
analytics
audit
ask anything about your database…
⌘K// pgen will write SQL here…
● 7 rows·executed in 42ms·scanned 8.4MTABLE · CARD · JSON
awaiting results…
I.Keyboard-first
Every action has a shortcut.
pgen is built for people who live in their keyboard. Every panel and command has a key, and the command palette covers whatever doesn't. Open a query or jump to a table without ever reaching for the mouse.
⌘K
Command palette⌘↵
Run selection⌘T
New query tab⌘W
Close tab⌘1
Data browser⌘2
SQL editor⌘/
Comment line⌘⇧F
Search historyMarginalia
“The mouse is a fine pointing device, but the keyboard is where the work happens. We built pgen for the hands that have already memorized the shortcuts they wish existed.”
II.The capabilities
Everything a Postgres workflow needs.
Six tools, and each one earns its place on the toolbar.
Fig. 3Connection manager · history
prod.us-east-1pg-16.2
staging.eu-westpg-16.2
analytics.snowflakepg-15.6
local.dockerpg-17.1
legacy-reportspg-13.8
⌘⇧Frefund AND product24 hits
3 d agoSELECT count(*) FROM refunds WHERE created…
1 w agoWITH bad_products AS (SELECT p.id, p.name…
2 w agoSELECT p.name, count(r.*)::numeric FROM…
3 w agoUPDATE invoices SET sent_at = now() WHERE…
Jump to any database in a keystroke.
Tag prod, staging, local. Filter by environment. ⌘P to jump between any of them. Every query you've ever run, against any of them, full-text searchable.
Fig. 4Bring your own AI
providers
+Anthropicbyo key
+OpenAIbyo key
+Googlebyo key
+Ollamabyo key
+Custombyo key
Bring your own AI, keep your own data.
Plug in OpenAI, Anthropic, or a local Ollama. Prompts are grounded in your live catalog. Queries never leave your machine, and pgen never sees your data.
Fig. 5Import · export
.csv.json.parquet.sql.gz.xlsx.tsv.ndjson
sourcetypetarget
user_idint8→ users.id
created_attimestamp→ users.created
email_addressvarchar→ users.email
Import anything. Export anywhere.
Smart column mapping, type inference, conflict resolution on insert. Round-trip a Parquet dump through Postgres into a CSV without leaving the editor.
Fig. 6Security
✓SSH tunnelkey or password
✓Client-cert SSLmutual TLS
✓Read-only lockper connection
✓Prod guardrailsconfirm or block
SSL, SSH, and a read-only mode that sticks.
Mark a connection prod and destructive statements either require confirmation or refuse to run at all.
III.Compatibility
Every Postgres, everywhere it lives.
If it speaks the wire protocol, pgen connects. Cloud, container, or laptop — paste the URL and you're in.
№ 01
Supabase
db.*.supabase.co
№ 02
Neon
*.neon.tech
№ 03
AWS RDS
*.rds.amazonaws.com
№ 04
Google Cloud SQL
cloud sql · iam proxy
№ 05
Azure Database
*.postgres.database.azure.com
№ 06
Timescale Cloud
*.tsdb.cloud.timescale.com
№ 07
Crunchy Bridge
*.crunchybridge.com
№ 08
DigitalOcean
*.db.ondigitalocean.com
№ 09
Self-hosted
localhost · docker · k8s
postgres 12 → 17·pgvector·postgis·timescaledb·every extension·ssl · ssh tunnel · iam auth
¶ A short manifesto ¶
We made pgen because the tools we had treated SQL like a chore. A box to type in, a table to stare at, a spinner to wait through. We wanted something that respects the keyboard, that reads your schema, that doesn’t phone home — and that gets out of the way when there’s a query to write.
— the team at tragen
Plate VII · the mascot
— the pigeon, ready —
IV.Colophon
Ready to fly?
pgen is free forever — every feature, no account, bring your own API key when you want the AI on. PRO is coming for teams that want cloud sync and managed inference.