SchemaLens in Your CI/CD Pipeline
Add automated schema diffing to your CI/CD pipeline. Catch dangerous database changes in pull requests before they reach production.
Weekly updates on database migrations, schema design best practices, and the journey of building SchemaLens.
Add automated schema diffing to your CI/CD pipeline. Catch dangerous database changes in pull requests before they reach production.
Practical SQL formatting rules with before/after examples. Make your database code readable in pull requests and catch mistakes faster.
Stop writing ALTER TABLE by hand. Learn how to automatically generate migration SQL from schema diffs for PostgreSQL, MySQL, SQL Server, and SQLite.
Dropped columns, missing indexes, type truncation — the schema changes that cause the most production incidents and how to prevent them.
Manual migration scripts cost more than developer time. They cost sleep, trust, and velocity. Here's the real price—and how to fix it.
A step-by-step guide to catching schema drift between staging and production. Why semantic diffs beat text diffs every time.
The subtle differences in ALTER TABLE syntax that break migrations when switching dialects. A reference for multi-database teams.
SQL Server ALTER TABLE syntax, IDENTITY columns, bracket quoting, named constraints, and how to diff MSSQL schemas safely.
How we turned a Node.js SQL parser into a client-side engine for schema diff. No backend required.
A comprehensive checklist for reviewing database migrations. Catch dangerous changes before they break production.