schemaforge-mcp

SchemaForge MCP is a universal database migration server that gives AI coding agents full control over database schema management. Instead of switching between pgAdmin, MySQL Workbench, and SQLite browsers, your AI agent handles everything through one unified interface.

What it does:

• Schema Inspection — View complete database schemas including tables, columns, indexes, foreign keys, and constraints across PostgreSQL, MySQL, and SQLite
• Schema Diffing — Compare two databases side by side and see exactly what changed: added tables, removed columns, modified indexes
• Migration Generation — Generate dialect-aware migration SQL (up + down) from structured change descriptions. Supports raw SQL, Knex, and Sequelize output formats
• Migration Tracking — Built-in migration history with interop detection for Prisma, Knex, Sequelize, and Rails migration tables
• Validation — Dry-run migrations before applying. PostgreSQL gets full transactional dry-run, MySQL and SQLite get syntax validation
• Index Suggestions — Analyzes your schema and queries to recommend missing indexes

Pro features ($29/mo):

• Apply and rollback migrations with automatic schema snapshots
• Detect dead schema — find unused tables and columns by cross-referencing with your codebase
• Generate realistic seed data respecting column types and constraints
• Convert any database schema to Prisma, Drizzle, Knex, or Sequelize model definitions
• Compare schemas across dev/staging/prod environments to detect drift

Why developers choose SchemaForge:

• Framework-agnostic — works with any ORM or raw SQL
• Non-destructive by default — read-only free tier, writes only in Pro
• Your credentials stay local — never stored, never logged
• 248 passing tests — production-grade reliability