Skills
.Work. You
Rest

role-database:query-optimization

Community

Optimize database queries

Software Engineering#query optimization#indexing#database#postgresql#sql#performance tuning#mysql
Authorrnavarych
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill helps diagnose and resolve slow database query performance by providing guidance on analyzing query execution plans and implementing effective indexing strategies across multiple database engines.

Core Features & Use Cases

  • Query Plan Analysis: Understand EXPLAIN output for PostgreSQL, MySQL, MongoDB, and ClickHouse to identify bottlenecks.
  • Index Strategy: Learn best practices for B-tree, Hash, GIN, GiST, BRIN, partial, and covering indexes.
  • Use Case: When a critical report is taking too long to run, use this Skill to analyze the query plan, identify missing indexes, and implement the correct index type to drastically speed up execution.

Quick Start

Analyze the query plan for a slow SQL query using the 'explain-indexes.md' reference.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: role-database:query-optimization
Download link: https://github.com/rnavarych/alpha-engineer/archive/main.zip#role-database-query-optimization

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.