Lang Sql Skill
Skill Metadata
| Field |
Value |
| Skill Name |
moai-lang-sql |
| Version |
2.0.0 (2025-10-22) |
| Allowed tools |
Read (read_file), Bash (terminal) |
| Auto-load |
On demand when keywords detected |
| Tier |
Language |
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)
| Tool |
Version |
Purpose |
Status |
| PostgreSQL |
17.2 |
Primary |
✅ Current |
| MySQL |
9.1.0 |
Primary |
✅ Current |
| sqlfluff |
3.2.5 |
Primary |
✅ Current |
| pgTAP |
1.3.3 |
Primary |
✅ Current |
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
