PG Orbit vs Postgres Editor

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.

Postgres Editor is a native PostgreSQL client built for every Apple platform — iPhone, iPad, Mac, and Apple Vision Pro. Written entirely in Swift with SwiftUI and powered by Swift NIO, it's the fastest, most seamless way to query and explore your databases wherever you are. Your connections, everywhere: Connections sync automatically via iCloud, so your databases are ready the moment you open the app on any of your devices. Add a connection once, use it everywhere. A query editor that keeps up with you. Write SQL with full syntax highlighting, run queries with a tap, and see results instantly. Export to JSON, browse your schema, and manage multiple connections across production, staging, and local environments — all in one place. AI-Powered Query Assistant. Powered by Apple Intelligence, the built-in Query Assistant understands your SQL in context. Ask it to explain a complex query, find performance issues, or suggest optimizations — without leaving the editor. Built for every Apple platform. iPhone & iPad — Query your databases on the go with a touch-first interface designed for mobile Mac — A full-featured desktop editor with sidebar navigation, multi-connection management, and keyboard-first workflows Apple Vision Pro — Explore your data in a new dimension with a spatial interface that floats in your environment Everything you need, nothing you don't. Native Swift & SwiftUI — fast, responsive, and at home on every Apple platform Swift NIO networking — low-latency, non-blocking database connections iCloud sync for connections across all your devices Saved queries with search Schema browser — navigate databases, tables, and columns instantly SSL support JSON export with one tap Full query log with execution times