菜单
Analyze SQL queries — suggest indexes, detect N+1 patterns, explain execution plans.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
| 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.
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.
