Sql Optimization Patterns
Skill Verified ActiveMaster SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
To empower users to dramatically improve database performance by mastering SQL query optimization, indexing strategies, and EXPLAIN analysis, leading to faster applications and reduced costs.
Features
- Master SQL query optimization techniques
- Implement effective indexing strategies
- Analyze EXPLAIN query plans for PostgreSQL
- Optimize common query patterns (N+1, pagination, aggregation)
- Learn advanced techniques like materialized views and partitioning
Use Cases
- Debugging slow-running SQL queries
- Designing performant database schemas
- Optimizing application response times
- Reducing database load and costs
Non-Goals
- Writing specific SQL queries for a given database
- Providing database administration services
- Tuning non-SQL database performance
Documentation
- info:READMEThe README exists and is comprehensive, but its primary focus is on the overall plugin ecosystem rather than this specific SQL optimization skill. The SKILL.md file serves as the primary documentation for this skill.
Installation
First, add the marketplace
/plugin marketplace add wshobson/agents/plugin install developer-essentials@claude-code-workflowsQuality Score
VerifiedTrust Signals
Similar Extensions
Sql Optimization
100Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.
MongoDB Connection Optimizer
100Optimize MongoDB client connection configuration (pools, timeouts, patterns) for any supported driver language. Use this skill when working/updating/reviewing on functions that instantiate or configure a MongoDB client (eg, when calling `connect()`), configuring connection pools, troubleshooting connection errors (ECONNREFUSED, timeouts, pool exhaustion), optimizing performance issues related to connections. This includes scenarios like building serverless functions with MongoDB, creating API endpoints that use MongoDB, optimizing high-traffic MongoDB applications, creating long-running tasks and concurrency, or debugging connection-related failures.
Dsql
100Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices
DBHub Database Query Guide
100Guide for querying databases through DBHub MCP server. Use this skill whenever you need to explore database schemas, inspect tables, or run SQL queries via DBHub's MCP tools (search_objects, execute_sql). Activates on any database query task, schema exploration, data retrieval, or SQL execution through MCP — even if the user just says "check the database" or "find me some data." This skill ensures you follow the correct explore-first workflow instead of guessing table structures.
Performance Analysis
100Comprehensive performance analysis, bottleneck detection, and optimization recommendations for Claude Flow swarms