Lang Sql Skill

Skill Metadata

What It Does

SQL best practices with pgTAP, sqlfluff 3.2, query optimization, and migration management.

Key capabilities:

• ✅ Best practices enforcement for language domain
• ✅ TRUST 5 principles integration
• ✅ Latest tool versions (2025-10-22)
• ✅ TDD workflow support

When to Use

Automatic triggers:

• Related code discussions and file patterns
• SPEC implementation (/alfred:2-run)
• Code review requests

Manual invocation:

• Review code for TRUST 5 compliance
• Design new features
• Troubleshoot issues

Tool Version Matrix (2025-10-22)

Inputs

• Language-specific source directories
• Configuration files
• Test suites and sample data

Outputs

• Test/lint execution plan
• TRUST 5 review checkpoints
• Migration guidance

Failure Modes

• When required tools are not installed
• When dependencies are missing
• When test coverage falls below 85%

Dependencies

• Access to project files via Read/Bash tools
• Integration with moai-foundation-langs for language detection
• Integration with moai-foundation-trust for quality gates

References (Latest Documentation)

Documentation links updated 2025-10-22

Changelog

• v2.0.0 (2025-10-22): Major update with latest tool versions, comprehensive best practices, TRUST 5 integration
• v1.0.0 (2025-03-29): Initial Skill release

Works Well With

• moai-foundation-trust (quality gates)
• moai-alfred-code-reviewer (code review)
• moai-essentials-debug (debugging support)

Best Practices

✅ DO:

• Follow language best practices
• Use latest stable tool versions
• Maintain test coverage ≥85%
• Document all public APIs

❌ DON'T:

• Skip quality gates
• Use deprecated tools
• Ignore security warnings
• Mix testing frameworks