mig2schema

Extracts database schema from PostgreSQL migration files by running them in temporary containers and outputting human-readable schema information or SQL DDL, enabling developers to understand final database structure without manually tracking changes across multiple migration files.

This MCP server extracts database schema from PostgreSQL migration files by spinning up temporary PostgreSQL containers using testcontainers, running the migrations, and then extracting the resulting schema information. Built in Go with support for multiple extraction providers including native SQL queries and pg_dump, it offers both human-readable schema information and SQL DDL output formats, making it useful for developers working with large migration directories who need to understand the final database structure without manually tracking changes across multiple migration files. The implementation supports various migration file naming conventions and provides validation capabilities, serving teams that need to document database schemas, analyze migration outcomes, or integrate schema extraction into CI/CD workflows.