Topic · Databases

Best query optimization skills for Claude Code, Codex and other agents.

Skills that read query plans and speed up slow database queries.
skills
185
official
21

Query optimization skills, ranked

Ranked by score. Sort bymost stars,trending,newest,recently updated

Query optimization skills, ranked
#SkillRepositoryStarsUsed inTokensAuto-checkLicenceUpdated
1

Gives the agent Postgres rules to consult before writing or changing tables, queries, indexes, RLS policies or migrations, and when diagnosing slow queries.

supabase/agent-skills2.7k24 repos~808Automated safety check: PassMIT5 days ago
2

Apply this skill whenever writing, reviewing, or refactoring Laravel PHP code.

anonaddy/anonaddy4.9k13 repos~1.2kAutomated safety check: PassMITyesterday
3

Benchmarks Django ORM filters in Saleor by generating bulk data, extracting the SQL and running EXPLAIN ANALYZE to check index usage.

saleor/saleor23k—~2.3kAutomated safety check: PassBSD-3-Clauseyesterday
4

Guides safe, measurable MySQL and InnoDB changes across schema design, indexing, query tuning, transactions, locking and replication, with rollout steps.

planetscale/database-skills6983 repos~1.4kAutomated safety check: PassMITyesterday
5

Explain research papers to readers without a specialist background: what the paper studies, what the authors contribute, how the findings follow, and what the evidence does not establish.

lijigang/ljg-skills7.5k—~798Automated safety check: PassMITyesterday
6

Iterate on Vortex vx-bench query performance with benchmark comparisons, engine-specific benchmark flags, RUSTLOG/tracing/metrics/explain output, and Samply profiles.

vortex-data/vortex3.2k—~5.1kAutomated safety check: PassApache-2.0today
7

WordPress performance code review and optimization analysis.

elvismdev/claude-wordpress-skills2341 repo~4.5kAutomated safety check: PassMIT10 mo ago
8

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

hellangleZ/burn-in-cceverywhere-ralph11214 repos~2.5kAutomated safety check: PassNo licence8 mo ago
9

Indexes reference files on Postgres schema design, indexing, partitioning, query patterns, MVCC and VACUUM, and PlanetScale-specific operations.

planetscale/database-skills6983 repos~1.8kAutomated safety check: PassMITyesterday
10

Checklist for reviewing code changes that touch queries, APIs, rendering, caching or algorithms for performance, scalability and resource-usage problems.

ZeroDeng01/sublinkPro1.7k—~1.8kAutomated safety check: PassMIT2 days ago
11

A skill your agent uses when investigating or improving WordPress performance (backend-only agent): profiling and measurement (WP-CLI profile/doctor, Server-Timing, Query Monitor via REST headers)…

gambitph/Stackable3503 repos~1.5kAutomated safety check: PassGPL-3.0today
12

Help with MongoDB query optimization and indexing. An agent skill from mongodb/agent-skills.

mongodb/agent-skills1902 repos~2.6kAutomated safety check: PassApache-2.0yesterday
13

从论文 PDF 文件或论文 PDF URL 生成通俗易懂、图文并茂、带批判性评估的中文 Markdown 解读,并保存到当前项目的 markdown 目录。Use when the user asks to interpret,精读,解读,summarize,explain,analyze, or write an article from an academic paper PDF…

digoal/blog8.6k—~1.5kAutomated safety check: PassGPL-2.09 days ago
14

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.

ynulihao/AgentSkillOS61710 repos~3.3kAutomated safety check: PassNo licence7 mo ago
15

PostgreSQL database documentation - SQL queries, database design, administration, performance tuning, and advanced features. Use when working with…

2025Emma/vibe-coding-cn23k1 repo~19kAutomated safety check: PassMIT9 mo ago
16

ClawMem operational reference for agents at query time — the 3-rule escalation gate, MCP tool routing, the 4 query-optimization levers, pipeline behavior (query vs intentsearch), composite scoring…

yoloshii/ClawMem210—~7.5kAutomated safety check: PassMIT2 days ago
17

Specialized skill for working in the fdb-relational-core SQL processing layer — parser, plan generator, and Cascades planner.

FoundationDB/fdb-record-layer675—~1kAutomated safety check: PassApache-2.0yesterday
18

Query ClickHouse system tables to inspect query logs, monitor cluster health, check replication status, and analyze slow queries.

FrankChen021/datastoria327—~731Automated safety check: PassUnknown2 mo ago
19

Database operations runbook — backup, recovery, performance tuning, troubleshooting.

OpenDCAI/DataMind406—~388Automated safety check: PassApache-2.017 days ago
20

Production patterns for Convex apps and the rules the @convex-dev/eslint-plugin enforces: validators, indexes, idempotent mutations, avoiding OCC conflicts, thin function wrappers, error handling.

waynesutton/builder-skills404—~2.6kAutomated safety check: PassApache-2.09 days ago
21

Guidance on Vitess sharding, VSchema design, query tuning and connection problems for MySQL-compatible databases running on PlanetScale.

planetscale/database-skills6981 repo~1.2kAutomated safety check: PassMITyesterday
22

Reviews WordPress plugin, theme and block code after an agent writes or edits it, catching missing escaping, nonces, capability checks and unprepared queries.

amElnagdy/guard-skills1.3k—~2.4kAutomated safety check: PassMIT3 mo ago
23

Designs and debugs Elixir persistence with Ecto: schemas, changesets, queries, preloads, migrations and multi-tenancy, kept within application contexts.

georgeguimaraes/elixir-agent-tools184—~1.2kAutomated safety check: PassApache-2.017 days ago
24

Query Finelog logs and telemetry for Iris tasks, workers, profiles, training, vLLM, and cross-cluster forwarding.

marin-community/marin3.9k—~1.1kAutomated safety check: PassApache-2.0today
25

Guides scalability and performance work for VeloxDB's Tauri + Rust PostgreSQL backend and React + TanStack frontend.

veloxbase/veloxdb646—~1.7kAutomated safety check: PassMIT7 days ago
26

Generates, optimizes, and validates Cypher 25 queries for Neo4j 2025.x and 2026.x.

neo4j-contrib/neo4j-skills1141 repo~6.1kAutomated safety check: PassMITtoday
27

Domain-first store/port design for any codebase: product-shaped APIs, swappable backends, schema at boundaries, one vocabulary catalog (derive don’t re-author), no infrastructure names on the domain…

TryCaspian/caspian-sdk971—~1.8kAutomated safety check: PassAGPL-3.01 mo ago
28

Delegates dbt and warehouse tasks such as lineage, migrations and cost attribution to the altimate-code CLI agent and relays its answer back.

AltimateAI/data-engineering-skills127—~1.4kAutomated safety check: PassMIT6 days ago
29

Design, refactor and diagnose Paro's staged optimizer, using EXPLAIN COMPILE for planning and EXPLAIN ANALYZE for execution.

zunor/paro105—~957Automated safety check: PassApache-2.012 days ago
30

SQL query engine design and implementation guide. An agent skill from revfactory/claude-code-harness.

revfactory/claude-code-harness120—~474Automated safety check: PassNo licence7 mo ago
31

Analyze Django Silk profiling data to debug slow requests, detect N+1 queries, and optimize database performance.

letsrevel/revel-backend109—~1.2kAutomated safety check: PassMITtoday
32

MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance.

ClickHouse/agent-skills544—~1.2kAutomated safety check: PassApache-2.08 days ago
33

Use QueryPlanSnapshotCli to capture and compare RDF4J query plans, then assess likely performance improvements/regressions from execution verification and semantic plan diffs.

eclipse-rdf4j/rdf4j420—~1.5kAutomated safety check: PassBSD-3-Clausetoday
34

Applies ClawHub's repository-specific Convex rules and routes work to the right managed Convex skill for performance, migrations, retention and deployments.

openclaw/clawhub9.5k—~1.4kAutomated safety check: NotesMITyesterday
35

Covers building read models and materialized views from event streams in CQRS and event-sourced systems, including live, catch-up, persistent and inline projections.

wshobson/agents40k8 repos~565Automated safety check: PassMIT2 days ago
36

WordPress ACF and content modeling review. An agent skill from jorgerosal/wordpress-skills.

jorgerosal/wordpress-skills100—~3.2kAutomated safety check: PassMIT4 mo ago
37

Analyzes BigQuery slot use, query costs and execution bottlenecks from INFORMATION_SCHEMA to diagnose slow queries, slot contention and unpartitioned scans.

google/skills21k—~2.3kAutomated safety check: PassApache-2.0today
38

Load this FIRST whenever working with PyTorch CI data (any pytorch/ org repo), the torchci/HUD codebase, or the PyTorch HUD ClickHouse database.

pytorch/test-infra113—~2.8kAutomated safety check: PassUnknowntoday
39

Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and…

EliasOulkadi/shokunin114—~3.1kAutomated safety check: NotesMIT2 days ago
40

JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.

affaan-m/ECC274k5 repos~1.2kAutomated safety check: PassMIT2 days ago
41

A skill your agent uses when optimizing Apple Mail MCP operations, diagnosing slow queries, adding new filtering logic, or modifying how data is fetched from Mail.app.

s-morgan-jeffries/apple-mail-fast-mcp104—~1.5kAutomated safety check: PassMIT28 days ago
42

Identifies and fixes Rails performance issues including N+1 queries, slow queries, and memory problems.

ThibautBaissac/rails_ai_agents665—~1.2kAutomated safety check: NotesMIT4 mo ago
43

CloudBase PostgreSQL access-pattern and slow-query quality guidance.

TencentCloudBase/CloudBase-AI-Toolkit1.1k1 repo~1.3kAutomated safety check: PassMITyesterday
44

Flags and fixes performance issues in WooCommerce PHP code: missing post cache priming, uncached option lookups in loops, and inefficient SQL query patterns.

woocommerce/woocommerce11k—~395Automated safety check: PassUnknowntoday
45

Database guidance for PostgreSQL, MongoDB, Redis and Oracle plus Neon, Supabase and Firestore: schema design, indexing, query tuning and cloud database choice.

modu-ai/moai-adk1.2k—~2.8kAutomated safety check: PassApache-2.0today
46

PostgreSQL database patterns for query optimization, schema design, indexing, and security.

ThibautBaissac/rails_ai_agents6657 repos~922Automated safety check: PassMIT4 mo ago
47

Audit, diagnose, rewrite, creatively brief, test, and safely prepare updates for Amazon product detail pages using live marketplace and product-type requirements, verified product facts, Brand…

xjli360/sealeap-amazon-skills237—~1.4kAutomated safety check: PassMIT9 days ago
48

This skill should be used whenever the user mentions a "semantic model", "data model", or "dataset", or asks to "build", "model", "design", "optimize", "review", or "audit" one, or to "add a…

data-goblin/power-bi-agentic-development1k—~2.8kAutomated safety check: PassGPL-3.02 days ago

Questions, answered from the data.

What is the best query optimization skill?

Supabase Postgres Best Practices (official) from supabase/agent-skills ranks first of the 185 query optimization skills listed here, with the highest score: its repository has 2.7k GitHub stars, 24 other GitHub owners carry a copy, its SKILL.md loads about 808 tokens and it passes the automated safety check with no findings. Next come Laravel Best Practices and Django Filter Benchmark.

Which query optimization skills are official?

21 of the 185 query optimization skills are official, published by the vendor's own GitHub organization: Supabase Postgres Best Practices, MySQL Schema and Query Tuning, PlanetScale Postgres Playbook, Mongodb Query Optimizer, Vitess for PlanetScale and 16 more.

How are these skills ranked?

By Skill Navigator score, which combines the GitHub stars of the skill's repository (shared across that repo's skills and discounted for large collections), how many other GitHub owners carry a copy of the skill, and automated SKILL.md quality checks, minus penalties for safety-check warnings and for each further skill from the same repository. Skills that fail the safety check are not listed.