mcpField
S
sql-optimization-patterns

sql-optimization-patterns

github.com/rmyndharisData & databases1.9k61 installsUpdated 2w ago
Repository

About sql-optimization-patterns

A skill for diagnosing and improving SQL query and schema performance. It is aimed at developers working on slow queries, database load, and scalability, with guidance that includes index design and EXPLAIN plan analysis.

Key features

  1. 01Slow-query diagnosis
  2. 02Schema performance guidance
  3. 03Index design
  4. 04EXPLAIN plan analysis
  5. 05N+1 query resolution

Use cases

  1. 01Investigating a slow-running query
  2. 02Reducing database load in an application
  3. 03Improving schema performance for larger datasets

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/rmyndharis/antigravity-skills --skill sql-optimization-patterns

After installing, type/sql-optimization-patternsin Claude Code to confirm it loaded.

Bundled filesresources/implementation-playbook.md

Details

From the project README

SQL Optimization Patterns

Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.

Use this skill when

  • Debugging slow-running queries
  • Designing performant database schemas
  • Optimizing application response times
  • Reducing database load and costs
  • Improving scalability for growing datasets
  • Analyzing EXPLAIN query plans
  • Implementing efficient indexes
  • Resolving N+1 query problems

Do not use this skill when

  • The task is unrelated to sql optimization patterns
  • You need a different domain or tool outside this scope

Instructions

  • Clarify goals, constraints, and required inputs.
  • Apply relevant best practices and validate outcomes.
  • Provide actionable steps and verification.
  • If detailed examples are required, open resources/implementation-playbook.md.

Resources

  • resources/implementation-playbook.md for detailed patterns and examples.

Comments

Markdown supported