SQL best practices with pgTAP, sqlfluff 3.2, query optimization, and
| 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 |
SQL best practices with pgTAP, sqlfluff 3.2, query optimization, and migration management.
Key capabilities:
Automatic triggers:
/alfred:2-run)Manual invocation:
| 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 |
moai-foundation-langs for language detectionmoai-foundation-trust for quality gatesDocumentation links updated 2025-10-22
moai-foundation-trust (quality gates)moai-core-code-reviewer (code review)moai-essentials-debug (debugging support)✅ DO:
❌ DON'T: