Analyzes SQL migrations against Mattermost best practices to ensure safe, zero-downtime database updates.
The review-migration skill automates the rigorous review process for Mattermost database migrations by validating schema changes against official engineering standards. It fetches the authoritative Mattermost DB Migration Guide to analyze .up.sql and .down.sql files for common pitfalls such as missing CONCURRENTLY keywords, improper lock types, or transactional mismatches. By generating a detailed markdown report, it helps developers identify potential production risks, ensure backward compatibility with previous Extended Support Releases (ESR), and maintain high availability during deployments.
Características Principales
01Backward compatibility verification for zero-downtime upgrades
02Real-time validation against official Mattermost DB Migration Guide rules
03Automated detection of new or modified migrations via Git diff
041 GitHub stars
05Structured markdown report generation with testing recommendations
06Analysis of table locks and impact on concurrent operations
Casos de Uso
01Determining if large-dataset testing is required for specific schema changes
02Auditing existing migrations for compliance with non-transactional best practices
03Validating new SQL migrations before submitting a Pull Request to Mattermost
