메뉴
Analyze SQL queries — suggest indexes, detect N+1 patterns, explain execution plans.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Sends messages between agents, broadcasts to channels, and retrieves message history for inter-agent communication.
Spawns, manages lifecycle, and terminates autonomous AI agents from the 40+ built-in agent catalog.
Optimize prompts and context windows to reduce token usage while preserving quality.
Animated desktop character state machine for Sven's Tauri companion app. Manages character form (ORB, ARIA, REX, ORION), state transitions (idle→thinking→speaking→celebrating), walk cycles, thought bubbles, sound effects, and real-time agent event sync.
Multi-model deliberation system. Sends queries to multiple LLMs simultaneously, has them peer-review each other's responses anonymously, then a chairman model synthesizes the best answer. Supports configurable council composition, voting strategies, and cost tracking.
Interactive educational autograd engine — port of Karpathy's micrograd. Build, train, and visualise tiny neural networks step-by-step to learn how backpropagation works.
| name | db-query-optimizer |
| description | Analyze SQL queries — suggest indexes, detect N+1 patterns, explain execution plans. |
| version | 0.1.0 |
| publisher | acmecorp |
| handler_language | typescript |
| handler_file | handler.ts |
| when-to-use | Use when the user wants to optimize SQL queries, analyze database performance, or get index suggestions. |
| inputs_schema | {"type":"object","properties":{"action":{"type":"string","enum":["analyze","suggest_indexes","detect_antipatterns","explain_plan"]},"query":{"type":"string"},"schema":{"type":"string"},"dialect":{"type":"string","enum":["postgresql","mysql","sqlite"]}},"required":["action","query"]} |
| outputs_schema | {"type":"object","properties":{"result":{"type":"object"}}} |
Analyzes SQL queries for performance issues — suggests indexes, detects anti-patterns (N+1, SELECT *, missing WHERE), and provides execution plan guidance.
