Skip to content

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.

TablePro on a Mac, showing the ALTER TABLE statement for a new column before it is saved.

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.

An ER diagram of the shop schema with its tables and relationships, product_tags shown as a many-to-many line between products and tags.

Compare & Sync

Pro

Compare 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.

Compare & Sync between shop and shop_staging, listing a column whose length differs and a DROP COLUMN held back from the script.

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.

The Copy To review in TablePro on a Mac, with the DDL, row counts and type conversions for a copy to a SQLite file.

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.

The Server Dashboard for a PostgreSQL server, listing active sessions with a long-running SELECT selected and the Terminate button visible.

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.