PG Orbit - Postgres Client 4+

New in PG Orbit: lightning-fast SQL autocomplete, readable system catalogs, and smarter connection forms—your secure PostgreSQL admin hub with premium upgrades.

Desktop-Class Database Management in Your Pocket

Transform your iPhone and iPad into a powerful PostgreSQL client with PG Orbit - the first mobile-first database management app designed for developers, DBAs, and data professionals who need secure database access on the go.

Why Choose PG Orbit?

Unlike desktop-only tools, PG Orbit brings professional database management to iOS with an intuitive touch interface that doesn't compromise on functionality or security.

FREE FEATURES:
• Browse & Query - Explore tables, views, and execute SELECT queries with advanced filtering
• Advanced Filtering - Multi-column filters with AND/OR logic and custom operators
• Table Designer - Create and modify database tables with intuitive visual editor
• Secure Connections - SSL/TLS encryption and SSH tunneling with key management
• SSH Key Management - Store and manage SSH private keys securely with passphrase support
• Multiple Connections - Connect to and manage multiple databases simultaneously
• Cloud Database Discovery - Automatically discover and connect to PostgreSQL databases across major cloud providers (AWS, Google Cloud, Azure, DigitalOcean, Linode) with one-tap setup
• Interactive Data Viewing - Touch-optimized data browsing with responsive design
• Mobile-First Design - Adaptive UI for iPhone, iPad, and iPad Pro with gesture navigation
• Schema Explorer - Navigate databases, tables, views, functions, and sequences
• Query Editor - Built-in SQL editor with syntax support and quick action chips

PREMIUM FEATURES ($9.99):
• Write Operations - Full INSERT, UPDATE, DELETE, CREATE, ALTER, DROP capabilities
• CSV Export - Export query results and table data with progress tracking
• Advanced Queries - Complex SQL features, stored procedures, and DDL operations
• Cell Editing - Direct data editing with context menus and validation
• Table Modifications - Apply table structure changes with preview and validation

SECURITY FIRST:
• Biometric Protection - Secure your app with Touch ID, Face ID, or Fingerprint
• Auto-Lock Security - Automatic app lock when switching between apps
• SSH Key Management - Securely store RSA, Ed25519, and OpenSSH private keys
• Passphrase Protection - Encrypted storage of SSH key passphrases in iOS Keychain
• Encrypted Storage - Industry-standard encryption using iOS secure storage
• SSL/TLS Support - Secure database connections with certificate validation
• SSH Tunneling - Enhanced security with password and key-based authentication
• Local Storage - Your credentials stay on your device, never on external servers

iOS OPTIMIZED:
• Native iOS interface with familiar gestures and navigation patterns
• Adaptive layouts for iPhone, iPad, and iPad Pro with split-screen support
• Dark Mode support following iOS system preferences automatically
• Enhanced Connection Monitoring - Stable SSH connections with network detection
• Optimized performance for iOS hardware and battery life
• Seamless integration with iOS sharing, Files app, and multitasking
• Touch-friendly data tables with swipe gestures and context menus

PERFECT FOR:
• Database administrators managing PostgreSQL remotely
• DevOps engineers using key-based authentication
• Developers debugging queries on the go
• Data analysts exploring datasets with export capabilities
• Students learning SQL and database concepts
• Teams needing secure mobile database access