Menu
Database design, schema optimization, indexing strategies, and migration management.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
19-agent team structure, decision trees for agent selection, Haiku vs Sonnet model selection, and agent collaboration principles. Use when deciding which sub-agent to invoke, understanding team responsibilities, or learning multi-agent orchestration.
Guide Alfred sub-agents to actively invoke AskUserQuestion for ambiguous decisions.
Master-Clone pattern implementation guide for complex multi-step tasks with full project context
Systematic code review guidance and automation. Apply TRUST 5 principles, check code quality, validate SOLID principles, identify security issues, and ensure maintainability. Use when conducting code reviews, setting review standards, or implementing review automation.
.moai/config.json official schema documentation, structure validation, project metadata, language settings, and configuration migration guide. Use when setting up project configuration or understanding config.json structure.
Claude Code context window optimization strategies, JIT retrieval, progressive loading, memory file patterns, and cleanup practices. Use when optimizing context usage, managing large projects, or implementing efficient workflows.
| name | moai-domain-database |
| version | 2.0.0 |
| created | "2025-10-22T00:00:00.000Z" |
| updated | "2025-10-22T00:00:00.000Z" |
| status | active |
| description | Database design, schema optimization, indexing strategies, and migration management. |
| keywords | ["database","sql","nosql","migrations","indexing"] |
| allowed-tools | ["Read","Bash"] |
| Field | Value |
|---|---|
| Skill Name | moai-domain-database |
| Version | 2.0.0 (2025-10-22) |
| Allowed tools | Read (read_file), Bash (terminal) |
| Auto-load | On demand when keywords detected |
| Tier | Domain |
Database design, schema optimization, indexing strategies, and migration management.
Key capabilities:
Automatic triggers:
/alfred:2-run)Manual invocation:
| Tool | Version | Purpose | Status |
|---|---|---|---|
| PostgreSQL | 17.2 | Primary | ✅ Current |
| MongoDB | 8.0.0 | Primary | ✅ Current |
| Redis | 7.4.0 | Primary | ✅ Current |
moai-foundation-langs for language detectionmoai-foundation-trust for quality gatesDocumentation links updated 2025-10-22
moai-foundation-trust (quality gates)moai-alfred-code-reviewer (code review)moai-essentials-debug (debugging support)✅ DO:
❌ DON'T: