PG Orbit vs MobileDB

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.

MobileDB is a native PostgreSQL client for iPhone and Apple Watch. Connect straight to any Postgres database — over TLS or an in-app SSH tunnel — and browse, query, chart and edit your data from anywhere. Ask questions in plain English and get answers. No backend, no account: credentials stay in the iOS Keychain and data travels only between your device and your servers. TRY IT INSTANTLY • Tap "Try the Demo" for a built-in sample database — no account, server or setup CONNECT YOUR WAY • Paste a connection URL from Supabase, Neon, Railway, Render, Heroku or AWS • Passwords and SSH keys secured in the Keychain • TLS (require, verify, self-signed) and built-in SSH tunneling with host-key pinning BROWSE • Schema → table → row navigation with search • Schema Map: every table and foreign key in an interactive diagram • Data grid with sorting, filters and foreign-key jumps • JSON/JSONB values as a collapsible tree ASK AI • Ask "how many users signed up this week?" and get the number, a table or a chart. Queries run read-only and time-limited; anything that changes data is never run automatically • "Hey Siri, ask MobileDB…" — spoken answers on your phone and watch, and in Shortcuts • Build dashboard widgets and new rows from a sentence • Free and private with Apple Intelligence — the on-device model runs on your phone • Or bring your own key for any OpenAI-compatible provider. Only your schema and question are sent — no row data unless you allow it QUERY & EDIT • SQL editor with syntax highlighting and autocomplete • Charts, history, saved queries, CSV/JSON export • Type-aware row editor: insert, update, duplicate and delete by primary key DASHBOARDS • "Build me a dashboard": MobileDB finds users, orders and revenue and proposes cards, each checked against your data • Guided cards (totals, trends, breakdowns) or custom SQL, with trends vs the previous period • Share any card or dashboard as a polished image WIDGETS, ALERTS & WATCH • Dashboard metrics on your Home Screen, Lock Screen and Apple Watch • Daily digest: yesterday's key numbers each morning • Alerts when a metric crosses a threshold or jumps or drops • Live Activities: pin a metric to the Lock Screen; long queries show in the Dynamic Island with a Stop button • Always read-only, and only for connections you allow WORK SAFELY IN PRODUCTION • Tag connections as Development, Staging or Production, with an always-on red banner • Read-only sessions, and a guard before UPDATE/DELETE without WHERE, TRUNCATE, DROP or ALTER • Privacy mode hides emails, phone numbers and names for screen-sharing • Users & permissions: roles, grants, who can write to each table, and RLS policies • Optional Face ID lock Find saved queries, dashboards and tables from Spotlight. MobileDB collects no analytics, shows no ads and has no servers of its own.