sql-pro

Analyze SQL execution plans and suggest indexing strategies.

17|3|Updated Mar 18, 2026

Search Tags:#indexing #schema design #database #optimization #sql #query tuning

Ready to run

npx skills add https://github.com/codeApe-7/ai-agent-workflowGroup --skill sql-pro-codeape-7

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sql-pro
Source: https://github.com/codeApe-7/ai-agent-workflowGroup/tree/main/skills/database/sql-pro
Command: npx skills add https://github.com/codeApe-7/ai-agent-workflowGroup --skill sql-pro-codeape-7

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psycopg2, pymysql, pyodbc, cx_Oracle, and includes references (resource) and scripts (resource) components.

What problem does it solve?

This Skill helps diagnose, optimize, and troubleshoot SQL queries to improve database performance and efficiency.

Core Features & Use Cases

Query Optimization: Analyzes execution plans, suggests indexing, and refines queries for faster response times.
Database Design Advice: Offers normalization examples, key constraints, and schema best practices for reliable data structuring.
Use Case: When a user reports slow query performance, this Skill provides optimized query versions, index recommendations, and explains execution plans to improve database throughput.

Quick Start

Request the system to analyze the slow-running query and suggest 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 query performance using execution plans?▼

To optimize slow SQL query performance, this Skill analyzes execution plans to identify bottlenecks and refines queries with indexing strategies for faster database response times. It explains execution plans to improve overall database throughput.

What's the best way to design a database schema for normalization and constraints?▼

The best way to design a normalized database schema is by applying key constraints and schema best practices for reliable data structuring. This Skill offers normalization examples and database design advice to ensure efficient data organization.

Does this SQL query tuning tool support different database dialects?▼

Yes, this SQL query tuning tool supports various SQL dialects. It provides query plan analysis, execution tuning, and schema best practices tailored to multiple database environments using dependencies like psycopg2, pymysql, pyodbc, and cx_Oracle.

How do I know which indexing strategy to use for database optimization?▼

To determine the right indexing strategy for database optimization, this Skill requires an understanding of indexing, query patterns, and database constraints. It analyzes your specific query patterns to suggest targeted index recommendations.

When should I not use schema normalization for my database?▼

Schema normalization may not be ideal when your database queries require highly denormalized data for read-heavy performance. While this Skill provides normalization examples and key constraints, you must weigh reliable data structuring against specific query tuning needs.