skills.rest
fanguyun
fanguyunCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sql-pro

Optimize SQL queries and design schemas for PostgreSQL, MySQL, SQL Server, and Oracle.

Updated May 31, 2026
Search Tags:#database design#query optimization#postgresql#sql#oracle#performance tuning#mysql#sql server#window functions#ctes
One-click install
npx skills add https://github.com/fanguyun/SkillManager --skill sql-pro-fanguyun
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/fanguyun/SkillManager/tree/main/sql-pro
Command: npx skills add https://github.com/fanguyun/SkillManager --skill sql-pro-fanguyun

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psycopg2, mysql-connector-python, pyodbc, cx_Oracle, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides comprehensive SQL query optimization, database schema design, and performance troubleshooting for SQL databases.

Core Features & Use Cases

  • SQL Query Optimization: Analyze and optimize SQL queries for performance.
  • Database Schema Design: Design efficient database schemas and troubleshoot performance issues.
  • Use Case: When a user has a slow SQL query and needs assistance, this Skill can help identify the issue and suggest improvements.

Quick Start

Use the sql-pro skill to analyze and optimize the query 'SELECT * FROM orders WHERE order_date > CURRENT_DATE - INTERVAL 30 days'.

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 query plan analysis?▼

SQL query optimization analyzes execution plans to identify bottlenecks and suggests indexing strategies or query rewrites to improve performance. It targets complex queries, window functions, and CTEs.

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

Database schema design structures tables and relationships to minimize latency and storage overhead. Efficient schemas prevent performance issues before they occur by optimizing data access patterns.

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

Yes, this approach optimizes queries and troubleshoots performance issues across PostgreSQL, MySQL, SQL Server, and Oracle. It requires Python and relevant database drivers for execution.

How do I troubleshoot performance issues with recursive queries and CTEs?▼

Troubleshooting recursive queries involves analyzing query plans and restructuring CTEs to reduce computational overhead. The Skill identifies inefficient execution paths and recommends indexing strategies.

Do I need Python database drivers to analyze SQL query performance?▼

Yes, execution requires Python and specific database drivers like psycopg2, mysql-connector-python, pyodbc, or cx_Oracle to connect and run query plan analysis.

Related Skills

Explore More Software Engineering Skills→
wfukatsuwfukatsu
12

analyze-mysql-schema

Extract MySQL database schema details and generate Markdown reports.

Community
Advanced
Lautaro073Lautaro073

sql-optimization-patterns

Identify and optimize inefficient SQL queries across PostgreSQL and MySQL.

Community
Advanced
HeldinhowHeldinhow
4

database-migrations

Manage database schema changes through version-controlled migration scripts.

Community
Intermediate
Camilo8902Camilo8902

sql-query-optimizer

Analyze SQL execution plans and recommend indexes and rewrites to optimize queries.

Community
Advanced