Free
About
A versatile database client for managing SQL and NoSQL databases on iOS devices. It offers robust tools for querying, editing, and visualizing data across various database engines.
✓SQL consoles with autosaved drafts and completion
✓Browse and edit MongoDB documents and aggregations
✓Manage Redis keys and data types
✓Query ClickHouse and Elasticsearch
✓Create and import local SQLite databases
✓Save unlimited connections and queries
✓TLS and SSH connection options
Show original description
What's New in Portbase
2.1.0
October 30, 2026
Portbase 2.1 adds Ask AI, a database expert that reads your schema, writes queries and charts, and runs queries only after you approve them. Charts become dashboard pages with resizable tiles and cached results. Edit query results directly, change many cells at once, delete rows, and review every statement before it is submitted. The SQL editor gains context-aware completion with join suggestions, parameter hints, bracket pairing, and structure-aware formatting. Explore a schema as an entity-relationship diagram and compare schemas across connections. Every engine, including MongoDB, accepts connection strings, and passwords and keys can sync through iCloud Keychain. iPad uses the bottom tab bar, and the Mac gets a tabbed window and a quieter, faster interface.
MoreUser reviews
Developer apps
FAQ
What databases can Portbase connect to?
Portbase supports a wide range of databases including MySQL, MariaDB, PostgreSQL, MongoDB, SQLite, Redis, ClickHouse, and Elasticsearch on iPhone and iPad.
Does Portbase offer advanced SQL features?
Yes, Portbase provides SQL consoles with features like autosaved drafts, code completion, formatting, Explain plans, and execution at the cursor.
How does Portbase handle data visualization?
You can inspect chart points, filter dates, open matching loaded rows, and export charts as PNG or PDF files directly within the app.
Is Portbase suitable for managing local databases?
Yes, you can create local SQLite databases or import consistent snapshots, with all files remaining on your device for enhanced privacy.
What security features does Portbase include for connections?
Portbase offers TLS and SSH connection options, and all connection secrets are securely stored within the device's Keychain.
Can I recover deleted connections or queries in Portbase?
Portbase includes a Trash feature with recovery options, allowing you to restore unlimited saved connections and queries.
What are the limitations for MongoDB document editing in Portbase?
MongoDB document editing requires MongoDB 4.2 or later and a transaction-capable replica set or sharded cluster for full functionality.
How frequently is Portbase updated?
The latest version, 2.1.0, was released on 2026-10-30, indicating regular updates to enhance features and compatibility.
