TablePro for iPhone and iPad

Each connection opens on its tables, with the query editor, your history and the connection’s details in their own tabs.

Rows show as cards, with the primary key or first column as the title and the next columns under it. Sort by any column, search every column except binary ones, and stack filters with AND or OR. Choose how many rows a page holds and jump to any page. Tap a foreign key value to preview the row it points to. The Structure view lists the table’s columns, indexes and foreign keys.

Open a row to edit it: change values, set NULL, and confirm before it saves. You can also insert and delete rows, and truncate or drop a table. Editing and deleting rows needs a primary key, and nothing changes on a Read-Only connection.

Write SQL with syntax highlighting, run it, and stop it while it runs. Start from a SELECT template, then copy or share the results as JSON, CSV or SQL INSERT statements, through the clipboard or the share sheet.

The app keeps up to 10,000 rows of a result; add a LIMIT to see a different part of a large one. History keeps your last 200 queries on this device, across connections, and does not sync.

While a query runs, a Live Activity shows its progress on the Lock Screen and in the Dynamic Island: the elapsed time and the rows received. The Lock Screen and the expanded Dynamic Island show the SQL too, unless you turn on Settings > Live Activities > Hide Query.

SSH tunnels sign in with a password or a private key, from a file or pasted in, with an optional passphrase. The first time you reach a server, the app shows its host key fingerprint and asks you to trust it.

TLS is set per connection. MySQL, MariaDB, TiDB, OceanBase and PostgreSQL connections can verify the server’s certificate and host name and present a client certificate, from a file, pasted text or a PKCS#12 bundle. Redis connections can verify the certificate and present a client certificate too. SQL Server can encrypt the connection (Required) but does not verify the certificate. Certificates stay on this device and never sync.

Passwords and pasted keys are stored in the Keychain. A SQL Server connection that uses Microsoft Entra ID can sign in here once it syncs from your Mac; Windows authentication is not supported. To reach a server by its .local name on your network, allow Local Network access when iOS asks.

Each connection has a Safe Mode level: Off, Confirm Writes and Read-Only. Confirm Writes asks before a statement that changes data runs. Read-Only refuses it before it reaches the server. A statement the app can’t identify as a read counts as a write.

Set a connection’s level in its Organization section, and the level new connections start with in Settings. Shortcuts that add rows follow the same level.

In Settings > Security, lock the app with Face ID or Touch ID, with your passcode as the fallback. Once it is on, the app asks every time it starts and again after the Auto-Lock time you choose.

Open Connection opens a connection from a shortcut or from Siri. Add Row to Table and Add Rows to Table insert into a table without opening the app, from JSON or CSV text or a file. They run only while the device is not locked, follow the connection’s Safe Mode level, and don’t work with Redis connections.

Quick Connect widgets put your first connections on the Home Screen, and a tap opens one. Your connections also appear in Spotlight search.

Nothing goes to TablePro unless you turn on Share Usage Data, during setup or later in Settings > Privacy. If you do, the app sends one report a day with a hashed device ID, the app and iOS versions, the processor architecture, its language, the types of database you use, a connection count and a few first-use dates. Never hostnames, usernames, passwords, queries or rows.

The app makes no license check, no update check and no plugin request. Your queries go to your own servers, iCloud Sync to your own iCloud account, and Entra sign-in to Microsoft. The privacy policy has the details.