pgStudio is a native macOS PostgreSQL client built for developers who care about speed, clarity, and polish
pgStudio is a native macOS PostgreSQL client built for developers who care about speed, clarity, and polish. Whether you're exploring a production schema, writing complex queries, managing migrations, or collaborating with your team — pgStudio gives you every tool in one focused, beautiful app. SCHEMA BROWSER Navigate your entire database hierarchy at a glance. Browse schemas, tables, views, functions, types, triggers, and enums with live row counts. Create tables, enums, and databases — all without writing DDL by hand. POWERFUL SQL EDITOR A Monaco-based SQL editor with syntax highlighting, auto-formatting, risk guards on destructive queries, and a full query history. Run queries with confidence and see results instantly in a paginated data grid with sorting and multi-condition search. AI-ASSISTED QUERIES Stuck on a query? The built-in AI chat panel (powered by Gemini) understands your schema and helps you write, explain, and optimize SQL — right inside the app. Your API keys stay server-side, always. VISUAL SCHEMA DESIGNER Design and visualize your database topology with an ER-style graph view. See how tables relate, plan schema changes visually, and export your designs — powered by React Flow and persisted locally on your Mac. MIGRATIONS STUDIO Author and review database migrations with a dedicated studio. Diff schemas, track changes, and keep your database evolution organized and auditable. SESSIONS & PERFORMANCE Monitor live database sessions (pg_stat_activity-style), cancel or terminate runaway backends, inspect index usage, and run benchmarks — everything a DBA needs without leaving the app. REAL-TIME COLLABORATION Invite teammates to collaborate on the same database session with live presence and signaling. Perfect for pair debugging or shared schema reviews. SECURE & PRIVATE Connection credentials are stored in your macOS Keychain — never in plaintext. SSH tunnel support lets you connect safely to databases behind private networks. MORE FEATURES - Extensions manager — install, update, uninstall Postgres extensions - GeoJSON / Map view for spatial data - GitHub integration and Git panel - Command palette for keyboard-first navigation - Saved connections with environment support - Seed data and CSV export - Full keyboard shortcut customization - Appearance and editor preferences WORKS WHERE YOU WORK pgStudio runs as a native macOS app with a Rust-powered database driver for maximum performance. No Electron. No slowdowns. pgStudio is free to try. A subscription unlocks AI features and collaboration.
| # | Name | Price | Currency | Region |
|---|---|---|---|---|
| 1 | Item | ¥ 0 | CNY | 中国 |
