NEWAI schema inference, now generally available→

Write Postgreslike you think

A modern, AI-powered desktop client that makes PostgreSQL simple, fast, and beautiful.

Download for macOS· .dmgSee it work
macOS · WindowsUniversal · x64 · arm64Bring your own API key
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 42msTABLE · CARD · JSON
awaiting results…
Workspace

Five panels. One shortcut away.

Every workflow lives behind a single number key. Nothing modal, nothing nested - so you never have to go looking for the query you're working on.

pgen
prod.us-east-1
db.prod.internal:5432
Filter objects...
public
Tables5
users
orders
products
payments
sessions
Functions4
analytics
public.users1,247 rowsFilter
PKidint4
nametext
emailtext
statususer_status
1
1
Alice Johnson
alice@example.com
active
2
2
Bob Martinez
bob@acme.io
active
3
3
Carol Chen
carol@startup.dev
inactive
4
4
David Kim
david@corp.co
active
5
5
Eva Novak
eva@design.studio
pending
Data Browser · ⌘1

Browse your data visually

Navigate tables, views, and schemas with an intuitive tree-based sidebar. View data in table, card, or JSON format with instant filtering and sorting.

Keyboard-first

Every action
has a shortcut.

pgen is built for people who live in their keyboard. Every panel, every dialog, every command has a shortcut - and the command palette (⌘K) gets you to the rest.

No nested menus to dig through. No modal that traps your focus. Open a query, jump to a table, run a selection - without ever lifting your hands from the keys.

⌘K
Open command palette
⌘↵
Run selection
⌘T
New query tab
⌘W
Close tab
⌘1
Switch to Data Browser
⌘2
Switch to SQL Editor
⌘/
Comment line
⌘,
Settings
Capabilities

Everything you need
for a Postgres workflow.

Explain, visually

See the hot path before production sees it.

Every node sized by cost. Sequential scans on big tables glow red. Click to pin the SQL that produced the branch.

Hash Join · 412Index Scancost 88Seq Scan · orderscost 287 · 8.4M rowsFilter · quarter
Connection manager

Every database, one keystroke away.

prod.us-east-1pg-16.2
staging.eu-westpg-16.2
analytics.snowflakepg-15.6
local.dockerpg-17.1
legacy-reportspg-13.8
pgen mascot
Bring your own AI

Your schema, your keys, your data - never ours.

Plug in OpenAI, Anthropic, or a local Ollama. Prompts are grounded in your live catalog. Queries never leave your machine.

AnthropicOpenAIGoogleOllamaCustom
Searchable history

Every query you've ever run. Indexed.

⌘⇧Frefund AND product· 24 hits
3d agoSELECT count(*) FROM refunds WHERE...
1w agoWITH bad_products AS (SELECT p...
2w agoSELECT p.name, count(r.*)::num...
I/O

Import, export, repeat.

Smart column mapping, type inference, and conflict resolution on insert.

.csv.json.parquet.sql.gz.xlsx.tsv.ndjson
sourcetypetarget
user_idint8→ users.id
created_attimestamp→ users.created
email_addressvarchar→ users.email
Security

SSL, SSH, and read-only modes that stick.

Mark a connection prod and destructive statements require confirmation - or block entirely.

✓SSH tunnelkey or password
✓Client-cert SSLmutual TLS
✓Read-only lockper connection
Compatibility

Every Postgres.
Everywhere.

If it speaks the wire protocol, pgen connects. Cloud, container, or laptop - paste the URL and you're in.

Supabase
db.*.supabase.co
Neon
*.neon.tech
AWS RDS
*.rds.amazonaws.com
Google Cloud SQL
cloud sql · iam proxy
Azure Database
*.postgres.database.azure.com
Timescale Cloud
*.tsdb.cloud.timescale.com
Crunchy Bridge
*.crunchybridge.com
DigitalOcean
*.db.ondigitalocean.com
Self-hosted
localhost · docker · kubernetes
postgres 12 → 17·pgvector·postgis·timescaledb·all extensions·ssl · ssh tunnel · iam auth
pgen logopgen

Ready to fly?

Discover the future of PostgreSQL tooling with pgen. Remember, the journey is just getting started.

Download NowJoin Discord