moai-lang-sql

name	moai-lang-sql
version	2.0.0
created	2025-10-22T00:00:00.000Z
updated	2025-10-22T00:00:00.000Z
status	stable
description	SQL best practices with pgTAP, sqlfluff 3.2, query optimization, and migration management.
keywords	["sql","postgresql","mysql","sqlfluff","migrations"]
allowed-tools	["Read","Bash"]

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