pgStudio

Developer Tools

Only for Mac

Free

Mac

Connect to production Postgres through SSH tunnels—reliable bastion access, clearer errors, and faster setup. pgStudio: performance-first database studio for Mac. 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.

Ratings & Reviews

  • This app has not received enough ratings or reviews to display an overview.

pgStudio 1.4.7 improves remote database access and connection reliability. SSH tunnel connections • Connect to PostgreSQL through a bastion host (identity file or password) • Fixed connections failing over SSH tunnels to RDS and other SSL-enabled servers • Tunnel waits until the local port is ready before connecting • Clearer errors when SSH auth, identity files, or tunnel setup fails • Automatic tunnel cleanup if the database connection fails • Improved keep-alive defaults for stable long-lived tunnels Connection experience • Better handling of TLS vs plain connections for tunneled and direct hosts • More helpful connection error messages in the UI This update is recommended for anyone connecting to staging or production databases through a jump host.

Version 1.0.2

The developer, Pooja Kumari, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy .

  • Data Linked to You

    The following data may be collected and linked to your identity:

    • Contact Info
    • Identifiers
    • Diagnostics

Privacy practices may vary based, for example, on the features you use or your age. Learn More

Accessibility

The developer has not yet indicated which accessibility features this app supports. Learn More

Information

Provider
  • Pooja Kumari
Size
  • 13.1 MB
Category
  • Developer Tools
Compatibility
Requires macOS 12.0 or later and a Mac with Apple M1 chip or later.
  • Mac
    Requires macOS 12.0 or later and a Mac with Apple M1 chip or later.
Languages
  • English
Age Rating
4+
Copyright
  • © 2026 pgStudio. All rights reserved.
  • Developer Website
  • Privacy Policy

    • More by Pooja Kumari