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.