Search
Query optimization
Skills
Sort:BestMost starsTrending todayTrending this weekTrending this monthNewestRecently updatedName
| # | 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 | today |
| 4 | Guides safe, measurable MySQL and InnoDB changes across schema design, indexing, query tuning, transactions, locking and replication, with rollout steps. | planetscale/ | 705 | 3 repos | ~1.4k | Automated safety check: Pass | MIT | today |
| 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/ | 235 | 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/ | 705 | 3 repos | ~1.8k | Automated safety check: Pass | MIT | today |
| 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 | today |
| 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 | yesterday |
| 12 | Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. | ynulihao/ | 617 | 11 repos | ~3.3k | Automated safety check: Pass | No licence | 7 mo ago |
| 13 | 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 | today |
| 14 | 从论文 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 | 10 days ago |
| 15 | Query Cloud Trace spans, filter by latency thresholds or error status, correlate distributed traces with Cloud Logging, and diagnose latency bottlenecks across Google Cloud services. | google/ | 21k | — | ~1.7k | Automated safety check: Pass | Apache-2.0 | today |
| 16 | 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 |
| 17 | 17.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 |
| 18 | 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 | today |
| 19 | 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 |
| 20 | Guidance on Vitess sharding, VSchema design, query tuning and connection problems for MySQL-compatible databases running on PlanetScale. | planetscale/ | 705 | 1 repo | ~1.2k | Automated safety check: Pass | MIT | today |
| 21 | 21.DB Ops Sop Database operations runbook — backup, recovery, performance tuning, troubleshooting. | OpenDCAI/ | 423 | — | ~388 | Automated safety check: Pass | Apache-2.0 | 18 days ago |
| 22 | 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 |
| 23 | 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 |
| 24 | 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 | 18 days ago |
| 25 | 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 |
| 26 | 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 |
| 27 | 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 | yesterday |
| 28 | 28.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/ | 973 | — | ~1.8k | Automated safety check: Pass | AGPL-3.0 | 1 mo ago |
| 29 | Delegates dbt and warehouse tasks such as lineage, migrations and cost attribution to the altimate-code CLI agent and relays its answer back. | AltimateAI/ | 128 | — | ~1.4k | Automated safety check: Pass | MIT | 6 days ago |
| 30 | Design, refactor and diagnose Paro's staged optimizer, using EXPLAIN COMPILE for planning and EXPLAIN ANALYZE for execution. | zunor/ | 105 | — | ~979 | Automated safety check: Pass | Apache-2.0 | today |
| 31 | 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 |
| 32 | 32.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 |
| 33 | MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance. | ClickHouse/ | 544 | — | ~1.2k | Automated safety check: Pass | Apache-2.0 | 9 days ago |
| 34 | 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 |
| 35 | 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 | today |
| 36 | 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 | 9 repos | ~565 | Automated safety check: Pass | MIT | 3 days ago |
| 37 | WordPress ACF and content modeling review. An agent skill from jorgerosal/wordpress-skills. | jorgerosal/ | 101 | — | ~3.2k | Automated safety check: Pass | MIT | 4 mo ago |
| 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 | 3 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/ | 275k | 5 repos | ~1.2k | Automated safety check: Pass | MIT | 3 days ago |
| 41 | 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 |
| 42 | 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 |
| 43 | 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 |
| 44 | CloudBase PostgreSQL access-pattern and slow-query quality guidance. | TencentCloudBase/ | 1.1k | 1 repo | ~1.3k | Automated safety check: Pass | MIT | today |
| 45 | 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 |
| 46 | 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 |
| 47 | PostgreSQL database patterns for query optimization, schema design, indexing, and security. | ThibautBaissac/ | 665 | 7 repos | ~922 | Automated safety check: Pass | MIT | 4 mo ago |
| 48 | 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/ | 240 | — | ~1.4k | Automated safety check: Pass | MIT | 10 days ago |