Topic · Databases
Best query optimization skills, page 4
Query optimization skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 145 | 145.SQL Toolkit Query, design, migrate, and optimize SQL databases. An agent skill from LeoYeAI/openclaw-master-skills. | LeoYeAI/ | 2.2k | — | ~3k | Automated safety check: Pass | MIT | 2 mo ago |
| 146 | SQL query optimization catalog. An agent skill from revfactory/harness-100. | revfactory/ | 1.3k | — | ~1.9k | Automated safety check: Pass | Apache-2.0 | 6 mo ago |
| 147 | Advanced query tuning: join algorithms, skip index selection, EXPLAIN interpretation, ProfileEvents profiling, and optimizer settings. | chmonitor/ | 298 | — | ~1.1k | Automated safety check: Pass | GPL-3.0 | 2 days ago |
| 148 | Pull and interpret production experiment query-performance data from the staff-only /api/debugchqueries endpoints backing the /experiments/staff scene: slowest experiment queries, precompute… | PostHog/ | 721 | — | ~3.7k | Automated safety check: Pass | MIT | today |
| 149 | Determine which PostHog team owns a file, directory, or code path, or enumerate all code a team owns (via distributed owners.yaml, products//product.yaml, and .github/CODEOWNERS). | PostHog/ | 721 | — | ~1.5k | Automated safety check: Pass | MIT | today |
| 150 | Explore and diagnose a PostHog endpoint's execution logs — error messages, failed runs, cache misses, slow runs, or unexpected row counts during endpoint invocations. | PostHog/ | 721 | — | ~1.7k | Automated safety check: Pass | MIT | today |
| 151 | Run read-only SQL against the local Postgres app database (SELECT, EXPLAIN, EXPLAIN ANALYZE on SELECT). | PostHog/ | 721 | — | ~2.5k | Automated safety check: Notes | MIT | today |
| 152 | Runs read-only production database analysis through PostHog's internal Metabase instances. | PostHog/ | 721 | — | ~2.8k | Automated safety check: Pass | MIT | today |
| 153 | 153.SQL Optimizer Diagnose a slow SQL query and produce a concrete optimization plan. | mohitagw15856/ | 1.4k | — | ~908 | Automated safety check: Pass | MIT | yesterday |
| 154 | 154.Databases Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). | Microck/ | 401 | — | ~1.9k | Automated safety check: Notes | MIT | 1 mo ago |
| 155 | Optimize SQL query performance using EXPLAIN analysis, indexing strategies, and common anti-pattern fixes. | asgard-ai-platform/ | 241 | — | ~1.3k | Automated safety check: Pass | MIT | 4 mo ago |
| 156 | 156.DB Performance Производительность БД и запросов 1С. An agent skill from IngvarConsulting/unica. | IngvarConsulting/ | 215 | — | ~920 | Automated safety check: Pass | Unknown | today |
| 157 | 157.Performance A skill your agent uses when diagnosing a slow HTTP endpoint or high-latency service — profiling, adding an application-level cache, offloading CPU-bound work to threads or workers, or defining a… | kid-sid/ | 189 | — | ~3.8k | Automated safety check: Pass | MIT | 2 mo ago |
| 158 | 158.Postgresql A skill your agent uses when writing complex PostgreSQL queries, diagnosing slow queries with EXPLAIN ANALYZE, designing indexes (B-tree, GIN, partial, composite), handling concurrent writes and… | kid-sid/ | 189 | — | ~3.7k | Automated safety check: Pass | MIT | 2 mo ago |
| 159 | Diagnose and improve slow Django database-backed endpoints with evidence-first profiling, query-plan review, index selection, ORM loading fixes, batching, database-side computation, materialized… | hashgraph-online/ | 1.2k | — | ~888 | Automated safety check: Pass | MIT | yesterday |
| 160 | Design safe Django and PostgreSQL indexes from measured query plans, including B-tree, composite, covering, partial, expression, GIN/JSONB, BRIN, and concurrent migration patterns. | hashgraph-online/ | 1.2k | — | ~643 | Automated safety check: Pass | MIT | yesterday |
| 161 | Optimize Django ORM query loading by fixing N+1 queries, duplicate related-object queries, over-fetching, serializer/template query loops, and inappropriate selectrelated, prefetchrelated, only, or… | hashgraph-online/ | 1.2k | — | ~650 | Automated safety check: Pass | MIT | yesterday |
| 162 | Read and compare Django/PostgreSQL query execution plans using QuerySet.explain(), EXPLAIN, EXPLAIN ANALYZE, scan types, joins, estimates, actual timing, buffers, and row counts. | hashgraph-online/ | 1.2k | — | ~660 | Automated safety check: Pass | MIT | yesterday |
| 163 | Find the Django ORM code and request path responsible for slow SQL by using APM traces, slow query logs, Django Debug Toolbar, query logging, and local reproduction. | hashgraph-online/ | 1.2k | — | ~644 | Automated safety check: Pass | MIT | yesterday |
| 164 | 164.Django Test Data Design faster, clearer Django test data and test structure with factories, setUpTestData, SimpleTestCase/TestCase choices, fixture-file cleanup, query optimization, and unit-vs-integration boundaries. | hashgraph-online/ | 1.2k | — | ~958 | Automated safety check: Pass | MIT | yesterday |
| 165 | Diagnose and optimize existing slow SQL queries using execution plans, indexing strategies, query rewriting, and ORM tuning. | seb1n/ | 206 | — | ~2.6k | Automated safety check: Pass | MIT | 1 mo ago |
| 166 | Generate SQL queries from natural-language requirements using SELECT, JOIN, GROUP BY, window functions, CTEs, and subqueries. | seb1n/ | 206 | — | ~2.3k | Automated safety check: Pass | MIT | 1 mo ago |
| 167 | 167.Code Optimizer Analyzes and optimizes code for better performance, memory usage, and efficiency. | ArabelaTso/ | 253 | — | ~3.1k | Automated safety check: Pass | Apache-2.0 | 1 mo ago |
| 168 | 168.Insforge Debug A skill your agent uses when diagnosing problems in an InsForge project — reactive failures (SDK error object, HTTP 4xx/5xx, gateway timeout 502/503/504, edge function failure or timeout… | aiskillstore/ | 430 | — | ~3.8k | Automated safety check: Pass | Apache-2.0 | today |
| 169 | Expert in building Datalog queries for Logseq DB graphs. An agent skill from aiskillstore/marketplace. | aiskillstore/ | 430 | — | ~1.9k | Automated safety check: Pass | No licence | today |
| 170 | 170.SQL Expert Write, optimize, and debug T-SQL queries for Microsoft SQL Server. | aiskillstore/ | 430 | — | ~720 | Automated safety check: Pass | No licence | today |
| 171 | Grafana Cloud Database Observability — query-level performance insights for MySQL and PostgreSQL. | Kilo-Org/ | 189 | — | ~1.4k | Automated safety check: Pass | Apache-2.0 | 9 days ago |
| 172 | 172.Oracledb Use these skills to manage and monitor Oracle databases by executing SQL statements, exploring schema metadata, analyzing query performance, monitoring active sessions and resource consumption, and… | Kilo-Org/ | 189 | — | ~782 | Automated safety check: Notes | Apache-2.0 | 9 days ago |
| 173 | SQL and NoSQL query optimization techniques, indexing strategies, execution plan analysis, JOIN algorithms, cardinality estimation, and database-specific query patterns | nWave-ai/ | 617 | — | ~1.3k | Automated safety check: Pass | MIT | 21 days ago |
| 174 | Full pipeline for DB design. An agent skill from revfactory/harness-100. | revfactory/ | 1.3k | — | ~1.8k | Automated safety check: Pass | Apache-2.0 | 6 mo ago |
| 175 | SQL 쿼리 최적화 카탈로그. An agent skill from revfactory/harness-100. | revfactory/ | 1.3k | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | 6 mo ago |
| 176 | SQL/NoSQL query optimization pattern, execution plan analysis, index strategy, N+1 resolution etc. | revfactory/ | 1.3k | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | 6 mo ago |
| 177 | SQL/NoSQL 쿼리 최적화 패턴, 실행 계획 분석, 인덱스 전략, N+1 문제 해결 등 데이터베이스 성능 최적화 가이드. | revfactory/ | 1.3k | — | ~1k | Automated safety check: Pass | Apache-2.0 | 6 mo ago |
| 178 | Corrects the wrong defaults a model has when designing a relational schema — the DDL decisions an experienced engineer makes differently. | pproenca/ | 214 | — | ~2.4k | Automated safety check: Pass | MIT | 1 mo ago |
| 179 | PostgreSQL expert with advanced SQL, JSONB, indexing, performance tuning, replication, and extensions. | theneoai/ | 183 | — | ~3.5k | Automated safety check: Pass | MIT | 4 mo ago |
| 180 | Profiles slow PostHog API endpoints when the main cost is in Postgres or Python. | PostHog/ | 721 | — | ~1k | Automated safety check: Pass | MIT | today |
| 181 | Mapping design, query optimization, aggregation patterns, index lifecycle management, and search relevance tuning. | vibeeval/ | 531 | — | ~2.1k | Automated safety check: Pass | MIT | 2 mo ago |
| 182 | Database schema design expertise covering normalization, denormalization strategies, indexing, query optimization, partitioning, connection pooling, migration management, multi-tenancy patterns, and… | FerroxLabs/ | 608 | — | ~4k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 183 | 183.Mysql Optimizer MySQL optimization expertise covering query optimization with EXPLAIN analysis, indexing strategies, InnoDB tuning, slow query log analysis, connection pooling, replication architectures… | FerroxLabs/ | 608 | — | ~3.5k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 184 | Advanced SQL for analytics covering window functions, CTEs, recursive queries, query optimization, pivoting, and complex analytical patterns for data warehouses and analytics databases. | FerroxLabs/ | 608 | — | ~3.6k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 185 | 185.SQL Master Advanced SQL expertise including window functions, CTEs, recursive queries, query optimization with EXPLAIN plans, indexing strategies, pivot/unpivot operations, JSON operations, full-text search… | FerroxLabs/ | 608 | — | ~4k | Automated safety check: Pass | Apache-2.0 | yesterday |