See which tables, indexes, views, and functions differ between environments. Select your changes, review dependency-ordered SQL, and apply with transaction-aware execution phases.
$10.95 monthly or $99 yearly One developer, up to two devices
PostgreSQL / inspect a difference before applying it.
From ad-hoc hotfixes to coordinated environment migrations, dbmigrate inspects live PostgreSQL catalogs without guessing.
PostgreSQL supports transactional schema updates. dbmigrate groups statements into atomic phases. If a constraint or type alteration fails, the entire transaction rolls back automatically, leaving zero partial drift behind.
dbmigrateBEGIN;COMMIT; -- Rolls back entirely if any statement failsCherry-pick exact tables, columns, indexes, enum types, sequences, views, triggers, and functions. dbmigrate automatically determines creation and alteration order based on foreign key and view dependencies.
order_status_typeapp.customersapp.orders (FK → customers)Refresh development or staging databases with realistic production slices. Apply a WHERE filter (e.g., specific tenant or date range) and dbmigrate copies referenced parent and dependent child rows in valid foreign-key sequence.
SELECT * FROM app.orders WHERE created_at >= '2026-01-01';Protect customer identities when refreshing lower environments. Apply deterministic masking to email addresses, names, and phone numbers in workstation memory before writing to target tables, preserving relationship joins across tables.
Simulate schema divergences in real time. Add or modify columns, switch database engines, and inspect the verified, dependency-ordered DDL synchronization script.
| Column | Data Type | Status | |
|---|---|---|---|
idPK | bigint | ||
customer_idFK | bigint | ||
created_at | timestamp with time zone | ||
status | varchar(32) | ||
metadata | jsonb |
-- dbmigrate generated PostgreSQL synchronization plan
-- Protection tier: Safe Transactional DDL
BEGIN;
ALTER TABLE app.orders
ADD COLUMN status varchar(32) DEFAULT 'pending' NOT NULL;
ALTER TABLE app.orders
ADD COLUMN metadata jsonb;
-- Create index on added column
CREATE INDEX idx_app_orders_status
ON app.orders (status);
COMMIT;
-- End of PostgreSQL transactional execution phasedbmigrate supports PostgreSQL versions 13, 14, 15, 16, and 17. This includes self-hosted PostgreSQL installations on Linux, Docker, or bare metal, as well as managed cloud instances including AWS RDS, Amazon Aurora PostgreSQL, Supabase, Neon, Google Cloud SQL, and Azure Database for PostgreSQL.
PostgreSQL supports transactional Data Definition Language (DDL). dbmigrate organizes migration operations into transactional phases wrapped in BEGIN and COMMIT blocks. If any statement or constraint fails during execution, PostgreSQL automatically rolls back the entire phase to prevent partial schema drift. Operations requiring non-transactional execution (such as CREATE INDEX CONCURRENTLY) are staged and reviewed in dedicated execution phases.
Yes. dbmigrate analyzes foreign key relationships between tables. When you copy rows filtered by a WHERE clause (e.g., WHERE created_at >= NOW() - INTERVAL '30 days'), it automatically identifies and copies referenced parent rows and dependent child rows in correct dependency order, avoiding foreign key constraint violations.
When copying sensitive data from a production or pre-production database to lower environments like Dev or Sandbox, dbmigrate transforms values in local workstation memory before sending them over the wire. Masking rules support deterministic email and name generation, salted hashes, and custom regex replacements without transmitting data to any cloud AI service.
Experience side-by-side PostgreSQL schema comparison and referential data copying with a 14-day free trial.
macOS (Apple Silicon & Intel) / Windows x64