skills.rest
codeApe-7
codeApe-7COMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/codeApe-7/ai-agent-workflowGroup --skill sql-pro-codeape-7
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Product & Management Skills→
opensage-agentopensage-agent
113

neo4j-query

Execute arbitrary Cypher queries against Neo4j graph databases to retrieve structured JSON records.

Official
Intermediate
mvandermeulenmvandermeulen
2

sql-optimization-patterns

Analyze SQL execution plans and suggest indexing strategies for slow queries.

Community
Advanced
Design-System-ETDesign-System-ET

sql-pro

Optimize SQL queries and database schemas across multiple dialects.

Official
Advanced
DexploarerDexploarer
6

database-query-optimizer

Analyze EXPLAIN plans and recommend indexes for PostgreSQL, MySQL, and MongoDB.

Community
Advanced