skills.rest
AndrejMX13
AndrejMX13COMMUNITY
Explore all skills by this author →
GitHub

sql-pro

Optimize SQL queries and design schemas for relational databases.

Updated May 3, 2026
Search Tags:#performance#database design#query optimization#indexing#postgresql#sql#mysql
One-click install
npx skills add https://github.com/AndrejMX13/belpro --skill sql-pro-andrejmx13
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/AndrejMX13/belpro/tree/main/.claude/skills/sql-pro
Command: npx skills add https://github.com/AndrejMX13/belpro --skill sql-pro-andrejmx13

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and scripts (resource) components.

What problem does it solve?

This Skill streamlines SQL query optimization, improves database performance, and assists in designing efficient schemas, reducing troubleshooting time.

Core Features & Use Cases

  • Query Troubleshooting: Analyze slow or inefficient queries to identify performance bottlenecks.
  • Schema Design: Assist in creating normalized, efficient database schemas suitable for various SQL dialects.
  • Use Case: Imagine a developer needs to optimize a complex join across large tables. Use this Skill to generate an explanation, index strategies, and optimized query examples to speed up report generation.

Quick Start

Use the sql-pro skill to analyze the execution plan of your PostgreSQL query to identify indexing improvements.

Frequently Asked Questions about sql-pro

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow SQL queries with complex joins?▼

To optimize slow SQL queries, you must analyze execution plans to identify bottlenecks and apply targeted indexing strategies. This approach isolates inefficiencies in complex joins across large tables to significantly speed up report generation.

Does this SQL optimization approach work with MySQL and PostgreSQL?▼

Yes, this SQL optimization approach works with MySQL and PostgreSQL, alongside SQL Server and Oracle. It leverages platform-specific features and indexing strategies to ensure efficient database operations across these major relational database dialects.

What is the best way to design a database schema for performance?▼

The best way to design a database schema for performance is to create normalized structures tailored to your specific SQL dialect. Proper schema design reduces data redundancy and complements query optimization by ensuring efficient data retrieval.

How do I interpret an execution plan to improve database indexing?▼

Interpreting an execution plan requires examining the query steps to identify full table scans or inefficient joins. By analyzing these steps, you can implement targeted indexing strategies that drastically improve database performance.

Do I need familiarity with SQL dialects to use execution plan analysis?▼

Yes, you need familiarity with SQL dialects and performance analysis tools to interpret execution plans effectively. This prerequisite knowledge allows you to understand platform-specific features and apply the correct optimization strategies.

Related Skills

Explore More Software Engineering Skills→
JeffallanJeffallan
10.9k

database-optimizer

Diagnose slow queries and optimize indexes for PostgreSQL and MySQL.

Community
Advanced
mohamedgshoaibmohamedgshoaib
5

supabase-performance-tuning

Diagnose and optimize PostgreSQL and Supabase query performance with pg_stat_statements.

Community
Advanced
4lerman4lerman

sql-database-assistant

Generate SQL queries, introspect schemas, optimize performance, and create migration scripts.

Community
Advanced
tomasbassotomasbasso

arquitectura-esquemas-base-de-datos

Designs relational and non-relational database schemas with normalization, indexing, migration planning, and Mermaid ERD output.

Community
Intermediate