Firebase Data Connect Schema Diff.
Generate migrations.
Zero setup.

Paste two schema exports from your Firebase Data Connect PostgreSQL instances. 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 Firebase workflows

SchemaLens understands PostgreSQL-specific syntax that generic diff tools miss — perfect for Firebase Data Connect's Cloud SQL PostgreSQL backend.

🔥

Firebase Data Connect Ready

Diff schemas from Firebase Data Connect's Cloud SQL PostgreSQL instances. Works with pg_dump exports and Data Connect schema definition files.

⚡

Environment-to-Environment

Compare schemas between Firebase production and staging projects. Export from each project's Cloud SQL instance to validate Data Connect schema changes.

📦

GraphQL Schema Sync

Validate that your PostgreSQL schema changes align with your Firebase Data Connect GraphQL schema. Catch mismatched columns and types before deployment.

🔑

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. Useful for Firebase projects using PostgreSQL functions for computed fields and validation.

🔒

Privacy First

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

How it works

Export your Firebase schemas

Run pg_dump --schema-only against your Firebase Data Connect Cloud SQL instance, or export schema from the Firebase Console.

Paste into SchemaLens

Copy the SQL into the two editor panes. Dialect is automatically set to PostgreSQL (Firebase Data Connect's engine).

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 Firebase Data Connect deploy or your migration tool.

Firebase migration examples

SchemaLens generates production-ready ALTER TABLE scripts for every change it detects in your Firebase Data Connect project.

Column type change

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

Add a new column

ALTER TABLE "orders"
  ADD COLUMN "shipped_at" TIMESTAMP;

Add a foreign key

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

Create index for performance

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

Firebase diff vs other tools

SchemaLens runs in your browser and works with any Firebase Data Connect project — no gcloud CLI setup required.

✅ SchemaLens

Browser-based — zero install
Works with any pg_dump or SQL export
Visual diff with color highlighting
Project-to-project comparison support
Shareable diff URLs
Export to SQL, Markdown, PDF, Prisma, Drizzle

❌ gcloud CLI / psql

Requires gcloud CLI installation and auth
Requires Cloud SQL proxy or public IP
Text-only output
No visual project comparison
No shareable links
SQL output only

Related guides

PostgreSQL