Skills
.Work. You
Rest

moai-lang-sql

Community

Master SQL with TDD, optimized queries, and smooth migrations.

Authorjunseokandylee
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill provides expert guidance for developing robust and high-performance SQL databases. It addresses challenges in SQL testing, query optimization, and migration management, helping you build reliable data layers that are efficient, maintainable, and easy to evolve, saving you from common database development errors.

Core Features & Use Cases

  • Testing Strategies: Guides through using pgTAP (PostgreSQL), DbUnit (JVM), and SQLTest for comprehensive SQL unit and integration testing.
  • Query Optimization: Provides expertise in EXPLAIN/EXPLAIN ANALYZE, index optimization, and query rewriting to boost database performance.
  • Migration Management: Supports tools like Flyway, Liquibase, and Alembic for version-based and changelog-based database migrations.
  • Use Case: When you need to "SQL 테스트 작성" (write SQL tests) or "쿼리 최적화" (query optimization) for a new schema, this skill offers the necessary guidance.

Quick Start

Ask to "SQL 테스트 작성" for a new schema, and the skill will guide you through TDD with pgTAP.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: moai-lang-sql
Download link: https://github.com/junseokandylee/CookieProxy/archive/main.zip#moai-lang-sql

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.