Skills query-optimizer
📦

query-optimizer

Content revision r1 Safe ⚙️ External commands

Optimize SQL Query Performance

Slow database queries can increase costs and make applications feel unreliable. This skill helps Claude, Codex, and Claude Code review queries, execution plans, and index choices.

Supports: Claude Codex Code(CC)
🥉 77 Bronze

This skill is part of a pack

Install the whole pack to get every skill the task needs, in one command.

Postgres Schema Toolkit · 3 skills Install whole pack

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request
Review the Skillstore skill "query-optimizer" from https://skillstore.io/skills/curiouslearner-query-optimizer.md and its manifest at https://skillstore.io/api/skills/curiouslearner-query-optimizer/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

Your Agent should still show its plan and request any confirmation required by the security policy.

Agent-readable resources

Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.

Markdown detail GET /skills/curiouslearner-query-optimizer.md Signed manifest GET /api/skills/curiouslearner-query-optimizer/manifest Signed lockfile GET /api/skills/curiouslearner-query-optimizer/lockfile

Test it

Using "query-optimizer". A user shares a slow customer lookup query plus table size, current indexes, and an execution plan.

Expected outcome:

The skill identifies a full table scan, recommends a targeted email index, explains why selectivity matters, and lists verification steps.

Using "query-optimizer". A developer describes loading users and then loading orders inside a loop.

Expected outcome:

The skill flags an N+1 pattern, recommends eager loading or a join-based aggregate, and explains how query count changes.

Using "query-optimizer". A team provides a list of slow reporting queries and current index definitions.

Expected outcome:

The skill groups issues by missing indexes, excessive selected columns, pagination cost, and monitoring gaps.

Security Audit

Safe
v8 • 7/6/2026 Open versioned report

All 142 static findings appear to be false positives caused by Markdown code fences, JavaScript template literals, and SQL example text in SKILL.md. I found no executable helper scripts, shell execution path, network access, credential access, or prompt injection attempt in the reviewed skill content.

1
Files scanned
792
Lines analyzed
0
Review items
0
False positives ignored

Risk Factors

⚙️ External commands (95)
SKILL.md:46-52 SKILL.md:52-57 SKILL.md:57-79 SKILL.md:79-82 SKILL.md:82-90 SKILL.md:90-92 SKILL.md:92-99 SKILL.md:99-102 SKILL.md:102-120 SKILL.md:120-123 SKILL.md:123-141 SKILL.md:141-148 SKILL.md:148-155 SKILL.md:155-158 SKILL.md:158-167 SKILL.md:167-172 SKILL.md:172-180 SKILL.md:180-185 SKILL.md:185-188 SKILL.md:188-198 SKILL.md:198-202 SKILL.md:202-205 SKILL.md:205-220 SKILL.md:220-225 SKILL.md:225-232 SKILL.md:232-235 SKILL.md:235-246 SKILL.md:246-251 SKILL.md:251-262 SKILL.md:262-265 SKILL.md:265-283 SKILL.md:283-288 SKILL.md:288-294 SKILL.md:294-297 SKILL.md:297-307 SKILL.md:307-310 SKILL.md:310-317 SKILL.md:317-320 SKILL.md:320-327 SKILL.md:327-332 SKILL.md:332-349 SKILL.md:349-352 SKILL.md:352-361 SKILL.md:361-366 SKILL.md:366-372 SKILL.md:372-375 SKILL.md:375-383 SKILL.md:383-388 SKILL.md:388-396 SKILL.md:396-399 SKILL.md:399-413 SKILL.md:413-431 SKILL.md:431-438 SKILL.md:438-441 SKILL.md:441-455 SKILL.md:455-458 SKILL.md:458-465 SKILL.md:465-468 SKILL.md:468-481 SKILL.md:481-484 SKILL.md:484-493 SKILL.md:493-498 SKILL.md:498-507 SKILL.md:507-510 SKILL.md:510-519 SKILL.md:519-524 SKILL.md:524-537 SKILL.md:537-540 SKILL.md:540-548 SKILL.md:548-551 SKILL.md:551-558 SKILL.md:558-565 SKILL.md:565-575 SKILL.md:575-578 SKILL.md:578-591 SKILL.md:591-596 SKILL.md:596-604 SKILL.md:604-607 SKILL.md:607-616 SKILL.md:616-621 SKILL.md:621-630 SKILL.md:630-633 SKILL.md:633-641 SKILL.md:641-646 SKILL.md:646-652 SKILL.md:652-655 SKILL.md:655-667 SKILL.md:667-673 SKILL.md:673-699 SKILL.md:699-703 SKILL.md:703-715 SKILL.md:715-719 SKILL.md:719-732 SKILL.md:732-762 SKILL.md:762-780
No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.
Audited by: codex View Audit History →
Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report
Security Assessment

Copy report link

https://skillstore.io/skills/curiouslearner-query-optimizer/audits/8?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/curiouslearner-query-optimizer/security.svg)](https://skillstore.io/skills/curiouslearner-query-optimizer?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/curiouslearner-query-optimizer?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/curiouslearner-query-optimizer/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/curiouslearner-query-optimizer.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>
Academic citations (APA · BibTeX · CFF)

APA citation

CuriousLearner. (2026). query-optimizer security audit report (audit version 8) [Author version unspecified]. Skillstore. https://skillstore.io/skills/curiouslearner-query-optimizer/audits/8

BibTeX citation

@techreport{curiouslearner-curiouslearner-query-optimizer-2026, author = {CuriousLearner}, title = {query-optimizer security audit report (audit version 8)}, institution = {Skillstore}, year = {2026}, number = {8}, url = {https://skillstore.io/skills/curiouslearner-query-optimizer/audits/8}, note = {Author version unspecified} }

CITATION.cff

cff-version: 1.2.0 message: "If you use this Skill, cite its author and this versioned security audit report." title: "query-optimizer security audit report (audit version 8)" version: "unspecified" type: report authors: - name: "CuriousLearner" date-released: "2026-07-06" url: "https://skillstore.io/skills/curiouslearner-query-optimizer/audits/8" identifiers: - type: other value: "skillstore:curiouslearner-query-optimizer:audit:8" description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: High
55
Architecture
85
Maintainability
87
Content
72
Community
74
Spec Compliance

What You Can Build

Tune a Slow Endpoint

Review a query behind a slow API route and get practical indexing or rewrite ideas.

Review Database Indexes

Compare current indexes with common query patterns and find missing, duplicate, or unused indexes.

Improve Analytics Queries

Analyze reporting queries, joins, filters, and aggregation patterns before they reach production workloads.

Try These Prompts

Review One Query 
Review this SQL query for performance. Explain likely bottlenecks, needed indexes, and safer rewrite options. Query: [paste query]. Schema and row counts: [paste details].
Explain an Execution Plan 
Analyze this execution plan and explain the most expensive operations in plain language. Then suggest changes to test first. Plan: [paste EXPLAIN output].
Find ORM Query Problems 
Check this ORM data access pattern for N+1 queries, unnecessary fields, and inefficient joins. Suggest an improved loading strategy. Context: [paste code or description].
Build a Tuning Plan 
Create a prioritized optimization plan for these slow queries. Include expected impact, index tradeoffs, verification steps, and rollback considerations. Inputs: [queries, plans, schema, workload notes].

Best Practices

  • Provide schema, row counts, current indexes, and execution plans with every query review.
  • Test each suggested change on production-like data before changing production systems.
  • Measure before and after optimization so improvements are tied to evidence.

Avoid

  • Do not add every suggested index without checking write cost and storage impact.
  • Do not optimize from query text alone when an execution plan is available.
  • Do not apply database-specific syntax without confirming the target database version.

Frequently Asked Questions

Which databases does this skill cover?
It covers common SQL tuning patterns for PostgreSQL, MySQL, MariaDB, SQL Server, and SQLite.
Can it run queries for me?
The skill provides analysis guidance. Query execution depends on the tools and database access available in your environment.
What information should I provide?
Share the query, schema, row counts, indexes, database version, and EXPLAIN output when possible.
Will every recommendation make queries faster?
No. Performance depends on data distribution, workload, indexes, and database settings. Always test changes.
Does it help with ORM performance?
Yes. It includes guidance for N+1 query patterns, eager loading, and selecting only needed fields.
Can it review index maintenance?
Yes. It includes guidance for unused indexes, duplicate indexes, and rebuilding or analyzing indexes.

Developer Details

License

MIT

Skillstore revision

r1

Version notice

The author did not declare a version.

Repository

https://github.com/CuriousLearner/devkit/tree/main/skills/query-optimizer

Ref

d11af420e07cd866fe39cfa937efef3223896c06

Maintenance freshness

7/18/2026

Usage

7 downloads · 303 views

File structure

📄 SKILL.md

More from CuriousLearner

View all

Related Skills

View all