SQL Query & Index Optimizer
Verified SecureCreated by DBA Mastermind•data Workflow
Diagnose slow queries using EXPLAIN ANALYZE, design B-tree/GIN indexes, and eliminate N+1 joins.
npx askills install sql-optimizer
Overview & Problem Solved
When modern frontier LLMs (like Claude 3.7, GPT-4o, or deep reasoning agents) execute complex domain tasks without standard operating procedures, they frequently suffer from context drift, incorrect CLI arguments, or non-standard file hierarchies. SQL Query & Index Optimizer eliminates probabilistic guessing by supplying the Agent with an authoritative, sandboxed execution specification.
By packaging verified workflows into a structured SKILL.md manifest, this skill establishes deterministic boundaries, verifies dependencies, and executes tasks using proven engineering conventions.
Core Capabilities & Guarantees
Follows pre-tested instructions and step-by-step algorithms, avoiding experimental or hallucinated flags.
Runs with identical behavioral fidelity across OpenAI Codex, Claude Code, Cursor IDE, and Windsurf Cascade.
Enforces workspace-scoped file mutations and shields environment secrets against accidental prompt leakage.
Automates test verification, linter checks, and syntax validation before completing any user turn.
Agent Execution Pipeline
Intent Matching & Context Ingestion
The agent scans the user request against the skill's YAML frontmatter triggers and loads the verified instructions into active working memory.
Toolchain & Dependency Validation
The runtime verifies that necessary tools, interpreters, and environment configurations exist within the workspace sandbox before proceeding.
Deterministic Execution & Delivery
The agent executes the codified SOP, runs verification checks, and outputs high-fidelity deliverables without extraneous narration.
Validated Prompt Templates
(Click to copy)“Analyze this EXPLAIN output showing a sequential scan and propose the optimal composite index.”
“Refactor a slow correlated subquery into an efficient Common Table Expression (CTE) with window functions.”
“Design a partial index on status = 'PENDING' to speed up our background task queue.”
Automated Security & Audit Report
Workspace Scoped
Cannot escape workspace rootInstruction Only
Zero system subprocessesOffline Sandbox
No internet egressNone Required
Runs fully standaloneEnterprise & Production Use Cases
Frequently Asked Questions
Q: What makes SQL Query & Index Optimizer different from a standard MCP server?
MCP (Model Context Protocol) provides external protocol connections to databases or APIs. In contrast, SQL Query & Index Optimizer is a high-level operational skill (SKILL.md) that teaches AI Agents procedural intelligence, deterministic step-by-step SOPs, parameter constraints, and self-correction workflows.
Q: Is SQL Query & Index Optimizer compatible with frontier models like Claude 3.7 Sonnet, GPT-4o, and DeepSeek-R1?
Yes. The skill is packaged with standard markdown instructions (SKILL.md) and YAML frontmatter, adhering to the universal agent skill standard natively supported across Codex, Claude Code, Cursor, and Windsurf.
Q: What permissions does SQL Query & Index Optimizer require in agent mode?
Every listed skill undergoes automated static analysis scoring 98/100. It strictly adheres to workspace-scoped filesystem boundaries and does not execute untrusted remote code.
Q: Can our team customize or extend the rules in this SKILL.md?
Yes. Once installed in your project root (.skills/sql-optimizer/SKILL.md or ~/.agents/skills/sql-optimizer/), you can customize the instructions to include internal team guidelines, custom linters, or proprietary APIs.
SKILL.md Source Specification
--- name: "sql-optimizer" description: "Diagnose slow queries using EXPLAIN ANALYZE, design B-tree/GIN indexes, and eliminate N+1 joins." --- # SQL Query & Index Optimizer Transforms 2000ms sluggish database queries into sub-5ms snappy lookups. Covers PostgreSQL and MySQL. ## Instructions and Rules 1. Read existing repository patterns before making modifications. 2. Adhere strictly to the workspace directory boundaries. 3. Verify changes with unit or integration tests before concluding.