Topic · Databases
Best query optimization skills, page 3
Query optimization skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 97 | Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server. | ancoleman/ | 526 | — | ~3k | Automated safety check: Pass | MIT | 10 mo ago |
| 98 | Cloudflare Worker telemetry at the fetch boundary — OTLP traces / metrics / logs + utels error tracking + D1 Proxy that emits slow-query warnings. | mizchi/ | 356 | — | ~1.4k | Automated safety check: Notes | No licence | 5 days ago |
| 99 | 99.Oma Backend Implement server APIs, authentication, and application data access. | first-fluke/ | 1.3k | — | ~2.6k | Automated safety check: Pass | MIT | yesterday |
| 100 | Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, diagnose cluster performance, load data, and develop applications with a serverless, distributed… | awslabs/ | 912 | — | ~6.9k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 101 | Set up Grafana Cloud Database Observability for MySQL and PostgreSQL — enables pgstatstatements / Performance Schema, creates a least-privilege monitoring user, configures the… | grafana/ | 278 | — | ~1.1k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 102 | A skill your agent uses when the user needs SOQL/SOSL authoring or optimization: natural-language-to-query generation, relationship queries, aggregates, query-plan/selectivity analysis, and… | forcedotcom/ | 1.1k | — | ~1.6k | Automated safety check: Pass | Apache-2.0 | 5 days ago |
| 103 | [omh] Database work on a relational store -- a slow query, an index to size, a migration on a big table, a lock taken during deploy, N+1 queries: plan it with the checks that prove it safe, and… | rlaope/ | 3.2k | — | ~2.3k | Automated safety check: Pass | MIT | today |
| 104 | Build complex Boolean query strings for precise PubMed/MEDLINE literature retrieval. | aipoch/ | 2k | — | ~3.6k | Automated safety check: Pass | MIT | 20 days ago |
| 105 | 105.SQL Plan Audit Run EXPLAIN QUERY PLAN against every query in a sqlc-style catalog and diff the plans against a baseline. | mizchi/ | 356 | — | ~1.4k | Automated safety check: Pass | No licence | 5 days ago |
| 106 | A skill your agent uses when tuning MariaDB, configuring Redis memory, sizing Gunicorn workers, setting up CDN, or profiling slow queries. | Impertio-Studio/ | 187 | — | ~2.9k | Automated safety check: Pass | MIT | 20 days ago |
| 107 | Diagnoses and fixes slow Neo4j Cypher queries by reading execution plans, identifying bad operators (AllNodesScan, CartesianProduct, Eager, NodeByLabelScan), and prescribing fixes (indexes, hints… | neo4j-contrib/ | 114 | — | ~2.6k | Automated safety check: Notes | MIT | yesterday |
| 108 | Optimizes Snowflake SQL query performance from provided query text. | AltimateAI/ | 127 | — | ~1.7k | Automated safety check: Pass | MIT | 6 days ago |
| 109 | This skill should be used when the user asks to "optimize SQL queries", "explore database schemas", "generate migration SQL", "analyze query performance", or "document database structure". | borghei/ | 874 | — | ~1.5k | Automated safety check: Pass | MIT | yesterday |
| 110 | PostgreSQL performance tuning for the docker instance: memory sizing vs the 1g memlimit (sharedbuffers, effectivecachesize, workmem math), checkpoint tuning (maxwalsize, checkpointcompletiontarget… | fmflurry/ | 171 | — | ~2.6k | Automated safety check: Pass | MIT | 2 days ago |
| 111 | Core DQL syntax, pitfalls, query patterns, and query optimization. | Dynatrace/ | 161 | — | ~9.3k | Automated safety check: Pass | Apache-2.0 | 6 days ago |
| 112 | Query and analyze a Dynatrace tenant's ACTUAL billing and usage data with DQL against dt.system.events — DPS consumption breakdown, cost-normalized spend ranking, included volume deduction… | Dynatrace/ | 161 | — | ~5.7k | Automated safety check: Pass | Apache-2.0 | 6 days ago |
| 113 | A seasoned DBA interviewer who has diagnosed every slow query pattern in production. | PrepLabsAI/ | 112 | — | ~2.6k | Automated safety check: Pass | MIT | yesterday |
| 114 | A Data Engineering interviewer focused on database performance. | PrepLabsAI/ | 112 | — | ~2.1k | Automated safety check: Pass | MIT | yesterday |
| 115 | 115.Agent SQL Pro Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle. | xiaoyuge886/ | 198 | — | ~315 | Automated safety check: Pass | MIT | 2 mo ago |
| 116 | 116.Advpl Debugging A skill your agent uses when the user asks to debug, diagnose, or fix an ADVPL/TLPP error on TOTVS Protheus -- compilation errors (syntax, missing includes, undeclared variables), runtime failures… | thalysjuvenal/ | 185 | — | ~487 | Automated safety check: Pass | MIT | 23 days ago |
| 117 | 117.SQL Optimization Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across SQL databases (PostgreSQL, SQL Server, Oracle). | totvs/ | 141 | — | ~1.2k | Automated safety check: Pass | MIT | 2 days ago |
| 118 | 118.Writing SQL Staff+ DBA SQL patterns targeting what Claude's defaults miss - multi-column statistics, operator classes, keyset pagination, silent performance anti-patterns. | rileyhilliard/ | 130 | — | ~627 | Automated safety check: Pass | MIT | 1 mo ago |
| 119 | SQL query optimization and database performance specialist. An agent skill from aiskillstore/marketplace. | aiskillstore/ | 430 | 1 repo | ~787 | Automated safety check: Pass | No licence | today |
| 120 | 120.Query Optimize Guidance for SQL query optimization tasks. An agent skill from lazyFrogLOL/Harness_Engineering. | lazyFrogLOL/ | 128 | — | ~2.1k | Automated safety check: Pass | No licence | 4 mo ago |
| 121 | Optimize EF Core (Npgsql/PostgreSQL) queries in the .NET API — fix N+1, choose tracking modes, use compiled queries, split queries, and avoid translation traps. | atherio-danp/ | 109 | — | ~1.1k | Automated safety check: Notes | No licence | 2 mo ago |
| 122 | 122.Database Admin Comprehensive database administration, schema management, data operations, and optimization. | LeoYeAI/ | 2.2k | — | ~552 | Automated safety check: Pass | MIT | 2 mo ago |
| 123 | Performance optimization patterns for the HMIS project. An agent skill from hmislk/hmis. | hmislk/ | 236 | — | ~499 | Automated safety check: Pass | GPL-3.0 | today |
| 124 | Structured triage recipes for common ClickHouse incidents: disk, errors, replication, mutations, cluster health, and slow queries. | chmonitor/ | 298 | — | ~3.4k | Automated safety check: Pass | GPL-3.0 | 2 days ago |
| 125 | Diagnose a slow or expensive query with EXPLAIN and querylog, then propose concrete rewrites and better join strategies. | chmonitor/ | 298 | — | ~2.4k | Automated safety check: Pass | GPL-3.0 | 2 days ago |
| 126 | PostgreSQL optimization including indexes, query plans, partitioning, JSONB operations, and connection pooling | rohitg00/ | 2.7k | — | ~1.1k | Automated safety check: Pass | Apache-2.0 | 4 mo ago |
| 127 | A skill your agent uses when performance is a concern - sluggish pages, slow queries, bloated bundles, high-latency APIs, or whenever someone says "optimize" or "make it faster" | NoobyGains/ | 107 | — | ~2.3k | Automated safety check: Pass | MIT | 7 mo ago |
| 128 | 128.Database Testing Validate database integrity, test migrations forward and backward, verify schema constraints, manage seed data, detect migration drift, and identify query performance issues. | petrkindlmann/ | 163 | — | ~4.2k | Automated safety check: Pass | MIT | 3 mo ago |
| 129 | 129.Spark Catalyst Expert guidance for working with the Apache Spark Catalyst query optimisation framework. | aehrc/ | 137 | — | ~5.4k | Automated safety check: Pass | Apache-2.0 | today |
| 130 | 130.Dax DAX performance optimization for semantic models. An agent skill from data-goblin/power-bi-agentic-development. | data-goblin/ | 1k | — | ~593 | Automated safety check: Pass | GPL-3.0 | 2 days ago |
| 131 | DB schema design and query tuning: normalization, indexing, N+1, transactions, EXPLAIN. | softspark/ | 179 | — | ~2.5k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 132 | Performance profiling for Node.js, Python, and Go: CPU flamegraphs, memory leak detection, bundle analysis, query optimization, and k6 load testing. | borghei/ | 874 | — | ~1.8k | Automated safety check: Pass | MIT | yesterday |
| 133 | Produce and structure slow-query performance reports for PostHog's production ClickHouse (US and EU). | PostHog/ | 721 | — | ~5.1k | Automated safety check: Pass | MIT | today |
| 134 | Every Bing Webmaster API endpoint, plus the SEO intelligence no other Bing tool ships: period-over-period deltas,... | mvanhorn/ | 2.1k | — | ~4.6k | Automated safety check: Notes | Apache-2.0 | yesterday |
| 135 | Optimize JPA/Hibernate: entity design, query performance, N+1 prevention, caching strategies | Hack23/ | 239 | — | ~531 | Automated safety check: Pass | Apache-2.0 | yesterday |
| 136 | Application performance tuning, JVM optimization, database query tuning, Vaadin UI performance | Hack23/ | 239 | — | ~1.9k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 137 | 137.SQL Optimizer Analyzes SQL queries for missing indexes, N+1 patterns, suboptimal joins, and full table scans. | Mathews-Tom/ | 327 | — | ~2.3k | Automated safety check: Pass | MIT | 2 days ago |
| 138 | 138.GCP Essentials A skill your agent uses when running a small product on core Google Cloud via the gcloud CLI: a project, Cloud Run deploys, a locked-down Cloud Storage bucket, managed Cloud SQL, and least-privilege… | ericrisco/ | 156 | — | ~3.7k | Automated safety check: Pass | MIT | yesterday |
| 139 | 139.Mongodb A skill your agent uses when modeling MongoDB documents (embed versus reference, the 16MB cap, bucket and subset patterns), choosing or fixing indexes (compound order by the ESR rule, partial, TTL… | ericrisco/ | 156 | — | ~4.8k | Automated safety check: Pass | MIT | yesterday |
| 140 | 140.Performance A skill your agent uses when a page or interaction is slow for one user and the fix starts from a measurement — a failing Core Web Vital (LCP, INP, CLS), a heavy JS bundle, wasted re-renders, an… | ericrisco/ | 156 | — | ~4k | Automated safety check: Pass | MIT | yesterday |
| 141 | 141.Postgresdb A skill your agent uses when PostgreSQL engine behaviour decides the answer — schema and type design, index choice, reading EXPLAIN on a slow query, zero-downtime DDL and backfills, or ops (roles… | ericrisco/ | 156 | — | ~4.4k | Automated safety check: Pass | MIT | yesterday |
| 142 | 142.Postgres Operate PostgreSQL instances safely: configuration review, index and query-plan analysis, vacuum and bloat management, WAL archiving and point-in-time recovery, replication and failover, extensions… | magnus919/ | 111 | — | ~4k | Automated safety check: Pass | MIT | yesterday |
| 143 | 143.SQL Expert Expert SQL query writing, optimization, and database schema design with support for PostgreSQL, MySQL, SQLite, and SQL Server. | aiskillstore/ | 430 | — | ~3.4k | Automated safety check: Pass | No licence | today |
| 144 | 144.Analyze Usage A skill your agent uses when analyzing BigQuery usage patterns, costs, and query performance for a GCP project | openshift-eng/ | 120 | — | ~2.7k | Automated safety check: Pass | Apache-2.0 | yesterday |