How does the skill analyze query bottlenecks?

It uses EXPLAIN ANALYZE to inspect the query execution plan, identifying high-cost nodes, sequential scans on large tables, and discrepancies between estimated and actual row counts.

Can this skill help fix performance issues in ORMs?

Yes, it includes specific logic to detect and resolve N+1 query problems in popular frameworks like Django, SQLAlchemy, Sequelize, and TypeORM.

Does it suggest specific index types?

Yes, it can recommend B-Tree indexes, composite indexes for specific query patterns, partial indexes for filtered datasets, and covering indexes to minimize table lookups.

Can I use this for MongoDB aggregation pipelines?

Yes, the skill includes support for MongoDB's executionStats to identify COLLSCAN stages and suggest appropriate multikey or compound indexes.

Which database engines are supported by this skill?

The skill provides specific optimization strategies, EXPLAIN plan analysis, and indexing suggestions for PostgreSQL, MySQL, and MongoDB.

Database Query Optimizer

Name: Database Query Optimizer
Author: Dexploarer

byDexploarer

•

Database Management

Analyzes and optimizes database queries for PostgreSQL, MySQL, and MongoDB using EXPLAIN plans and automated index recommendations.

The Database Query Optimizer is a specialized performance skill for Claude Code that identifies and resolves database bottlenecks. It provides deep analysis of execution plans, detects inefficient N+1 query patterns in popular ORMs like Django and Sequelize, and suggests precise indexing strategies to reduce query latency. By interpreting EXPLAIN ANALYZE output and identifying red flags like sequential scans or high-cost operations, this skill helps developers refactor slow queries into high-performance SQL and NoSQL operations.

Key Features

01Comprehensive EXPLAIN and EXPLAIN ANALYZE plan interpretation

022 GitHub stars

03Intelligent index suggestions including composite, partial, and covering indexes

04Performance monitoring scripts for PostgreSQL, MySQL, and MongoDB

05Query refactoring strategies to eliminate subqueries and optimize joins

06Automated detection and fixing of N+1 query patterns in various ORMs

Use Cases

01Optimizing application data layers to prevent database over-fetching

02Designing efficient indexing strategies for new or existing schemas

03Troubleshooting and fixing slow-running production queries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dexploarer/claudius-skills database-query-optimizer

For use in Claude.ai and ChatGPT

Download Skill