SkillHub ClubShip Full StackFull Stack

moai-lang-sql

Imported from https://github.com/kivo360/quickhooks.

Packaged view

This page reorganizes the original catalog entry around fit, installability, and workflow context first. The original raw source lives below.

Stars

Hot score

Updated

March 19, 2026

Overall rating

C2.4

Composite score

2.4

Best-practice grade

B77.2

Install command

npx @skill-hub/cli install kivo360-quickhooks-moai-lang-sql

Repository

kivo360/quickhooks

Skill path: .claude/skills/moai-lang-sql

Imported from https://github.com/kivo360/quickhooks.

Open repository

Best for

Primary workflow: Ship Full Stack.

Technical facets: Full Stack.

Target audience: everyone.

License: Unknown.

Original source

Catalog source: SkillHub Club.

Repository owner: kivo360.

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/kivo360/quickhooks before adding moai-lang-sql to shared team environments
Use moai-lang-sql for development workflows

Works across

Claude CodeCodex CLIGemini CLIOpenCode

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: active
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