moai-lang-sql
SQL best practices with pgTAP, sqlfluff 3.2, query optimization, and migration management.
Packaged view
This page reorganizes the original catalog entry around fit, installability, and workflow context first. The original raw source lives below.
Install command
npx @skill-hub/cli install ajbcoding-claude-skill-eval-moai-lang-sql
Repository
Skill path: skills/moai-lang-sql
SQL best practices with pgTAP, sqlfluff 3.2, query optimization, and migration management.
Open repositoryBest for
Primary workflow: Ship Full Stack.
Technical facets: Full Stack, Backend, Testing.
Target audience: everyone.
License: Unknown.
Original source
Catalog source: SkillHub Club.
Repository owner: AJBcoding.
This is still a mirrored public skill entry. Review the repository before installing into production workflows.
What it helps with
- Install moai-lang-sql into Claude Code, Codex CLI, Gemini CLI, or OpenCode workflows
- Review https://github.com/AJBcoding/claude-skill-eval before adding moai-lang-sql to shared team environments
- Use moai-lang-sql for development workflows
Works across
Favorites: 0.
Sub-skills: 0.
Aggregator: No.
Original source / Raw SKILL.md
--- name: "moai-lang-sql" version: "2.0.0" created: 2025-10-22 updated: 2025-10-22 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