Topic · Databases
Best query optimization skills for Claude Code, Codex and other agents.
- skills
- 185
- official
- 21
Query optimization skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 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/ | 2.7k | 24 repos | ~808 | Automated safety check: Pass | MIT | 5 days ago |
| 2 | Apply this skill whenever writing, reviewing, or refactoring Laravel PHP code. | anonaddy/ | 4.9k | 13 repos | ~1.2k | Automated safety check: Pass | MIT | yesterday |
| 3 | Benchmarks Django ORM filters in Saleor by generating bulk data, extracting the SQL and running EXPLAIN ANALYZE to check index usage. | saleor/ | 23k | — | ~2.3k | Automated safety check: Pass | BSD-3-Clause | yesterday |
| 4 | Guides safe, measurable MySQL and InnoDB changes across schema design, indexing, query tuning, transactions, locking and replication, with rollout steps. | planetscale/ | 698 | 3 repos | ~1.4k | Automated safety check: Pass | MIT | yesterday |
| 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/ | 7.5k | — | ~798 | Automated safety check: Pass | MIT | yesterday |
| 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/ | 3.2k | — | ~5.1k | Automated safety check: Pass | Apache-2.0 | today |
| 7 | WordPress performance code review and optimization analysis. | elvismdev/ | 234 | 1 repo | ~4.5k | Automated safety check: Pass | MIT | 10 mo ago |
| 8 | ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads. | hellangleZ/ | 112 | 14 repos | ~2.5k | Automated safety check: Pass | No licence | 8 mo ago |
| 9 | Indexes reference files on Postgres schema design, indexing, partitioning, query patterns, MVCC and VACUUM, and PlanetScale-specific operations. | planetscale/ | 698 | 3 repos | ~1.8k | Automated safety check: Pass | MIT | yesterday |
| 10 | Checklist for reviewing code changes that touch queries, APIs, rendering, caching or algorithms for performance, scalability and resource-usage problems. | ZeroDeng01/ | 1.7k | — | ~1.8k | Automated safety check: Pass | MIT | 2 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/ | 350 | 3 repos | ~1.5k | Automated safety check: Pass | GPL-3.0 | today |
| 12 | Help with MongoDB query optimization and indexing. An agent skill from mongodb/agent-skills. | mongodb/ | 190 | 2 repos | ~2.6k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 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/ | 8.6k | — | ~1.5k | Automated safety check: Pass | GPL-2.0 | 9 days ago |
| 14 | Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. | ynulihao/ | 617 | 10 repos | ~3.3k | Automated safety check: Pass | No licence | 7 mo ago |
| 15 | PostgreSQL database documentation - SQL queries, database design, administration, performance tuning, and advanced features. Use when working with… | 2025Emma/ | 23k | 1 repo | ~19k | Automated safety check: Pass | MIT | 9 mo ago |
| 16 | 16.Clawmem 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/ | 210 | — | ~7.5k | Automated safety check: Pass | MIT | 2 days ago |
| 17 | Specialized skill for working in the fdb-relational-core SQL processing layer — parser, plan generator, and Cascades planner. | FoundationDB/ | 675 | — | ~1k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 18 | Query ClickHouse system tables to inspect query logs, monitor cluster health, check replication status, and analyze slow queries. | FrankChen021/ | 327 | — | ~731 | Automated safety check: Pass | Unknown | 2 mo ago |
| 19 | 19.DB Ops Sop Database operations runbook — backup, recovery, performance tuning, troubleshooting. | OpenDCAI/ | 406 | — | ~388 | Automated safety check: Pass | Apache-2.0 | 17 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/ | 404 | — | ~2.6k | Automated safety check: Pass | Apache-2.0 | 9 days ago |
| 21 | Guidance on Vitess sharding, VSchema design, query tuning and connection problems for MySQL-compatible databases running on PlanetScale. | planetscale/ | 698 | 1 repo | ~1.2k | Automated safety check: Pass | MIT | yesterday |
| 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/ | 1.3k | — | ~2.4k | Automated safety check: Pass | MIT | 3 mo ago |
| 23 | Designs and debugs Elixir persistence with Ecto: schemas, changesets, queries, preloads, migrations and multi-tenancy, kept within application contexts. | georgeguimaraes/ | 184 | — | ~1.2k | Automated safety check: Pass | Apache-2.0 | 17 days ago |
| 24 | Query Finelog logs and telemetry for Iris tasks, workers, profiles, training, vLLM, and cross-cluster forwarding. | marin-community/ | 3.9k | — | ~1.1k | Automated safety check: Pass | Apache-2.0 | today |
| 25 | Guides scalability and performance work for VeloxDB's Tauri + Rust PostgreSQL backend and React + TanStack frontend. | veloxbase/ | 646 | — | ~1.7k | Automated safety check: Pass | MIT | 7 days ago |
| 26 | Generates, optimizes, and validates Cypher 25 queries for Neo4j 2025.x and 2026.x. | neo4j-contrib/ | 114 | 1 repo | ~6.1k | Automated safety check: Pass | MIT | today |
| 27 | 27.Taste 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/ | 971 | — | ~1.8k | Automated safety check: Pass | AGPL-3.0 | 1 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/ | 127 | — | ~1.4k | Automated safety check: Pass | MIT | 6 days ago |
| 29 | Design, refactor and diagnose Paro's staged optimizer, using EXPLAIN COMPILE for planning and EXPLAIN ANALYZE for execution. | zunor/ | 105 | — | ~957 | Automated safety check: Pass | Apache-2.0 | 12 days ago |
| 30 | SQL query engine design and implementation guide. An agent skill from revfactory/claude-code-harness. | revfactory/ | 120 | — | ~474 | Automated safety check: Pass | No licence | 7 mo ago |
| 31 | 31.Silk Debug Analyze Django Silk profiling data to debug slow requests, detect N+1 queries, and optimize database performance. | letsrevel/ | 109 | — | ~1.2k | Automated safety check: Pass | MIT | today |
| 32 | MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance. | ClickHouse/ | 544 | — | ~1.2k | Automated safety check: Pass | Apache-2.0 | 8 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/ | 420 | — | ~1.5k | Automated safety check: Pass | BSD-3-Clause | today |
| 34 | Applies ClawHub's repository-specific Convex rules and routes work to the right managed Convex skill for performance, migrations, retention and deployments. | openclaw/ | 9.5k | — | ~1.4k | Automated safety check: Notes | MIT | yesterday |
| 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/ | 40k | 8 repos | ~565 | Automated safety check: Pass | MIT | 2 days ago |
| 36 | WordPress ACF and content modeling review. An agent skill from jorgerosal/wordpress-skills. | jorgerosal/ | 100 | — | ~3.2k | Automated safety check: Pass | MIT | 4 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/ | 21k | — | ~2.3k | Automated safety check: Pass | Apache-2.0 | today |
| 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/ | 113 | — | ~2.8k | Automated safety check: Pass | Unknown | today |
| 39 | 39.DB Sculptor 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/ | 114 | — | ~3.1k | Automated safety check: Notes | MIT | 2 days ago |
| 40 | 40.Jpa Patterns JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot. | affaan-m/ | 274k | 5 repos | ~1.2k | Automated safety check: Pass | MIT | 2 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/ | 104 | — | ~1.5k | Automated safety check: Pass | MIT | 28 days ago |
| 42 | Identifies and fixes Rails performance issues including N+1 queries, slow queries, and memory problems. | ThibautBaissac/ | 665 | — | ~1.2k | Automated safety check: Notes | MIT | 4 mo ago |
| 43 | CloudBase PostgreSQL access-pattern and slow-query quality guidance. | TencentCloudBase/ | 1.1k | 1 repo | ~1.3k | Automated safety check: Pass | MIT | yesterday |
| 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/ | 11k | — | ~395 | Automated safety check: Pass | Unknown | today |
| 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/ | 1.2k | — | ~2.8k | Automated safety check: Pass | Apache-2.0 | today |
| 46 | PostgreSQL database patterns for query optimization, schema design, indexing, and security. | ThibautBaissac/ | 665 | 7 repos | ~922 | Automated safety check: Pass | MIT | 4 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/ | 237 | — | ~1.4k | Automated safety check: Pass | MIT | 9 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/ | 1k | — | ~2.8k | Automated safety check: Pass | GPL-3.0 | 2 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.