Best query optimization skills, page 2

This skill should be used whenever the user mentions a "semantic model", "data model", or "dataset", or asks to "build", "model", "design", "optimize", "review", or "audit" one, or to "add a…

data-goblin/power-bi-agentic-development

Diagnose and fix common Cartography intel-module errors — ModuleNotFoundError, PropertyRef validation failed, GraphJob failed, missing relationships, MatchLink misses, cleanup deleting too much…

cartography-cncf/cartography

A skill your agent uses when modifying Prisma schema or database queries.

programming-in-th/programming.in.th

PostgreSQL query optimization, JSONB operations, advanced indexing strategies, partitioning, connection management, and database administration.

cin12211/orca-q

Analyze Drift / SQLite slow-query and super-slow-query logs against this app's known stall patterns (read waves, N+1, transaction scoping, MultiExecutor contention, WAL/OS factors)

matthiasn/lotti

Guides creation and modification of ASP.NET Core Web API endpoints with correct HTTP semantics, OpenAPI metadata, and error handling.

dotnet/skills

Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures.

davila7/claude-code-templates

Measures what a ClickHouse query change actually costs, turning a suspicion that a query is slow into numbers a reviewer can act on before it merges.

comet-ml/opik

Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations.

davila7/claude-code-templates

Database schema validation, data integrity testing, migration testing, transaction isolation, and query performance.

proffesor-for-testing/agentic-qe

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

Tunes and administers PostgreSQL: EXPLAIN-driven query tuning, index choice, JSONB, extensions, streaming or logical replication, VACUUM and pg_stat monitoring.

Jeffallan/claude-skills

Writes Apex, Lightning Web Components and SOQL for the Salesforce platform, with bulkified triggers, governor-limit checks, 90% test coverage and Salesforce DX deployment.

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

Develops WordPress themes, plugins, Gutenberg blocks and WooCommerce features with nonce, escaping and capability checks, phpcs linting and caching tuned for speed.

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

Multi-agent code review that checks the current diff from multiple angles (spec compliance, bugs from two lenses, conventions/modernization, abstraction reuse, security, DB query performance, test…

sendou-ink/sendou.ink

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

Manages Amazon DocumentDB end-to-end — serverless-on-8.0 cluster setup, TLS/VPC/driver config, flexible-schema and vector-search data modeling, MongoDB compatibility assessment, DMS-based migration…

aws/agent-toolkit-for-aws

Slow query diagnosis with root cause analysis and index optimization recommendations.

openocta/openocta_skills

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

Prisma ORM patterns for TypeScript backends — schema design, query optimization, transactions, pagination, and critical traps like updateMany returning count not records, $transaction timeouts…

affaan-m/ECC

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

affaan-m/ECC

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

PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.

davila7/claude-code-templates

This skill should be used when the user asks to "audit Eloquent code", "review Eloquent usage", "check model code", "find N+1 queries", "find query performance issues", "Eloquent review", or wants…

LaravelDaily/AI-Workflows-For-Laravel

A skill your agent uses when investigating slow queries, analyzing execution plans, or optimizing database performance.

AratKruglik/claude-laravel

Trigger: "profile Materialize", "check memory usage", "analyze binary size", "debug performance", or mentions profiling, samply, heaptrack, flame graphs, memory checking, binary size, slow queries…

MaterializeInc/materialize

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

codewithmukesh/dotnet-claude-kit

Comprehensive TiDB cluster inspection. An agent skill from openocta/openocta_skills.

openocta/openocta_skills

PostgreSQL expert for query optimization, indexing, extensions, and database administration

RightNow-AI/openfang

SQLite expert for WAL mode, query optimization, embedded patterns, and advanced features

RightNow-AI/openfang

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

Manage the lerd local PHP development environment via MCP tools: run framework console commands (artisan, bin/console, etc.), manage services, start/stop queue workers, run composer, manage Node.js…

liberusoftware/real-estate-laravel

A skill your agent uses when investigating slow queries, analyzing execution plans, or optimizing database performance.

zebbern/claude-code-guide

PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities.

github/awesome-copilot

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

Query optimization, indexing strategies, and database performance tuning for PostgreSQL and MySQL

rohitg00/awesome-claude-code-toolkit

Diagnose slow Elasticsearch Query DSL searches and propose measured fixes.

elastic/agent-skills

Expert guide for diagnosing and fixing Odoo performance issues: slow queries, worker configuration, memory limits, PostgreSQL tuning, and profiling tools.

sickn33/agentic-awesome-skills

Lock an ideation run into a single-source-of-truth brainstorm brief (output/trace/IDEABRIEF.md) and a replayable multi-query plan (queries.md).

WILLOSCAR/research-units-pipeline-skills

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

jamesrochabrun/skills

The method for profiling and optimizing anything whose success is a measured cost — frame the phase and metric, choose an instrument that can actually see the cost, label the waste, falsify the…

happier-dev/happier

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

PostHog/posthog

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

sickn33/agentic-awesome-skills