SQL Diff
Compare two SQL scripts side by side to spot schema and query changes
All processing happens in your browser. No data is sent to any server.
+14 added-6 removed10 unchanged
1 CREATE TABLE users (
2 id SERIAL PRIMARY KEY,
3- username VARCHAR(50) NOT NULL,
4- email VARCHAR(100) NOT NULL UNIQUE,
5- created_at TIMESTAMP DEFAULT NOW()
6+ username VARCHAR(100) NOT NULL,
7+ email VARCHAR(255) NOT NULL UNIQUE,
8+ display_name VARCHAR(200),
9+ avatar_url TEXT,
10+ created_at TIMESTAMP DEFAULT NOW(),
11+ updated_at TIMESTAMP DEFAULT NOW()
12 );
13
14 CREATE TABLE posts (
15 id SERIAL PRIMARY KEY,
16- user_id INTEGER REFERENCES users(id),
17- title VARCHAR(200) NOT NULL,
18+ user_id INTEGER REFERENCES users(id) ON DELETE CASCADE,
19+ title VARCHAR(300) NOT NULL,
20 body TEXT,
21- created_at TIMESTAMP DEFAULT NOW()
22+ status VARCHAR(20) DEFAULT 'draft',
23+ published_at TIMESTAMP,
24+ created_at TIMESTAMP DEFAULT NOW(),
25+ updated_at TIMESTAMP DEFAULT NOW()
26 );
27
28 CREATE INDEX idx_posts_user ON posts(user_id);
29+CREATE INDEX idx_posts_status ON posts(status);
30+CREATE INDEX idx_users_email ON users(email);
Why This Tool
Reviewing database migration scripts or comparing SQL schemas requires seeing exact differences. This tool provides a side-by-side diff of two SQL files with syntax-aware highlighting.
How It Works
Paste your original SQL in the left panel and the modified version in the right. The tool highlights added, removed, and changed lines with clear color coding.