v1.0.0Open Source Release

Know Before You Migrate.

The open-source database migration analyzer. Catch breaking changes, predict lock times, and deploy with confidence.

$go install github.com/iamsr/tapa/cmd/tapa@latest

See How It Works

One command. Complete analysis. Zero surprises.

tapa-cliv1.0.0
$ tapa analyze migration.sql
Connecting to database...
✓ Connected to production (PostgreSQL 15.2)
Parsing migration file...
Found 1 statement: ALTER TABLE users ADD COLUMN phone VARCHAR(20);
╭─────────────────────────────────────────────────────────╮
│ ANALYSIS RESULTS │
╰─────────────────────────────────────────────────────────╯
Risk Score
████████░░░░░░░░░░░░░░░░░░░░ 15/100
Status: LOW RISK ✓
Lock Analysis
├── Type ACCESS EXCLUSIVE (metadata only)
├── Duration < 10ms
└── Queries 0 affected
Time Estimate
├── Execution < 1 second
└── Table Size 2.4M rows (no rewrite needed)
Compatibility Check
✓ Backward compatible
✓ No breaking changes
✓ Rolling deployment safe
╭─────────────────────────────────────────────────────────╮
│ ✨ SAFE TO DEPLOY │
│ This migration can run without downtime. │
╰─────────────────────────────────────────────────────────╯

Powerful Capabilities

Everything you need to analyze, predict, and safely deploy database schema changes without fear.

Critical

Lock Analysis

Instantly detect ACCESS EXCLUSIVE locks that would block all reads and writes. Know exactly which tables will be locked, for how long, and how many active queries will be affected. Prevent surprise outages during deployments.

Risk Scoring

Every migration gets a 0-100 risk score based on table size, lock type, backward compatibility, and estimated execution time. High-risk migrations are flagged immediately.

Time Estimates

Predicts exactly how long your migration will take. Accounts for table size, indexes, active connections, and your specific hardware. No more "5 second" migrations taking 5 hours.

Popular

CI/CD Integration

Automatically block dangerous migrations in pull requests. Integrates with GitHub Actions, GitLab CI, CircleCI, and all major CI platforms. Get detailed reports as PR comments.

Backward Compatibility

Ensures your running application code still works with the new schema. Critical for zero-downtime deployments and rolling updates. Catches breaking changes before they break production.

Multi-Database

Works with PostgreSQL, MySQL, MariaDB, and more. One unified tool for all your databases. Same analysis, same reports, same safety.