Getting Started with the Portbase Beta
About Portbase
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.
