Menu
Analyze SQL queries — suggest indexes, detect N+1 patterns, explain execution plans.
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
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.
