SQL · Query optimization

Benchmarks Django ORM filters in Saleor by generating bulk data, extracting the SQL and running EXPLAIN ANALYZE to check index usage.

saleor/saleor

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.

ynulihao/AgentSkillOS

PostgreSQL database documentation - SQL queries, database design, administration, performance tuning, and advanced features. Use when working with…

2025Emma/vibe-coding-cn

Specialized skill for working in the fdb-relational-core SQL processing layer — parser, plan generator, and Cascades planner.

FoundationDB/fdb-record-layer

Query ClickHouse system tables to inspect query logs, monitor cluster health, check replication status, and analyze slow queries.

FrankChen021/datastoria

Query Finelog logs and telemetry for Iris tasks, workers, profiles, training, vLLM, and cross-cluster forwarding.

marin-community/marin

Domain-first store/port design for any codebase: product-shaped APIs, swappable backends, schema at boundaries, one vocabulary catalog (derive don’t re-author), no infrastructure names on the domain…

TryCaspian/caspian-sdk

Design, refactor and diagnose Paro's staged optimizer, using EXPLAIN COMPILE for planning and EXPLAIN ANALYZE for execution.

zunor/paro

SQL query engine design and implementation guide. An agent skill from revfactory/claude-code-harness.

revfactory/claude-code-harness

Load this FIRST whenever working with PyTorch CI data (any pytorch/ org repo), the torchci/HUD codebase, or the PyTorch HUD ClickHouse database.

pytorch/test-infra

Design database schemas with Prisma/Drizzle, PostgreSQL index strategy (B-tree, GIN, GiST, BRIN, Hash), query optimization (EXPLAIN ANALYZE), migration safety (expand/contract, zero-downtime), and…

EliasOulkadi/shokunin

CloudBase PostgreSQL access-pattern and slow-query quality guidance.

TencentCloudBase/CloudBase-AI-Toolkit

Tunes PostgreSQL and MySQL performance by analyzing slow queries and execution plans, designing indexes, rewriting queries and adjusting configuration, one validated change at a time.

Jeffallan/claude-skills

Optimizes SQL queries and designs schemas using CTEs, window functions, covering indexes and EXPLAIN ANALYZE, with notes on dialect differences between major databases.

Jeffallan/claude-skills

Ranks the costliest, slowest or heaviest-scanning Snowflake queries from query history and suggests how to optimize them.

AltimateAI/data-engineering-skills

Rules for writing Tinybird datasources, pipes, endpoints and materialized views, with SQL constraints, optimization habits and deduplication patterns.

TryGhost/Ghost

Optimize slow queries, analyze SQL performance, and collect evidence for expensive workloads.

FrankChen021/datastoria

Translate natural language to SQL, optimize query performance, and interpret EXPLAIN plans for SQLite and PostgreSQL.

zebbern/claude-code-guide

当代码涉及循环内查询、批量 ID 查询、IN 子句、BFS/递归遍历、嵌套 service 调用时触发。防止 N+1 查询、IN 子句过长、递归内存炸裂等性能陷阱。

doccker/cc-use-exp

Automatically discover database skills when working with SQL, PostgreSQL, MongoDB, Redis, database schema design, query optimization, migrations, connection pooling, ORMs, or database selection.

rand/cc-polymath

Entity Framework Core patterns for .NET 10. An agent skill from codewithmukesh/dotnet-claude-kit.

codewithmukesh/dotnet-claude-kit

Provisions and manages Aurora DSQL clusters, connects via psql or DSQL Connectors, manages schemas, runs queries, migrates from MySQL, diagnoses query plans, and develops apps on serverless…

aws/agent-toolkit-for-aws

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server…

github/awesome-copilot

Optimizes Snowflake query performance using query ID from history.

AltimateAI/data-engineering-skills

Master SQL and database queries across multiple systems. An agent skill from jamesrochabrun/skills.

jamesrochabrun/skills

Diagnose slow SQL with query plans, preserve query results, and verify indexing or query changes against representative data.

sickn33/agentic-awesome-skills

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

PostHog/posthog

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

ancoleman/ai-design-components

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-plugins

Set up Grafana Cloud Database Observability for MySQL and PostgreSQL — enables pgstatstatements / Performance Schema, creates a least-privilege monitoring user, configures the…

grafana/skills

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

mizchi/skills

Execute use when you need to work with query optimization. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Optimizes Snowflake SQL query performance from provided query text.

AltimateAI/data-engineering-skills

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-Skills

A Data Engineering interviewer focused on database performance.

PrepLabsAI/InterviewMentor

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

xiaoyuge886/aigc

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-skills

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

rileyhilliard/claude-essentials

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

aiskillstore/marketplace

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

lazyFrogLOL/Harness_Engineering

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-dotnetcc

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

petrkindlmann/qa-skills

Deep Supabase diagnostics: pgstatstatements for slow queries, lock debugging with pglocks, connection leak detection, RLS policy conflicts, Edge Function cold starts, and Realtime connection drop…

jeremylongshore/tons-of-skills-marketplace

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

Mathews-Tom/armory

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-harness

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-harness

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-harness

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

aiskillstore/marketplace