# PG Orbit

> PG Orbit is a native PostgreSQL client for iPhone, iPad, Android, and macOS, made by Acrogenesis LLC. It speaks the Postgres wire protocol directly from the device — queries never pass through PG Orbit's servers. Free tier is read-only; Premium is a $9.99 one-time purchase (write operations, CSV export, table designer); Sync is an optional subscription ($1.99/month or $14.99/year) that syncs connection settings and saved queries across devices while passwords, SSH keys, and passphrases stay in the device keychain.

Key facts:
- Platforms: iOS 15+, Android, macOS 12+ (signed, sandboxed Mac App Store app)
- Direct PostgreSQL connections with SSL/TLS (Require and Verify-Full, client certificates) and SSH tunnels (password or key auth; import RSA/Ed25519 keys, generate RSA on device)
- SQL editor with schema-aware autocomplete, find & replace, saved queries, query history
- Data grid with multi-column AND/OR filters and in-place editing (Premium)
- Cloud discovery imports instances from AWS, Google Cloud, Azure, DigitalOcean, Linode, and Supabase
- Sync (2.0): one account via Sign in with Apple, Google, or email code; syncs connections and saved queries; query-history sync is opt-in and off by default; secrets never sync
- App Store: https://apps.apple.com/app/pg-orbit/id6746734362
- Google Play: https://play.google.com/store/apps/details?id=com.acrogenesis.pg_orbit

## Pages

- [Home](https://pgorbit.com/): product overview
- [PG Orbit for Mac](https://pgorbit.com/mac): the desktop app
- [Pricing](https://pgorbit.com/pricing): free vs Premium vs Sync comparison
- [FAQ](https://pgorbit.com/faq): common questions
- [Changelog](https://pgorbit.com/changelog): release notes

## Features

- [SQL editor](https://pgorbit.com/features/sql-editor)
- [Data grid and in-place editing](https://pgorbit.com/features/data-grid)
- [SSH tunnels and key management](https://pgorbit.com/features/ssh-tunnels)
- [Security model](https://pgorbit.com/features/security)
- [Sync across devices](https://pgorbit.com/features/sync)
- [Cloud discovery](https://pgorbit.com/features/cloud-discovery)
- [Visual table designer](https://pgorbit.com/features/table-designer)
- [CSV export](https://pgorbit.com/features/csv-export)

## Guides

- [Connect to Heroku Postgres](https://pgorbit.com/guides/heroku-postgres)
- [Connect to Supabase](https://pgorbit.com/guides/supabase)
- [Connect to AWS RDS](https://pgorbit.com/guides/aws-rds)
- [Connect to DigitalOcean](https://pgorbit.com/guides/digitalocean)
- [Connect to Azure Database for PostgreSQL](https://pgorbit.com/guides/azure-database)
- [Connect to Google Cloud SQL](https://pgorbit.com/guides/google-cloud-sql)
- [Connect to Neon](https://pgorbit.com/guides/neon)

## Legal

- [Privacy policy](https://pgorbit.com/privacy-policy)
- [Terms of service](https://pgorbit.com/terms-of-service)