Portbase vs Postgres & Friends

Portbase is a database client for MySQL, MariaDB, PostgreSQL, MongoDB, SQLite, Redis, ClickHouse and Elasticsearch on iPhone and iPad. • SQL consoles with autosaved drafts, completion, formatting, Explain and execution at the cursor. • Browse supported schemas, views, indexes, keys and DDL; follow related SQL rows. • Resize, pin, hide and sort result columns. Select and copy cell ranges. • MongoDB Find, Aggregation and Command editors with typed BSON document editing, table views and charts. • Create local SQLite databases or import a consistent snapshot. Files stay on this device. • Browse Redis keys with SCAN; inspect strings, hashes, lists, sets, sorted sets and streams; manage expiration and reviewed writes. • Query ClickHouse over HTTP(S). Inspect Elasticsearch mappings, search documents and aggregations. • Inspect chart points, filter dates, open matching loaded rows and export PNG/PDF. • Save unlimited connections, queries and charts, with Trash and recovery. • TLS and SSH connection options. Connection secrets stay in this device’s Keychain. Operations vary by engine. Manual Commit/Rollback is available for MySQL, MariaDB and PostgreSQL. CSV/JSON import and full query export are available for MySQL, MariaDB, PostgreSQL, MongoDB and SQLite; other engines export loaded results. Tables display up to 10,000 rows. Charts inspect loaded results; full exports respect the query’s filters and limits. MongoDB document editing requires MongoDB 4.2 or later and a transaction-capable replica set or sharded cluster. Redis supports standalone endpoints, without Cluster/Sentinel discovery or scripting. SQLite commands commit individually; manual console transactions and temporary objects are unavailable.

Postgres & Friends is a database client for iPhone and iPad. Connect to the databases you already run, browse what is inside them, and run the query you need — without opening a laptop. SIX ENGINES, ONE APP • PostgreSQL • MySQL • SQLite — open a database file straight from the Files app • Redis • MongoDB • Cloudflare D1 — over Cloudflare's REST API BROWSE YOUR DATA Move from connection to database to table, and page through rows without dragging the whole table down the wire. Search inside a result set, tap any row to read long values in full, or switch to the structure view when you need column types and keys. WRITE REAL SQL A proper editor with syntax highlighting, not a single-line text box. Every statement you run is kept in a local query history, and the ones worth reusing can be saved. A built-in, filterable cheat sheet sits one tap away for the syntax nobody memorises on a phone keyboard. REACH PRIVATE DATABASES Most databases worth connecting to are not open to the internet. Tunnel through a bastion host over SSH, using either a password or an OpenSSH private key. SHARE THE ANSWER Export the rows you are looking at as CSV and send them straight from the iOS share sheet. YOUR DATA STAYS YOURS There is no account to create and no server of ours in the path between the app and your database. Passwords and SSH keys are stored in the iOS Keychain; saved connections, query history, and saved queries live in the app's own sandbox on your device. No analytics, no telemetry, no tracking SDKs. FREE AND PRO Free includes up to three saved connections, table browsing, SQL execution, query history, and SSH tunnels across every supported engine. Pro removes the connection and tab limits and adds the full SQL editor, CSV export and sharing, and light and accent themes. It is available monthly, yearly, or as a one-time Lifetime purchase — all three unlock exactly the same features. Privacy Policy: https://postgresfriends.pages.dev/privacy Terms of Service: https://postgresfriends.pages.dev/terms