query-optimizer

Review SQL queries, execution plans, and schema usage to propose safer alternatives.

1|Updated Mar 16, 2026

Search Tags:#sql #indexes #query-optimization #code-review #execution-plan #database-performance #schema-usage

Ready to run

npx skills add https://github.com/00PrabalK00/claude-skills --skill query-optimizer-00prabalk00

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: query-optimizer
Source: https://github.com/00PrabalK00/claude-skills/tree/main/skills/query-optimizer
Command: npx skills add https://github.com/00PrabalK00/claude-skills --skill query-optimizer-00prabalk00

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Review SQL queries, execution plans, schema usage, and indexes to propose safer faster alternatives.

Core Features & Use Cases

Inspect diffs, configs, source files, or artifacts before forming a conclusion.
Compare current query patterns against conventions, expected guarantees, and known risk areas to highlight hotspots.
Prioritize high-impact gaps and provide validation steps to reduce risk.

Quick Start

Analyze the provided slow SQL query, its execution plan, and related schema context to return a concrete, high-leverage optimization plan.

Frequently Asked Questions about query-optimizer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I optimize slow SQL queries causing high database latency?▼

To optimize slow SQL queries causing high database latency, review the query text alongside its execution plan and schema usage to propose safer, faster alternatives. Analyzing execution plans exposes index gaps and schema inefficiencies to reduce overall database load.

What is an SQL execution plan and how does it help query optimization?▼

An SQL execution plan is a detailed roadmap of how a database executes a query. Reviewing execution plans helps query optimization by revealing table scan hotspots, missing indexes, and inefficient schema usage that cause high latency in data-intensive applications.

How do I review indexes and schema usage to fix slow database queries?▼

To review indexes and schema usage to fix slow database queries, compare current query patterns against repository conventions and known risk areas. Prioritizing high-impact gaps in index design and providing validation steps reduces risk and improves performance.

Can I use automated query optimization for data-intensive applications in production?▼

You can use query optimization for data-intensive applications across development, staging, and production contexts. It requires access to query text, execution plans, relevant schema details, and alignment with repository conventions and tests to validate changes safely.

What is the best way to triage slow SQL queries without breaking existing code?▼

The best way to triage slow SQL queries without breaking existing code is to inspect source file diffs and configurations before forming a conclusion. Comparing query patterns against expected guarantees and validating changes reduces the risk of regressions.