PGStudio

Modern PostgreSQL desktop client for developers and DBAs

What it is

PGStudio is a native PostgreSQL client for people who live in schemas all day. It is built for speed: Keychain auth, SSH tunnels, a Rust driver on desktop, schema browsing, paginated grids, a Monaco SQL editor, live sessions, indexes, ER topology, and AI that actually sees your schema.

The desktop shell is Tauri; web and iPad talk to an Axum data plane. A control plane on Vercel handles auth, Stripe billing, and Gemini. I wanted TablePlus-level feel with a path to collaboration and AI that is not bolted on as a chatbot in the corner.

Why I built it

Existing Postgres GUIs are either slow Electron apps, stuck in 2012 UX, or clouds that take your data off-machine. I needed a local-first studio that could still grow into billing, AI, and team features without giving up native performance.

Whom it is for

PGStudio — for backend engineers, DBAs, and product teams who work in PostgreSQL daily and want a serious desktop client with optional cloud AI and billing.

Aim

Make inspecting, querying, and evolving Postgres feel instant on a Mac, with AI that is grounded in the actual catalog—not generic SQL tips.

Goal

A studio people open every morning: schema, data, SQL, migrations, and topology in one native app, with a sustainable product around it.

Hope

That teams stop treating the database as a black box in a browser tab, and that AI help is useful because it is compressed against real schema, not guessed from a prompt.

What it does

Native macOS client with Keychain auth, SSH tunnels, and instant query path
Schema browser, paginated grids, GeoJSON/map view, live sessions, and index builder
AI chat via Gemini with schema compression and streaming
Migration studio, ER topology (React Flow), and Git/collaboration hooks
Product site, Stripe subscriptions, and web control plane on Vercel

Stack

Rust · Tauri · Next.js · PostgreSQL · Axum · Stripe · Gemini

Website Web app

All projects Next project →