Schema and database comparison
See how tables relate, change their structure with the SQL in front of you, and compare two databases before syncing them.


Edit table structure
Change columns, indexes, foreign keys and CHECK constraints in the Structure tab, then read the DDL in Preview SQL before it runs. Type changes, NOT NULL, primary keys and anything destructive ask first, even at Silent. New tables come with a live SQL preview.
Where SQLite needs a table rebuild, TablePro runs it after you confirm; on Turso, remote libSQL and Cloudflare D1 it gives you the script. iPhone and iPad show structure read-only.
Structure read-only: Redis, Amazon Redshift, CockroachDB, Google BigQuery, Elasticsearch, etcd, Apache Kafka, SurrealDB, Beancount, Google Cloud Spanner, Typesense, Weaviate, Cloudflare R2 SQL, SAP HANA
Partly editable: MongoDB, TiDB, Databend, Oracle, ClickHouse, Cassandra, ScyllaDB, Amazon DynamoDB, Snowflake, Cloudflare D1, Turso, libSQL, Teradata, Trino
ER diagram
View ER Diagram draws tables and their foreign keys in crow’s-foot notation. Export it as PNG or SQL, or copy it as an image. It is a view, not a designer: changes happen in the Structure tab.


Compare & Sync
ProCompare the schema or the data of two databases, with views, routines and triggers where supported. The sync script is ordered by foreign keys, destructive changes stay out until you allow them, and a Read-Only connection is never a target. Save a comparison to run it again.
A structure script is written only between databases of the same engine, with MySQL and MariaDB counted as one.


Copy tables between databases
Copy To moves tables and their data to another database, across engines too, once you have reviewed the DDL, the row counts and the type conversions. A conversion can lose a constraint: a MariaDB ENUM becomes a PostgreSQL VARCHAR. Duplicate Database and Transfer To are free as well.


Users, sessions and maintenance
The Server Dashboard shows live sessions, server metrics and slow queries, and cancels a query or ends a session through the connection’s Safe Mode. Users & Roles stages grants and revokes down to a column, with their SQL to review. Maintenance such as VACUUM or OPTIMIZE shows its SQL before it runs.
Server Dashboard: PostgreSQL, MySQL, SQL Server, MariaDB, Amazon Redshift, CockroachDB, ClickHouse, Typesense
Users & Roles: PostgreSQL, MySQL, MariaDB, TiDB, PGlite


Also
Routines, triggers and folders
Read routines and triggers in source tabs, then open them in the editor. Group tables and views into sidebar folders, which sync between Macs with iCloud Sync.
On iPhone and iPad
Columns, indexes and foreign keys are read-only. A table can be truncated or dropped unless the connection is Read-Only.
Get TablePro
Pro adds Compare & Sync. Everything else on this page is free.