Topic · Databases

Best query optimization skills, page 4

Skills #145–185 of 185, ranked by score.

Query optimization skills, ranked

Ranked by score. Sort bymost stars,trending,newest,recently updated

Query optimization skills, ranked
#SkillRepositoryStarsUsed inTokensAuto-checkLicenceUpdated
145

Query, design, migrate, and optimize SQL databases. An agent skill from LeoYeAI/openclaw-master-skills.

LeoYeAI/openclaw-master-skills2.2k—~3kAutomated safety check: PassMIT2 mo ago
146

SQL query optimization catalog. An agent skill from revfactory/harness-100.

revfactory/harness-1001.3k—~1.9kAutomated safety check: PassApache-2.06 mo ago
147

Advanced query tuning: join algorithms, skip index selection, EXPLAIN interpretation, ProfileEvents profiling, and optimizer settings.

chmonitor/chmonitor298—~1.1kAutomated safety check: PassGPL-3.02 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/posthog-foss721—~3.7kAutomated safety check: PassMITtoday
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/posthog-foss721—~1.5kAutomated safety check: PassMITtoday
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/posthog-foss721—~1.7kAutomated safety check: PassMITtoday
151

Run read-only SQL against the local Postgres app database (SELECT, EXPLAIN, EXPLAIN ANALYZE on SELECT).

PostHog/posthog-foss721—~2.5kAutomated safety check: NotesMITtoday
152

Runs read-only production database analysis through PostHog's internal Metabase instances.

PostHog/posthog-foss721—~2.8kAutomated safety check: PassMITtoday
153

Diagnose a slow SQL query and produce a concrete optimization plan.

mohitagw15856/pm-claude-skills1.4k—~908Automated safety check: PassMITyesterday
154

Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin).

Microck/ordinary-claude-skills401—~1.9kAutomated safety check: NotesMIT1 mo ago
155

Optimize SQL query performance using EXPLAIN analysis, indexing strategies, and common anti-pattern fixes.

asgard-ai-platform/skills241—~1.3kAutomated safety check: PassMIT4 mo ago
156

Производительность БД и запросов 1С. An agent skill from IngvarConsulting/unica.

IngvarConsulting/unica215—~920Automated safety check: PassUnknowntoday
157

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/claude-spellbook189—~3.8kAutomated safety check: PassMIT2 mo ago
158

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/claude-spellbook189—~3.7kAutomated safety check: PassMIT2 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/awesome-codex-plugins1.2k—~888Automated safety check: PassMITyesterday
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/awesome-codex-plugins1.2k—~643Automated safety check: PassMITyesterday
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/awesome-codex-plugins1.2k—~650Automated safety check: PassMITyesterday
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/awesome-codex-plugins1.2k—~660Automated safety check: PassMITyesterday
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/awesome-codex-plugins1.2k—~644Automated safety check: PassMITyesterday
164

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/awesome-codex-plugins1.2k—~958Automated safety check: PassMITyesterday
165

Diagnose and optimize existing slow SQL queries using execution plans, indexing strategies, query rewriting, and ORM tuning.

seb1n/awesome-ai-agent-skills206—~2.6kAutomated safety check: PassMIT1 mo ago
166

Generate SQL queries from natural-language requirements using SELECT, JOIN, GROUP BY, window functions, CTEs, and subqueries.

seb1n/awesome-ai-agent-skills206—~2.3kAutomated safety check: PassMIT1 mo ago
167

Analyzes and optimizes code for better performance, memory usage, and efficiency.

ArabelaTso/Skills-4-SE253—~3.1kAutomated safety check: PassApache-2.01 mo ago
168

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/marketplace430—~3.8kAutomated safety check: PassApache-2.0today
169

Expert in building Datalog queries for Logseq DB graphs. An agent skill from aiskillstore/marketplace.

aiskillstore/marketplace430—~1.9kAutomated safety check: PassNo licencetoday
170

Write, optimize, and debug T-SQL queries for Microsoft SQL Server.

aiskillstore/marketplace430—~720Automated safety check: PassNo licencetoday
171

Grafana Cloud Database Observability — query-level performance insights for MySQL and PostgreSQL.

Kilo-Org/kilo-marketplace189—~1.4kAutomated safety check: PassApache-2.09 days ago
172

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/kilo-marketplace189—~782Automated safety check: NotesApache-2.09 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/nWave617—~1.3kAutomated safety check: PassMIT21 days ago
174

Full pipeline for DB design. An agent skill from revfactory/harness-100.

revfactory/harness-1001.3k—~1.8kAutomated safety check: PassApache-2.06 mo ago
175

SQL 쿼리 최적화 카탈로그. An agent skill from revfactory/harness-100.

revfactory/harness-1001.3k—~1.3kAutomated safety check: PassApache-2.06 mo ago
176

SQL/NoSQL query optimization pattern, execution plan analysis, index strategy, N+1 resolution etc.

revfactory/harness-1001.3k—~1.3kAutomated safety check: PassApache-2.06 mo ago
177

SQL/NoSQL 쿼리 최적화 패턴, 실행 계획 분석, 인덱스 전략, N+1 문제 해결 등 데이터베이스 성능 최적화 가이드.

revfactory/harness-1001.3k—~1kAutomated safety check: PassApache-2.06 mo ago
178

Corrects the wrong defaults a model has when designing a relational schema — the DDL decisions an experienced engineer makes differently.

pproenca/dot-skills214—~2.4kAutomated safety check: PassMIT1 mo ago
179

PostgreSQL expert with advanced SQL, JSONB, indexing, performance tuning, replication, and extensions.

theneoai/awesome-skills183—~3.5kAutomated safety check: PassMIT4 mo ago
180

Profiles slow PostHog API endpoints when the main cost is in Postgres or Python.

PostHog/posthog-foss721—~1kAutomated safety check: PassMITtoday
181

Mapping design, query optimization, aggregation patterns, index lifecycle management, and search relevance tuning.

vibeeval/vibecosystem531—~2.1kAutomated safety check: PassMIT2 mo ago
182

Database schema design expertise covering normalization, denormalization strategies, indexing, query optimization, partitioning, connection pooling, migration management, multi-tenancy patterns, and…

FerroxLabs/wayland608—~4kAutomated safety check: PassApache-2.0yesterday
183

MySQL optimization expertise covering query optimization with EXPLAIN analysis, indexing strategies, InnoDB tuning, slow query log analysis, connection pooling, replication architectures…

FerroxLabs/wayland608—~3.5kAutomated safety check: PassApache-2.0yesterday
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/wayland608—~3.6kAutomated safety check: PassApache-2.0yesterday
185

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/wayland608—~4kAutomated safety check: PassApache-2.0yesterday