Search
Query optimization
Skills
Sort:BestMost starsTrending todayTrending this weekTrending this monthNewestRecently updatedName
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 97 | 97.Sf Soql SOQL query generation, optimization, and analysis with 100-point scoring. | Jaganpro/ | 424 | — | ~1.2k | Automated safety check: Pass | MIT | 5 mo ago |
| 98 | PostgreSQL database patterns for query optimization, schema design, indexing, and security. | affaan-m/ | 275k | — | ~1k | Automated safety check: Pass | MIT | 3 days ago |
| 99 | 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/ | 40k | — | ~3.7k | Automated safety check: Pass | Unknown | today |
| 100 | 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/ | 40k | — | ~1.5k | Automated safety check: Pass | Unknown | today |
| 101 | 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/ | 40k | — | ~1.7k | Automated safety check: Pass | Unknown | today |
| 102 | Run read-only SQL against the local Postgres app database (SELECT, EXPLAIN, EXPLAIN ANALYZE on SELECT). | PostHog/ | 40k | — | ~2.5k | Automated safety check: Notes | Unknown | today |
| 103 | Runs read-only production database analysis through PostHog's internal Metabase instances. | PostHog/ | 40k | — | ~2.8k | Automated safety check: Pass | Unknown | today |
| 104 | 104.Optimizing SQL 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 |
| 105 | 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 | 6 days ago |
| 106 | 106.Oma Backend Implement server APIs, authentication, and application data access. | first-fluke/ | 1.3k | — | ~2.6k | Automated safety check: Pass | MIT | yesterday |
| 107 | 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/ | 915 | — | ~6.9k | Automated safety check: Pass | Apache-2.0 | 3 days ago |
| 108 | Amazon Redshift domain expertise for query optimization, operational reviews, and cost optimization on provisioned clusters and Serverless workgroups. | aws/ | 100 | — | ~7.3k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 109 | Set up Grafana Cloud Database Observability for MySQL and PostgreSQL — enables pgstatstatements / Performance Schema, creates a least-privilege monitoring user, configures the… | grafana/ | 279 | — | ~1.1k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 110 | Profiles slow PostHog API endpoints when the main cost is in Postgres or Python. | PostHog/ | 40k | — | ~1k | Automated safety check: Pass | Unknown | today |
| 111 | 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 | yesterday |
| 112 | [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 |
| 113 | Build complex Boolean query strings for precise PubMed/MEDLINE literature retrieval. | aipoch/ | 2k | — | ~3.6k | Automated safety check: Pass | MIT | 21 days ago |
| 114 | 114.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 | 6 days ago |
| 115 | Process use when you need to work with database indexing. An agent skill from jeremylongshore/tons-of-skills-marketplace. | jeremylongshore/ | 2.8k | — | ~2k | Automated safety check: Pass | MIT | today |
| 116 | Execute use when you need to work with query optimization. An agent skill from jeremylongshore/tons-of-skills-marketplace. | jeremylongshore/ | 2.8k | — | ~1.8k | Automated safety check: Pass | MIT | today |
| 117 | Process use when you need to implement multi-tier caching to improve database performance. | jeremylongshore/ | 2.8k | — | ~1.8k | Automated safety check: Pass | MIT | today |
| 118 | Execute use when you need to work with query optimization. An agent skill from jeremylongshore/tons-of-skills-marketplace. | jeremylongshore/ | 2.8k | — | ~1.7k | Automated safety check: Pass | MIT | today |
| 119 | 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 | 21 days ago |
| 120 | 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 | 2 days ago |
| 121 | Optimizes Snowflake SQL query performance from provided query text. | AltimateAI/ | 128 | — | ~1.7k | Automated safety check: Pass | MIT | 7 days ago |
| 122 | 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/ | 881 | — | ~1.5k | Automated safety check: Pass | MIT | yesterday |
| 123 | Core DQL syntax, pitfalls, query patterns, and query optimization. | Dynatrace/ | 161 | — | ~9.3k | Automated safety check: Pass | Apache-2.0 | 7 days ago |
| 124 | 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 | 7 days ago |
| 125 | A seasoned DBA interviewer who has diagnosed every slow query pattern in production. | PrepLabsAI/ | 112 | — | ~2.6k | Automated safety check: Pass | MIT | 2 days ago |
| 126 | A Data Engineering interviewer focused on database performance. | PrepLabsAI/ | 112 | — | ~2.1k | Automated safety check: Pass | MIT | 2 days ago |
| 127 | 127.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 |
| 128 | 128.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/ | 186 | — | ~487 | Automated safety check: Pass | MIT | 24 days ago |
| 129 | 129.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/ | 143 | — | ~1.2k | Automated safety check: Pass | MIT | 3 days ago |
| 130 | 130.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 |
| 131 | SQL query optimization and database performance specialist. An agent skill from aiskillstore/marketplace. | aiskillstore/ | 430 | 1 repo | ~787 | Automated safety check: Pass | No licence | yesterday |
| 132 | 132.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 |
| 133 | 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 |
| 134 | 134.Database Admin Comprehensive database administration, schema management, data operations, and optimization. | LeoYeAI/ | 2.2k | — | ~552 | Automated safety check: Pass | MIT | 2 mo ago |
| 135 | Performance optimization patterns for the HMIS project. An agent skill from hmislk/hmis. | hmislk/ | 236 | — | ~499 | Automated safety check: Pass | GPL-3.0 | today |
| 136 | Structured triage recipes for common ClickHouse incidents: disk, errors, replication, mutations, cluster health, and slow queries. | chmonitor/ | 299 | — | ~3.4k | Automated safety check: Pass | GPL-3.0 | 3 days ago |
| 137 | Diagnose a slow or expensive query with EXPLAIN and querylog, then propose concrete rewrites and better join strategies. | chmonitor/ | 299 | — | ~2.4k | Automated safety check: Pass | GPL-3.0 | 3 days ago |
| 138 | 138.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/ | 165 | — | ~4.2k | Automated safety check: Pass | MIT | 4 mo ago |
| 139 | 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 |
| 140 | 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 |
| 141 | 141.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 | yesterday |
| 142 | 142.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 | yesterday |
| 143 | DB schema design and query tuning: normalization, indexing, N+1, transactions, EXPLAIN. | softspark/ | 179 | — | ~2.5k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 144 | Analyze and improve Attio integration latency and throughput from measured query shape, pagination, concurrency, retry, and cache evidence while preserving correctness. | jeremylongshore/ | 2.8k | — | ~975 | Automated safety check: Pass | MIT | today |