PG Orbit - Postgres Client
開發人員工具
免費 · App 內購買
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 — WITH PRO ($4.99/MONTH OR $29.99/YEAR) OR LIFETIME ($59.99 ONCE):
• 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):
• Included in Pro, the subscription with Premium; yearly Pro starts with a 7-day free trial for new subscribers
• Lifetime owners can add Sync for $2.99/month or $19.99/year; 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. Pro is $29.99 a year; Lifetime is $59.99, once.
SUBSCRIPTION TERMS
Pro ($4.99 per month or $29.99 per year; yearly may start with a 7-day free trial for new subscribers) and Sync ($2.99 per month or $19.99 per year) are auto-renewing subscriptions. 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. Lifetime Premium ($59.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
更多 PG Orbit 2.11 — clearer data, faster browsing.
NEW
• Generate Ed25519 SSH keys in the app, alongside RSA and ECDSA
• AWS discovery covers every region and every instance
IMPROVED
• Every value reads the way PostgreSQL prints it: money, ranges, arrays of any depth, bit strings, intervals, network addresses, JSON and exact decimals
• A NULL is dimmed and in italics, so it is easy to tell from text that says "NULL"
• The app opens straight to your connections, large tables open without waiting for a row count, and the schema tree loads much faster
• Filters and sorting stay with you across pages and refreshes, work on views and materialized views, and "Export all matching rows" exports exactly what you filtered
• CSV export honours LIMIT, keeps every column, and cancels cleanly
• The table designer applies your changes together, so a table is never left half altered
• Tables without a primary key are safe to edit: a change touches only the row you picked
• SSH tunnels and Kubernetes port-forwards are shared between the databases of a connection and recover on their own
• Sync keeps the newest edit of a connection and keeps verify-full on every device
• Functions that share a name are listed with their arguments
• Clearer answers when buying or restoring a purchase
• Around 80 more texts are translated to Spanish
2.11.0 11月11日
PG Orbit 2.10 — Lifetime Premium follows your account.
NEW
• Lifetime Premium bought in the App Store now unlocks Premium on every platform: sign in and it follows your account to your other devices, including Windows, Linux, and Android
FIXED
• If your Sync plan is billed somewhere else, PG Orbit no longer offers Pro here, where it would be charged on top of Sync. Upgrade where you subscribed
2.10.0 11月10日
PG Orbit 2.9.2 — a clearer upgrade screen, and PG Orbit on Windows.
NEW
• PG Orbit is now on Windows: your connections and saved queries sync with your PC too
CHANGED
• A new upgrade screen: Pro Yearly, Pro Monthly, and Lifetime side by side, with what each includes and one button for the plan you pick
• The welcome screen shows both ways to get Premium: Pro, the subscription with Sync, or Lifetime, a one-time purchase
• Clearer purchase terms: Pro renews until you cancel it; Lifetime Premium is a one-time purchase
2.9.2 11月9日
PG Orbit 2.9.0 — introducing PG Orbit Pro.
NEW
• PG Orbit Pro: Premium and Sync in one subscription, with a 7-day free trial on yearly for new subscribers
• Subscribed to Sync? Upgrade to Pro from Sync settings; the rest of your Sync plan is credited
CHANGED
• The upgrade screen shows Pro first, then Lifetime Premium, the one-time purchase
• Own Lifetime Premium? Sync settings offer Sync on its own
2.9.0 11月7日
PG Orbit 2.8.0 — smoother sign-in and upgrades.
FIXED
• Email sign-in codes are digits only, so you can type them on the number pad
• Upgrade in the Premium notice now opens the upgrade screen
2.8.0 11月3日
PG Orbit 2.7.1 — made for iPhone Duo, plus complete SQL scripts.
NEW
• On iPhone Duo, the unfolded workspace wraps around the status bar in the corner, so tables, the SQL editor, and results use the full width of the screen. A thin outline marks the corner the status bar keeps
• Run multiple SQL statements together, including BEGIN, functions, constraint triggers, and COMMIT. Statements run in order on the same database connection
• Switch between each statement's results and export the selected result
FIXED
• In landscape, the connections list no longer runs under the status bar or camera cutout
• SQL errors and cancellations stop execution and roll back any uncommitted transaction
• Parameters inside SQL function definitions no longer appear as query inputs
Read-only scripts are free. Scripts that write data or change your schema require Premium.
2.7.1 10月20日
PG Orbit 2.7.0 — run complete SQL scripts with one tap.
NEW
• Run multiple SQL statements together, including BEGIN, functions, constraint triggers, and COMMIT. Statements run in order on the same database connection
• Switch between each statement's results and export the selected result
FIXED
• SQL errors and cancellations stop execution and roll back any uncommitted transaction
• Parameters inside SQL function definitions no longer appear as query inputs
Read-only scripts are free. Scripts that write data or change your schema require Premium.
2.7.0 10月19日
PG Orbit 2.6.0 — see what's new after every update, a tidier sidebar, and sturdier Premium.
NEW
• After an update, PG Orbit shows what's new in the version you just installed
IMPROVED
• Tables, views, and other objects in the sidebar are no longer indented far past their folder, so long names fit on one line
PREMIUM
• Re-entering a license key on the same device no longer uses another activation, and devices unused for 90 days free their slot
• On Mac, App Store purchases are re-confirmed with the App Store at launch, and again when the app comes back to the foreground if that check couldn't finish
• On Mac, Premium unlocked with a license key in 2.5.x needs the key entered once more after updating. If you bought on the web and are signed in, Premium comes back on its own the next time the app is online
2.6.0 10月13日
PG Orbit 2.5.1 — query parameters, plus a fix for the Create Table screen on iPhone.
QUERY PARAMETERS (NEW)
• Write $1, $2 where a value goes in any query or saved query, exactly as PostgreSQL does, and a field for each one appears under the editor, labelled with the surrounding SQL (email = $1)
• Fill in the fields and press Run. Values are remembered for the next run, survive edits to the query, and also apply to Run & Export
• Use "Add parameter" in the toolbar or menu to insert the next $n at the cursor, so nothing has to be typed on a phone keyboard
• Values go in as quoted literals, or as table and column names after FROM, JOIN, INTO, UPDATE, TABLE and BY, so `select * from $1` works
• A $1 inside a string, comment, function body or PREPARE statement is left alone
ALSO FIXED
• On iPhone, typing a column name, length or default value in the Create Table screen no longer closes the keyboard after every character
• On iPhone the table pagination bar, query status bar and other bottom controls in the connection workspace no longer sit under the home indicator
2.5.1 9月10日
PG Orbit 2.4 — Kubernetes connections, connection links, and safer SSH.
KUBERNETES CONNECTIONS (NEW)
• Connect to PostgreSQL and CloudNativePG running inside a Kubernetes cluster with a native port-forward — no kubectl needed
• Import your kubeconfig from a file or paste it; namespaces and services are discovered automatically
• Kubeconfig credentials stay in your device's keychain
PASTE A CONNECTION LINK
• Paste a DATABASE_URL, postgres:// or postgresql:// value from the Connections menu and PG Orbit prefills a secure direct connection
SAFER SSH TUNNELS
• PG Orbit now verifies the SSH server's SHA-256 host key fingerprint: you confirm it on the first connection, matching keys reconnect silently, and a changed key shows both fingerprints before you decide
• SSH handshake and authentication timeouts are now enforced
• Tunnels use modern encryption only. Very old SSH servers (roughly pre-2016) that offer only legacy algorithms may need their sshd configuration updated
ALSO FIXED
• Table column sorting keeps its direction across reloads and shows distinct ascending and descending indicators
• Signing out of Sync now also clears the Google session, so switching accounts works reliably
Under the hood: updated to the latest Flutter and dependency releases.
2.4.0 9月6日
• 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.1 8月9日
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
2.0.0 7月31日
• 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.11.0 6月25日
- 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.10.0 5月19日
- 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.
1.9.1 4月8日
Filter panel and toolbar no longer disappear when a filter returns no results.
1.8.5 4月6日
Database listing no longer fails on Heroku-managed Postgres (and other shared hosting) when the server contains databases the user lacks permission to access. Inaccessible databases are filtered out, and a subtle note shows how many were hidden.
1.8.4 3月29日
Columns in the Structure tab no longer appear multiple times when the same table or view name exists in other schemas
1.8.3 3月10日
Tables and views with the same name in other schemas no longer appear multiple times when browsing a schema
1.8.2 3月7日
Much more reliable editing and insertion of JSON/JSONB values — smart quotes and tricky characters now work smoothly without errors
Better reconnection handling: the app automatically recovers when switching servers or after network interruptions
Switching servers no longer causes table selection glitches or stale data
Updated CSV export to the latest format for better compatibility
General stability & dependency updates
1.8.1 2月13日
- Hardened schema loading to qualify `pg_namespace` OIDs and gracefully fall back when descriptions are unavailable, so browsing works on databases that hide system OIDs.
1.8.0 07/12/2025
Added:
- SSL mode selector in connection form with options: require and verify-full.
- CA Certificate field for pasting PEM certificates when using Verify-Full SSL mode
- Advanced SSL Options section for client certificate and private key (mutual TLS authentication)
General bug fixes and improvements.
1.7.0 30/11/2025
Fixed query history initialization so history, favorites, and stats load without errors after running queries
1.6.1 24/10/2025
New:
- Supercharged query editor autocomplete: instant PostgreSQL keyword hints, one-tap table suggestions with schema context, and inline column/type recommendations that stay visible even when the keyboard is up.
Fixed:
- Decode binary-encoded PostgreSQL `oid` and boolean values so system catalog queries (e.g. `SELECT * FROM pg_roles;`) show readable results in the inspector.
- Connection create/edit forms now disable autocorrect on technical fields so hostnames, usernames, and ports stay untouched while the connection name remains editable with suggestions.
1.6.0 10/10/2025
- Can now clone a connection for faster setup.
- Reuse persistent PostgreSQL connections across query editor, schema/browser flows, and admin operations for snappier round-trips while releasing them automatically on close.
1.5.1 02/10/2025
PG Orbit 2.11 — clearer data, faster browsing.
NEW
• Generate Ed25519 SSH keys in the app, alongside RSA and ECDSA
• AWS discovery covers every region and every instance
IMPROVED
• Every value reads the way PostgreSQL prints it: money, ranges, arrays of any depth, bit strings, intervals, network addresses, JSON and exact decimals
• A NULL is dimmed and in italics, so it is easy to tell from text that says "NULL"
• The app opens straight to your connections, large tables open without waiting for a row count, and the schema tree loads much faster
• Filters and sorting stay with you across pages and refreshes, work on views and materialized views, and "Export all matching rows" exports exactly what you filtered
• CSV export honours LIMIT, keeps every column, and cancels cleanly
• The table designer applies your changes together, so a table is never left half altered
• Tables without a primary key are safe to edit: a change touches only the row you picked
• SSH tunnels and Kubernetes port-forwards are shared between the databases of a connection and recover on their own
• Sync keeps the newest edit of a connection and keeps verify-full on every device
• Functions that share a name are listed with their arguments
• Clearer answers when buying or restoring a purchase
• Around 80 more texts are translated to Spanish
更多 版本2.11.0 11月11日
不收集資料 開發者不會從此 App 收集任何資料。