SQL Migration Visualizer

See your database history the way you think about it.

A folder of numbered .sql files hides everything that matters. SQL Migration Visualizer turns it into a navigable timeline — scoring risky changes, diffing any two versions, and generating the next migration in your database's dialect. All inside the IDE.

IntelliJ 2024.1+ Works fully offline No DB connection needed Free & open source

One schema change. Four dialects. Real output.

This is the actual generator. Pick a change, switch the target database, and watch the SQL — and the risk score — react. Exactly what the plugin produces in your IDE.

SQL Migrations — Create Migration

migration.sql

Same diff, same risk — the generator adapts the SQL strategy to each engine's ALTER rules.

The three things you'll use every day

Timeline View

Every schema version on one strip — table counts, change summaries, and a jump to the exact migration file. Your history stops being tribal knowledge.

Risk Scoring

Dropped columns, narrowing types, tightening nullability — each migration is scored High / Medium / Low before it ever reaches review. The dangerous one never slips through.

Suggested Migrations

Edit your schema and the plugin drafts the migration from the actual diff — in your dialect, with a banner the moment it detects a saved change.

…and six more inside

Schema Diff

Compare any two versions side by side — added, removed, and modified tables and columns, highlighted.

ER Diagram

Table relationships with zoom, pan, and clean PNG export for design docs and pull requests.

Validation

Catch version gaps, duplicates, invalid alters, and inconsistent history before they cause runtime errors.

Full-text Search

Find any table or column across every version of your schema in a single keystroke.

Dialect-aware SQL

Generic, PostgreSQL, MySQL/MariaDB, and SQLite — each with its own ALTER rules and safe rebuilds.

Create & Manage

Draft, edit, delete, and renumber migration files right in the IDE — no folder spelunking.

Generates the right SQL for your database

The generator respects each dialect's ALTER rules and falls back to a safe table rebuild when a change can't be made in place.

Generic SQLPortable output; rebuilds tables for any column modification.

PostgreSQLIn-place ALTER COLUMN … TYPE / SET NOT NULL / SET DEFAULT.

MySQL / MariaDBIn-place MODIFY COLUMN and CHANGE COLUMN for changes and renames.

SQLiteAutomatic 12-step rebuild with PRAGMA foreign_keys guards, since SQLite can't ALTER COLUMN.

Frequently asked

Which IDEs does it work with?

Any IntelliJ-based IDE on build 2024.1 or newer — IntelliJ IDEA Community and Ultimate, plus the rest of the JetBrains family. No edition-specific features are required.

Does it need a database connection?

No. It parses your migration and schema .sql files statically — it never connects to a database and works fully offline. Nothing leaves your machine.

What migration layouts does it detect?

Common locations are auto-detected: src/main/sqldelight, src/commonMain/sqldelight, db/migrations, database/migrations, migrations, src/main/resources/db/migration(s), and …/schema. You can also point it at any folder in Settings → Tools → SQL Migration Visualizer.

Which file naming patterns are recognised?

Plain versions (1.sql, 2.sqm), version + name (12_add_users.sql), and Flyway-style (V3__create_orders.sql).

Which SQL dialects can it generate?

Generic SQL, PostgreSQL, MySQL/MariaDB, and SQLite — each with its own ALTER rules and safe table rebuilds. Set your default in the plugin settings.

Is it free?

Yes — free and open source under the GPL v3.0 license.

Make your schema history reviewable today

Grab the latest pre-built plugin ZIP — no account, no telemetry.

Install in IntelliJ via Settings → Plugins → ⚙ → Install Plugin from Disk. JetBrains Marketplace listing coming soon.

Or build from source

bash

$ git clone https://github.com/jakubn11/sql-migration-visualizer.git
$ cd sql-migration-visualizer
$ ./gradlew buildPlugin

Then load the ZIP from build/distributions/.