home/categories/database-tools/dexploarer-claudius-skills-examples-intermediate-performance-skills-database-query-optimizer-skill-md
database-toolsdatabases

database-query-optimizer

Analyzes and optimizes database queries for PostgreSQL, MySQL, MongoDB with EXPLAIN plans, index suggestions, and N+1 query detection. Use when user asks to "optimize query", "analyze EXPLAIN plan", "fix slow queries", or "suggest database indexes".

Dexploarer
maintainer
Dexploarer
Updated 11/1/2025
Stars
5
Forks
2
quick start

Installation and usage

Analyzes and optimizes database queries for PostgreSQL, MySQL, MongoDB with EXPLAIN plans, index suggestions, and N+1 query detection. Use when user asks to "optimize query", "analyze EXPLAIN plan", "fix slow queries", or "suggest database indexes".

Installation
$ install --globalskills.sh
Usage

Once installed, you can use this skill by running the following command in your terminal:

skills use database-query-optimizer