Railway Database Schema Diff.
Generate migrations.
Zero setup.

Paste two schema exports from your Railway PostgreSQL or MySQL databases. Spot every table, column, index, and constraint change instantly. Get ready-to-run ALTER TABLE scripts — all in your browser.

No account required. No data leaves your device.

Built for Railway workflows

SchemaLens understands PostgreSQL and MySQL syntax that generic diff tools miss — perfect for Railway's managed database deployments.

🚂

Railway Postgres & MySQL

Diff schemas from Railway-managed PostgreSQL and MySQL databases. Auto-detects dialect from your pg_dump or mysqldump export.

⚡

Environment-to-Environment

Compare schemas between Railway production and staging environments. Export from each environment's database connection and diff them instantly.

📦

Service-Aware

Works with any Railway service that exposes a SQL connection. PostgreSQL, MySQL, or even self-hosted databases connected via Railway TCP proxying.

🔑

Constraints & Indexes

Primary keys, unique constraints, foreign keys, CHECK constraints, and partial indexes — all compared semantically, not by raw text.

📝

Functions & Triggers

Detects CREATE FUNCTION and CREATE TRIGGER changes. Critical for Railway projects that use database functions for data transformations.

🔒

Privacy First

Your schema never leaves the browser. Compare production Railway schemas safely without uploading sensitive table structures to a third-party server.

How it works

Export your Railway schemas

Run pg_dump --schema-only or mysqldump --no-data against your Railway database connection string, or use the Railway CLI.

Paste into SchemaLens

Copy the SQL into the two editor panes. Auto-detects PostgreSQL or MySQL dialect from your Railway database export.

Review the diff

See added tables, dropped columns, type changes, and constraint modifications highlighted in color. Breaking changes flagged in red.

Copy the migration

Export ALTER TABLE scripts, save as Markdown, PDF, or raw SQL. Apply via your Railway project's migration workflow.

Railway migration examples

SchemaLens generates production-ready ALTER TABLE scripts for every change it detects in your Railway database.

Column type change (PostgreSQL)

ALTER TABLE "users"
  ALTER COLUMN "bio" TYPE VARCHAR(500);

Add a new column (MySQL)

ALTER TABLE `orders`
  ADD COLUMN `shipped_at` DATETIME;

Add a foreign key (PostgreSQL)

ALTER TABLE "comments"
  ADD CONSTRAINT "fk_comments_post"
  FOREIGN KEY ("post_id") REFERENCES "posts"("id");

Create index for performance (MySQL)

CREATE INDEX `idx_orders_user_id`
  ON `orders`(`user_id`);

Railway diff vs other tools

SchemaLens runs in your browser and works with any Railway database — no CLI setup required.

✅ SchemaLens

Browser-based — zero install
Works with any pg_dump or SQL export
Visual diff with color highlighting
Auto-detects PostgreSQL vs MySQL
Shareable diff URLs
Export to SQL, Markdown, PDF, Prisma, Drizzle

❌ Railway CLI / psql

Requires CLI installation and connection string
Requires local database tools
Text-only output
No visual comparison
No shareable links
SQL output only

Related guides

PostgreSQL