skills.rest
dieu-donnee
dieu-donneeCOMMUNITY
Explore all skills by this author →
GitHub

sql-pro

Diagnose SQL performance issues by analyzing queries, plans, and schema structures.

Updated Jan 9, 2026
Search Tags:#performance#indexing#optimization#queries#sql#execution-plan#dialects
One-click install
npx skills add https://github.com/dieu-donnee/luxtrax --skill sql-pro-dieu-donnee
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/dieu-donnee/luxtrax/tree/main/.agent/skills/sql-pro
Command: npx skills add https://github.com/dieu-donnee/luxtrax --skill sql-pro-dieu-donnee

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

SQL performance issues and complex design challenges slow development and degrade user experience; this skill provides structured guidance to diagnose, optimize, and migrate SQL queries and schemas.

Core Features & Use Cases

  • Analyze and optimize queries with execution plans, window functions, and CTEs.
  • Design schemas and migrations across PostgreSQL, MySQL, SQL Server, and Oracle.
  • Provide actionable benchmarks, index strategies, and dialect-aware recommendations.
  • Use cases: slow queries, complex joins, migrating dialects, and schema redesigns.

Quick Start

Provide an optimized rewrite plan for the given slow query, including index recommendations, plan adjustments, and dialect-specific changes.

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 using execution plans?▼

You can optimize slow SQL queries by analyzing execution plans to identify bottlenecks, then applying targeted index creation and query rewriting. This skill diagnoses performance issues across PostgreSQL, MySQL, SQL Server, and Oracle to provide structured optimization recommendations.

Can I use this to migrate SQL schemas across different database dialects?▼

Yes, you can use this to migrate SQL schemas across PostgreSQL, MySQL, SQL Server, and Oracle. It provides dialect-aware schema design recommendations and query translations to ensure cross-database compatibility during complex migrations.

What is the best way to design indexing strategies for complex SQL joins?▼

Designing indexing strategies for complex joins requires analyzing execution plans and schema structures to identify optimal index placement. This skill provides actionable index recommendations and query rewrites tailored to your specific database dialect to resolve performance issues.

Does this skill support optimizing window functions and CTEs in PostgreSQL?▼

Yes, this skill supports optimizing window functions and CTEs in PostgreSQL. It analyzes these complex query structures within execution plans and provides dialect-aware recommendations for index creation and query rewriting to improve overall response times.

Why does my SQL query performance degrade when migrating from MySQL to SQL Server?▼

SQL query performance often degrades during dialect migration due to differences in execution plan generation and indexing mechanisms across MySQL and SQL Server. This skill diagnoses these issues by providing dialect-aware schema design and query rewriting to optimize cross-platform performance.

Related Skills

Explore More Software Engineering Skills→
UdaradgUdaradg

sql-optimization

Optimize slow SQL queries across MySQL, PostgreSQL, SQL Server, and Oracle.

Community
Intermediate
HieubkavHieubkav

database-performance

Analyze database indexes and query execution plans to recommend optimizations.

Community
Advanced
4lerman4lerman

sql-database-assistant

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

Community
Advanced
erikhowarderikhoward

database-optimizer

Analyze execution plans and tune queries, indexes, and caching across PostgreSQL, MySQL, and SQL Server.

Community
Advanced