Search

Query optimization

186 skills found.
Search results
#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-Clausetoday
4

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

planetscale/database-skills7053 repos~1.4kAutomated safety check: PassMITtoday
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-skills2351 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-skills7053 repos~1.8kAutomated safety check: PassMITtoday
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: PassMITtoday
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.0yesterday
12

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

ynulihao/AgentSkillOS61711 repos~3.3kAutomated safety check: PassNo licence7 mo ago
13

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

mongodb/agent-skills1902 repos~2.6kAutomated safety check: PassApache-2.0today
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/blog8.6k—~1.5kAutomated safety check: PassGPL-2.010 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/skills21k—~1.7kAutomated safety check: PassApache-2.0today
16

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
17

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
18

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.0today
19

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
20

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

planetscale/database-skills7051 repo~1.2kAutomated safety check: PassMITtoday
21

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

OpenDCAI/DataMind423—~388Automated safety check: PassApache-2.018 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/builder-skills404—~2.6kAutomated safety check: PassApache-2.09 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/guard-skills1.3k—~2.4kAutomated safety check: PassMIT3 mo ago
24

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.018 days ago
25

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
26

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
27

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

neo4j-contrib/neo4j-skills1141 repo~6.1kAutomated safety check: PassMITyesterday
28

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-sdk973—~1.8kAutomated safety check: PassAGPL-3.01 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/data-engineering-skills128—~1.4kAutomated safety check: PassMIT6 days ago
30

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

zunor/paro105—~979Automated safety check: PassApache-2.0today
31

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
32

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
33

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

ClickHouse/agent-skills544—~1.2kAutomated safety check: PassApache-2.09 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/rdf4j420—~1.5kAutomated safety check: PassBSD-3-Clausetoday
35

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: NotesMITtoday
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/agents40k9 repos~565Automated safety check: PassMIT3 days ago
37

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

jorgerosal/wordpress-skills101—~3.2kAutomated safety check: PassMIT4 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/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: NotesMIT3 days ago
40

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

affaan-m/ECC275k5 repos~1.2kAutomated safety check: PassMIT3 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/skills21k—~2.3kAutomated safety check: PassApache-2.0today
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/apple-mail-fast-mcp104—~1.5kAutomated safety check: PassMIT28 days ago
43

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
44

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

TencentCloudBase/CloudBase-AI-Toolkit1.1k1 repo~1.3kAutomated safety check: PassMITtoday
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/woocommerce11k—~395Automated safety check: PassUnknowntoday
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/moai-adk1.2k—~2.8kAutomated safety check: PassApache-2.0today
47

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

ThibautBaissac/rails_ai_agents6657 repos~922Automated safety check: PassMIT4 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/sealeap-amazon-skills240—~1.4kAutomated safety check: PassMIT10 days ago