SQL Schema Change Analyzer

Compare columns and key constraints in a declared PostgreSQL-like DDL subset without contacting a database.

On-device No sign-up Free to use

Compare DDL schemas controls

Showing an example. Edit to see your own.

Processed in your browser. Your inputs stay on this device.

Result

Showing an example.

Compare supported CREATE TABLE columns, keys and constraints.

Changing items.name from TEXT to TEXT NOT NULL produces one breaking finding: NOT NULL false -> true.

Loading the tool. Your result will appear here.

https://usefreetools.net/sql-schema-change-analyzer · 20 November 2026

Was this helpful?

How to use SQL Schema Change Analyzer

  1. Paste the before and after CREATE TABLE declarations.
  2. Confirm the PostgreSQL-like subset matches the supplied syntax.
  3. Review column removals, type changes, nullability and key changes.
  4. Export the findings and prepare any migration separately under database review.

Example: SQL Schema Change Analyzer

Compare supported CREATE TABLE columns, keys and constraints.

You add
Before CREATE TABLE declarations: CREATE TABLE items (id INT PRIMARY KEY, name TEXT); After CREATE TABLE declarations: CREATE TABLE items (id INT PRIMARY KEY, name TEXT NOT NULL); Declared SQL dialect: postgresql-subset
You get
Changing items.name from TEXT to TEXT NOT NULL produces one breaking finding: NOT NULL false -> true.

Supported inputs and limits

  • Each DDL input is limited to 100,000 UTF-8 bytes, 12 tables, 120 total columns, 12,000 tokens and 40 foreign keys.
  • Only the existing PostgreSQL-like CREATE TABLE parser subset is accepted.
  • Supports named columns, documented plain types and primary, unique or foreign keys.
  • Defaults, CHECK, named constraints, indexes, generated expressions, ALTER and MySQL/MariaDB options are refused.
  • No database is contacted and no executable migration is produced.
More details

Type and key changes require review rather than automatic safety classification.

Where your input is processed

This tool does not upload your inputs. See the limits for anything saved on your device.

Questions about SQL Schema Change Analyzer

Can I compare a MariaDB schema dump?

Only statements that fit the declared PostgreSQL-like subset are supported. MariaDB dialect options, backticks, engine clauses and other unparsed syntax are refused.

Does a type change always count as breaking?

A type change is marked for review. Actual compatibility depends on the database, values, conversion rules and clients, which this local structural comparison does not execute.

Will the tool create or apply ALTER statements?

It exports a change report. Migration generation and execution are deliberately outside this tool, so a report cannot change your database.

Page updated · Project managed by Tony Hines · Report a problem with SQL Schema Change Analyzer