Topic · Databases

Best query optimization skills, page 3

Skills #97–144 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
97

Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server.

ancoleman/ai-design-components526—~3kAutomated safety check: PassMIT10 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/skills356—~1.4kAutomated safety check: NotesNo licence5 days ago
99

Implement server APIs, authentication, and application data access.

first-fluke/oh-my-agent1.3k—~2.6kAutomated safety check: PassMITyesterday
100
100.DsqlOfficial

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/agent-plugins912—~6.9kAutomated safety check: PassApache-2.02 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/skills278—~1.1kAutomated safety check: PassApache-2.0yesterday
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/sf-skills1.1k—~1.6kAutomated safety check: PassApache-2.05 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/oh-my-hermes3.2k—~2.3kAutomated safety check: PassMITtoday
104

Build complex Boolean query strings for precise PubMed/MEDLINE literature retrieval.

aipoch/medical-research-skills2k—~3.6kAutomated safety check: PassMIT20 days ago
105

Run EXPLAIN QUERY PLAN against every query in a sqlc-style catalog and diff the plans against a baseline.

mizchi/skills356—~1.4kAutomated safety check: PassNo licence5 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/Frappe_Claude_Skill_Package187—~2.9kAutomated safety check: PassMIT20 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/neo4j-skills114—~2.6kAutomated safety check: NotesMITyesterday
108

Optimizes Snowflake SQL query performance from provided query text.

AltimateAI/data-engineering-skills127—~1.7kAutomated safety check: PassMIT6 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/Claude-Skills874—~1.5kAutomated safety check: PassMITyesterday
110

PostgreSQL performance tuning for the docker instance: memory sizing vs the 1g memlimit (sharedbuffers, effectivecachesize, workmem math), checkpoint tuning (maxwalsize, checkpointcompletiontarget…

fmflurry/settings-opencode171—~2.6kAutomated safety check: PassMIT2 days ago
111

Core DQL syntax, pitfalls, query patterns, and query optimization.

Dynatrace/dynatrace-for-ai161—~9.3kAutomated safety check: PassApache-2.06 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/dynatrace-for-ai161—~5.7kAutomated safety check: PassApache-2.06 days ago
113

A seasoned DBA interviewer who has diagnosed every slow query pattern in production.

PrepLabsAI/InterviewMentor112—~2.6kAutomated safety check: PassMITyesterday
114

A Data Engineering interviewer focused on database performance.

PrepLabsAI/InterviewMentor112—~2.1kAutomated safety check: PassMITyesterday
115

Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle.

xiaoyuge886/aigc198—~315Automated safety check: PassMIT2 mo ago
116

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/advpl-specialist185—~487Automated safety check: PassMIT23 days ago
117

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across SQL databases (PostgreSQL, SQL Server, Oracle).

totvs/engpro-advpl-tlpp-skills141—~1.2kAutomated safety check: PassMIT2 days ago
118

Staff+ DBA SQL patterns targeting what Claude's defaults miss - multi-column statistics, operator classes, keyset pagination, silent performance anti-patterns.

rileyhilliard/claude-essentials130—~627Automated safety check: PassMIT1 mo ago
119

SQL query optimization and database performance specialist. An agent skill from aiskillstore/marketplace.

aiskillstore/marketplace4301 repo~787Automated safety check: PassNo licencetoday
120

Guidance for SQL query optimization tasks. An agent skill from lazyFrogLOL/Harness_Engineering.

lazyFrogLOL/Harness_Engineering128—~2.1kAutomated safety check: PassNo licence4 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/cde-dotnetcc109—~1.1kAutomated safety check: NotesNo licence2 mo ago
122

Comprehensive database administration, schema management, data operations, and optimization.

LeoYeAI/openclaw-master-skills2.2k—~552Automated safety check: PassMIT2 mo ago
123

Performance optimization patterns for the HMIS project. An agent skill from hmislk/hmis.

hmislk/hmis236—~499Automated safety check: PassGPL-3.0today
124

Structured triage recipes for common ClickHouse incidents: disk, errors, replication, mutations, cluster health, and slow queries.

chmonitor/chmonitor298—~3.4kAutomated safety check: PassGPL-3.02 days ago
125

Diagnose a slow or expensive query with EXPLAIN and querylog, then propose concrete rewrites and better join strategies.

chmonitor/chmonitor298—~2.4kAutomated safety check: PassGPL-3.02 days ago
126

PostgreSQL optimization including indexes, query plans, partitioning, JSONB operations, and connection pooling

rohitg00/awesome-claude-code-toolkit2.7k—~1.1kAutomated safety check: PassApache-2.04 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/godmode107—~2.3kAutomated safety check: PassMIT7 mo ago
128

Validate database integrity, test migrations forward and backward, verify schema constraints, manage seed data, detect migration drift, and identify query performance issues.

petrkindlmann/qa-skills163—~4.2kAutomated safety check: PassMIT3 mo ago
129

Expert guidance for working with the Apache Spark Catalyst query optimisation framework.

aehrc/pathling137—~5.4kAutomated safety check: PassApache-2.0today
130
130.Dax

DAX performance optimization for semantic models. An agent skill from data-goblin/power-bi-agentic-development.

data-goblin/power-bi-agentic-development1k—~593Automated safety check: PassGPL-3.02 days ago
131

DB schema design and query tuning: normalization, indexing, N+1, transactions, EXPLAIN.

softspark/ai-toolkit179—~2.5kAutomated safety check: PassApache-2.0yesterday
132

Performance profiling for Node.js, Python, and Go: CPU flamegraphs, memory leak detection, bundle analysis, query optimization, and k6 load testing.

borghei/Claude-Skills874—~1.8kAutomated safety check: PassMITyesterday
133

Produce and structure slow-query performance reports for PostHog's production ClickHouse (US and EU).

PostHog/posthog-foss721—~5.1kAutomated safety check: PassMITtoday
134

Every Bing Webmaster API endpoint, plus the SEO intelligence no other Bing tool ships: period-over-period deltas,...

mvanhorn/printing-press-library2.1k—~4.6kAutomated safety check: NotesApache-2.0yesterday
135

Optimize JPA/Hibernate: entity design, query performance, N+1 prevention, caching strategies

Hack23/cia239—~531Automated safety check: PassApache-2.0yesterday
136

Application performance tuning, JVM optimization, database query tuning, Vaadin UI performance

Hack23/cia239—~1.9kAutomated safety check: PassApache-2.0yesterday
137

Analyzes SQL queries for missing indexes, N+1 patterns, suboptimal joins, and full table scans.

Mathews-Tom/armory327—~2.3kAutomated safety check: PassMIT2 days ago
138

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/rsc-harness156—~3.7kAutomated safety check: PassMITyesterday
139

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/rsc-harness156—~4.8kAutomated safety check: PassMITyesterday
140

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/rsc-harness156—~4kAutomated safety check: PassMITyesterday
141

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/rsc-harness156—~4.4kAutomated safety check: PassMITyesterday
142

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/agent-skills111—~4kAutomated safety check: PassMITyesterday
143

Expert SQL query writing, optimization, and database schema design with support for PostgreSQL, MySQL, SQLite, and SQL Server.

aiskillstore/marketplace430—~3.4kAutomated safety check: PassNo licencetoday
144

A skill your agent uses when analyzing BigQuery usage patterns, costs, and query performance for a GCP project

openshift-eng/ai-helpers120—~2.7kAutomated safety check: PassApache-2.0yesterday