moai-lang-sql

SQL best practices enforcement uses sqlfluff to lint code against configurable rules, combined with schema design and migration guidance. This catches style violations, security issues, and anti-patterns early in development, reducing technical debt in your data layer.

pgTAP provides a test-driven development framework for PostgreSQL that validates migrations, schema changes, and query logic before deployment. Combined with sqlfluff linting, it ensures migrations are safe, reversible, and comply with your organization's SQL standards.

Yes. This Skill integrates pgTAP and sqlfluff to automate quality gates in your review process, executing tests and lint checks on pull requests and enforcing TRUST 5 compliance standards for PostgreSQL codebases.

Migration management guidance covers evolving databases reliably through version-aligned tooling, test execution planning, and quality gates. This prevents breaking changes and ensures schema evolution stays synchronized with application code.

You need a PostgreSQL codebase, pgTAP for test writing, and sqlfluff for linting configured in your project. The Skill provides tool-version alignment and integration patterns to set up these dependencies within moai foundation components.