Migration Dialect:

⬅️ Source Schema (v1 / Current)

Parsed: 3 tables, 10 columns

➡️ Target Schema (v2 / Desired)

Parsed: 3 tables, 17 columns

🔍 Visual Schema Changes & Diffs

+1 Added Tables~2 Modified Tables-1 Dropped Tables
➕ CREATE TABLE paymentsNew Table
Columns: payment_id (BIGINT), order_id (BIGINT), payment_method (VARCHAR(50)), amount (DECIMAL(14,2)), paid_at (TIMESTAMP)
⚙️ ALTER TABLE users+2 added, ~0 altered, -0 dropped
➕ Add Column: phone_number VARCHAR(32)
➕ Add Column: tier VARCHAR(50)
⚙️ ALTER TABLE orders+2 added, ~1 altered, -0 dropped
➕ Add Column: tax_amount DECIMAL(10,2)
➕ Add Column: order_status VARCHAR(32)
🔄 Alter Column: total_amount (Old: DECIMAL(10,2) ➜ New: DECIMAL(14,2))
🗑️ DROP TABLE obsolete_logsObsolete Table

🚀 Generated Migration Script (POSTGRES)

-- ==========================================================
-- Automated Schema Migration Script
-- Target Engine: POSTGRES
-- Generated by InsightfulSaga Schema Comparator
-- Timestamp: 2026-11-12T16:10:33.973Z
-- ==========================================================

-- ----------------------------------------------------------
-- Section 1: CREATE NEW TABLES
-- ----------------------------------------------------------
-- ============================================================================
-- INSIGHTFUL SAGA SCHEMA EXPORT — POSTGRES DDL
-- Generated: 2026-11-12T16:10:33.973Z
-- ============================================================================

CREATE TABLE IF NOT EXISTS payments (
  payment_id           BIGINT NOT NULL,
  order_id             BIGINT NOT NULL,
  payment_method       VARCHAR(50),
  amount               DECIMAL(14,2),
  paid_at              TIMESTAMP,
  CONSTRAINT pk_payments PRIMARY KEY (payment_id)
);


-- ----------------------------------------------------------
-- Section 2: ALTER EXISTING TABLES
-- ----------------------------------------------------------
-- Table: users
ALTER TABLE users ADD COLUMN phone_number VARCHAR(32);
ALTER TABLE users ADD COLUMN tier VARCHAR(50);

-- Table: orders
ALTER TABLE orders ADD COLUMN tax_amount DECIMAL(10,2);
ALTER TABLE orders ADD COLUMN order_status VARCHAR(32);
ALTER TABLE orders ALTER COLUMN total_amount TYPE DECIMAL(14,2);

-- ----------------------------------------------------------
-- Section 3: DROP OBSOLETE TABLES
-- CAUTION: Execute with care to avoid accidental data loss
-- ----------------------------------------------------------
DROP TABLE IF EXISTS obsolete_logs;