PostgreSQL Migration Safety Analyzer

Paste a PostgreSQL migration and see what it will do to a live database before you run it.

This free checker parses your SQL with the real PostgreSQL parser and flags statements that take heavy locks, rewrite whole tables, fail on existing data, or lose it — adding NOT NULL columns, changing column types, creating indexes without CONCURRENTLY, adding constraints, DROP / TRUNCATE, and more. PostgreSQL only: MySQL and SQL Server migrations are not supported. Anything it cannot classify is listed as not analyzed, never reported as safe.

Keyboard shortcuts: Ctrl/Cmd + Enter to analyze, Ctrl/Cmd + K to clear