# PG Orbit - Postgres Client — A complete PostgreSQL client > Mobile PostgreSQL client for database management and querying on iOS. (iPhone/iPad app by Acrogenesis LLC.) - Source: https://appshunter.io/ios/app/pg-orbit-postgres-client/id6746734362 (this page in markdown: same URL + `.md`) - Developer: [Acrogenesis LLC](https://appshunter.io/developer/1784592807) - Category: Developer Tools, Utilities - Price: Free with in-app purchases - Rating: 5.00/5 from 3 App Store ratings · 2 written reviews indexed - Age rating: 4+ - Requires: iOS 15.0 · 35 MB - Languages: American English - Released: 2025-06-11 - Data updated: 2026-09-05 - Monetization: freemium - User reviews in markdown: https://appshunter.io/ios/app/pg-orbit-postgres-client/id6746734362/reviews.md ## What is PG Orbit? A real PostgreSQL client on your phone. Browse schemas, run queries, and fix data from your iPhone or iPad with PG Orbit — the PostgreSQL client built for developers, DBAs, and data professionals who get paged away from their desk. NEW IN 2.0: SYNC ACROSS DEVICES • One account — Sign in with Apple, Google, or an email code • Connections and saved queries follow you to every device, including the new Mac app • Passwords, SSH keys, and passphrases NEVER sync — they stay in your device's keychain • Query history sync is opt-in and off by default • Desktop-class workspace on iPad: pinned sidebar, object tabs and SQL tabs, keyboard shortcuts (Cmd+T, Cmd+1–9) FREE FEATURES: • Browse & Query — explore tables and views, run SELECT queries with advanced filtering • Advanced Filtering — multi-column filters with AND/OR logic and custom operators • Schema Explorer — databases, tables, views, materialized views, functions, and sequences; works on hardened hosts like Heroku shared plans • SQL Editor — real autocomplete with schema context, find & replace, comment toggle, saved queries, and history with favorites • Secure Connections — SSL/TLS (Require and Verify-Full with client certificates) and SSH tunneling • SSH Key Management — import and store RSA and Ed25519 private keys with passphrase support, or generate an RSA key on device • Multiple Connections — connect to and manage several databases at once • Cloud Discovery — sign in to AWS, Google Cloud, Azure, DigitalOcean, Linode, or Supabase and import your instances with one tap PREMIUM ($9.99, ONE-TIME — YOURS FOREVER): • Write Operations — INSERT, UPDATE, DELETE, CREATE, ALTER, DROP • In-Place Editing — edit cells directly with a tap, set NULL, insert and delete rows • Visual Table Designer — modify table structure with a preview of the exact DDL before it runs • CSV Export — export query results and table data with progress tracking • Sequence Management — inspect and update sequences easily SYNC (OPTIONAL SUBSCRIPTION): • $1.99/month or $14.99/year, auto-renewing — cancel anytime in the App Store • Syncs connection settings and saved queries; secrets never leave your device • Delete your account (and all synced data) from settings at any time SECURITY FIRST: • Biometric protection with Face ID or Touch ID, and auto-lock on app switch • Credentials stored in the iOS Keychain with industry-standard encryption • Your queries run directly from your device to your database — table data never passes through our servers PERFECT FOR: • DBAs managing PostgreSQL remotely • Developers debugging production from anywhere • DevOps engineers who live behind SSH bastions • Data analysts exploring and exporting datasets • Students learning SQL Free forever for read-only. Premium is $9.99, once. ## Key features - Browse and query PostgreSQL databases - Secure SSL/TLS and SSH tunneling - Table designer and schema explorer - Interactive data viewing and cell editing - Cloud database discovery - SQL editor with syntax support ## Pricing and in-app purchases Base price: Free. **One-time purchases** | Purchase | Price | Type | | --- | --- | --- | | PG Orbit Premium Features | $9.99 | one-time | ## Recent user reviews (2 of 2) All indexed reviews: https://appshunter.io/ios/app/pg-orbit-postgres-client/id6746734362/reviews.md ### 4/5 — Doesn’t work with special chars *2025-12-23* The app doesn’t work with special characters like “. It make it virtually useless if you use JSON. As the developper chose to use in-app payment instead of classic app pricing, apple refuses to acknowledge the fact that the application is not working properly and stubbornly refuses refunding. Not fair **Developer response:** Hi jesuisjerem, thank you for the feedback. The special character issue (including “ in JSON) has been fixed in the latest update (1.8.1) please try it now and it should work properly. For bug reports, we have an in-app feedback section that goes directly to us so we can fix issues faster. ### 5/5 — Does the job! *2025-06-25* Very helpful tool for when I'm on the go. ## Frequently asked questions about PG Orbit ### What are the main features of PG Orbit? PG Orbit allows you to browse and query PostgreSQL databases, design tables with a visual editor, and securely connect via SSL/TLS or SSH tunneling. It also offers cloud database discovery and an interactive data viewer. ### What are the premium features in PG Orbit? The premium version, available for $9.99, unlocks write operations (INSERT, UPDATE, DELETE), CSV export, advanced SQL queries, direct cell editing, and table structure modifications with preview. ### How secure is PG Orbit? Security is a priority, with features like biometric protection (Touch ID/Face ID), auto-lock, secure SSH key management, passphrase protection, industry-standard encryption, SSL/TLS support, and SSH tunneling. Credentials are stored locally. ### Is PG Orbit available on Android? PG Orbit is designed for iOS devices, including iPhone, iPad, and iPod, and is optimized for the native iOS interface and gestures. ### How often is PG Orbit updated? The app was last updated on April 8, 2026, indicating active development and support. The latest version is 1.9.1. ### What is the user rating for PG Orbit? PG Orbit has a perfect rating of 5.0 stars based on 3 user reviews, suggesting a highly positive user experience. ### Can PG Orbit connect to cloud databases? Yes, PG Orbit can automatically discover and connect to PostgreSQL databases across major cloud providers like AWS, Google Cloud, Azure, DigitalOcean, and Linode with a one-tap setup. ### Does PG Orbit have ads? No, PG Orbit does not contain advertisements. The app is free to use with optional premium features available via a one-time purchase. ## Version history (last 5 releases) ### 2.0.1 — 2026-08-09 • Slow queries and table loads now offer a Cancel button, and cancelling really stops the query on the server. • Sorting a table by its column header now sorts the whole table, not just the rows on the current page. • Exported CSVs are now reachable: the PG Orbit folder appears in the Files app, and "Open Folder" opens the right place. • Dismissing the purchase sheet no longer blocks buying the same item again. ### 2.0.0 — 2026-07-31 A real PostgreSQL client on your phone. Browse schemas, run queries, and fix data from your iPhone or iPad with PG Orbit — the PostgreSQL client built for developers, DBAs, and data professionals who get paged away from their desk. NEW IN 2.0: SYNC ACROSS DEVICES • One account — Sign in with Apple, Google, or an email code • Connections and saved queries follow you to every device, including the new Mac app • Passwords, SSH keys, and passphrases NEVER sync — they stay in your device's keychain • Query history sync is opt-in and off by default • Desktop-class workspace on iPad: pinned sidebar, object tabs and SQL tabs, keyboard shortcuts (Cmd+T, Cmd+1–9) FREE FEATURES: • Browse & Query — explore tables and views, run SELECT queries with advanced filtering • Advanced Filtering — multi-column filters with AND/OR logic and custom operators • Schema Explorer — databases, tables, views, materialized views, functions, and sequences; works on hardened hosts like Heroku shared plans • SQL Editor — real autocomplete with schema context, find & replace, comment toggle, saved queries, and history with favorites • Secure Connections — SSL/TLS (Require and Verify-Full with client certificates) and SSH tunneling • SSH Key Management — import and store RSA and Ed25519 private keys with passphrase support, or generate an RSA key on device • Multiple Connections — connect to and manage several databases at once • Cloud Discovery — sign in to AWS, Google Cloud, Azure, DigitalOcean, Linode, or Supabase and import your instances with one tap PREMIUM ($9.99, ONE-TIME — YOURS FOREVER): • Write Operations — INSERT, UPDATE, DELETE, CREATE, ALTER, DROP • In-Place Editing — edit cells directly with a tap, set NULL, insert and delete rows • Visual Table Designer — modify table structure with a preview of the exact DDL before it runs • CSV Export — export query results and table data with progress tracking • Sequence Management — inspect and update sequences easily SYNC (OPTIONAL SUBSCRIPTION): • $1.99/month or $14.99/year, auto-renewing — cancel anytime in the App Store • Syncs connection settings and saved queries; secrets never leave your device • Delete your account (and all synced data) from settings at any time SECURITY FIRST: • Biometric protection with Face ID or Touch ID, and auto-lock on app switch • Credentials stored in the iOS Keychain with industry-standard encryption • Your queries run directly from your device to your database — table data never passes through our servers PERFECT FOR: • DBAs managing PostgreSQL remotely • Developers debugging production from anywhere • DevOps engineers who live behind SSH bastions • Data analysts exploring and exporting datasets • Students learning SQL Free forever for read-only. Premium is $9.99, once. SUBSCRIPTION TERMS Sync is an auto-renewing subscription: $1.99 per month or $14.99 per year. Payment is charged to your Apple Account at confirmation of purchase. It renews automatically unless cancelled at least 24 hours before the end of the current period, and your account is charged for renewal within 24 hours before that period ends. Manage or cancel in your Apple Account settings. Premium ($9.99) is a one-time purchase, not a subscription. Terms of Use (EULA): https://www.apple.com/legal/internet-services/itunes/dev/stdeula/ Service terms: https://pgorbit.com/terms-of-service Privacy Policy: https://pgorbit.com/privacy-policy ### 1.11.0 — 2026-06-25 • Materialized views are here. Browse them alongside your tables and views, with a dedicated details panel showing columns, data, the SQL definition, indexes, and statistics (size, row count, and whether the view is populated). • Manage materialized views without leaving the app: create them, refresh (including concurrent refresh), edit the definition, rename, drop, add or remove indexes, and edit comments. • Full management for regular views too: create, edit the definition, rename, and drop — with a dedicated SQL Definition tab. • Export materialized view and view data to CSV. • Fixed DigitalOcean sign-in so connecting your cloud databases works reliably. • Updated underlying libraries and tooling for better stability. ### 1.10.0 — 2026-05-19 - Full hardware keyboard support in the SQL Editor. Type queries naturally on any external keyboard, use the up/down arrows to navigate autocomplete suggestions, and press Enter or Tab to insert the highlighted one. - Smarter autocomplete: the suggestion list now updates live as you delete characters, so narrowing and widening your query is seamless. - Updated underlying libraries for better stability and performance. ### 1.9.1 — 2026-04-08 - Full internationalization (i18n) support with English and Spanish. - Language picker in Settings to switch between System, English, and Español. - Cut/Copy/Paste toolbar now appears when long-pressing in the SQL query editor. - Scroll position is now preserved when navigating back from a table to the database/connection list. Previously the list would reset to the top. ## Apps similar to PG Orbit | App | Rating | Price | Category | | --- | --- | --- | --- | | [SQL Server Mobile Client](https://appshunter.io/ios/app/sql-server-mobile-client/id1406176302) | 4.2 (56) | Free | Developer Tools | | [NeoServer SSH Mosh Terminal](https://appshunter.io/ios/app/neoserver-ssh-mosh-terminal/id6448362669) | 4.8 (288) | Free | Developer Tools | | [PostgreSQL Client](https://appshunter.io/ios/app/postgresql-client/id1233662353) | 4.6 (153) | Free | Developer Tools | | [Schema: A database client](https://appshunter.io/ios/app/schema-a-database-client/id6738075782) | 4.3 (13) | Free | Developer Tools | | [TablePlus - Database Client](https://appshunter.io/ios/app/tableplus-database-client/id1465448609) | 4.4 (76) | Free | Developer Tools | | [SQLPro Studio database client](https://appshunter.io/ios/app/sqlpro-studio-database-client/id1273366668) | 4.3 (62) | Free | Developer Tools | ## More apps by Acrogenesis LLC - [Advanced JSON Viewer](https://appshunter.io/ios/app/advanced-json-viewer/id6739271287) All apps by Acrogenesis LLC: https://appshunter.io/developer/1784592807 --- *Data collected daily from the US App Store and indexed by [AppsHunter](https://appshunter.io/). User reviews are verbatim App Store reviews. Ratings, prices and chart positions refresh continuously; this snapshot is from 2026-09-05.*