skills.rest
xiaoyuge886
xiaoyuge886COMMUNITY
Explore all skills by this author →
GitHub

agent-sql-pro

Optimizes complex SQL queries across PostgreSQL, MySQL, SQL Server, and Oracle via execution plan analysis and indexing strategies.

196|20|Updated Jan 17, 2026
Search Tags:#performance#indexing#database#optimization#sql#query
One-click install
npx skills add https://github.com/xiaoyuge886/aigc --skill agent-sql-pro
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: agent-sql-pro
Source: https://github.com/xiaoyuge886/aigc/tree/main/.claude/skills/agent-sql-pro
Command: npx skills add https://github.com/xiaoyuge886/aigc --skill agent-sql-pro

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill addresses the complexity of writing, optimizing, and maintaining high-performance SQL queries across diverse database systems, preventing common bottlenecks and ensuring data integrity.

Core Features & Use Cases

  • Query Optimization: Analyzes execution plans to reduce query latency to under 100ms.
  • Database Architecture: Provides expert guidance on indexing strategies, deadlock prevention, and schema design.
  • Use Case: When a production database experiences slow performance, use this Skill to identify missing indexes and refactor complex joins into efficient, scalable SQL statements.

Quick Start

Use the agent-sql-pro skill to analyze the execution plan and optimize the performance of the provided complex join query.

Frequently Asked Questions about agent-sql-pro

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

FAQPage Schema
How do I optimize complex SQL queries experiencing slow performance in production?▼

Query optimization involves analyzing execution plans to identify missing indexes and refactor complex joins, reducing query latency to under 100ms for production database environments.

What is the best way to design indexing strategies across different database systems?▼

Indexing strategies require expert guidance on schema design and deadlock prevention, ensuring ANSI SQL compliance and data integrity across PostgreSQL, MySQL, SQL Server, and Oracle environments.

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

Yes, this approach supports SQL optimization across PostgreSQL, MySQL, SQL Server, and Oracle environments, ensuring ANSI SQL compliance and robust database architecture tuning.

How do I analyze an execution plan to reduce SQL query latency?▼

Analyze execution plans by identifying performance bottlenecks and missing indexes, then refactoring complex joins into scalable SQL statements to reduce query latency to under 100ms.

Why does my production database experience slow performance during complex joins?▼

Production database slow performance often stems from missing indexes and inefficient complex joins, requiring execution plan analysis and database architecture tuning to restore system scalability and data integrity.

Related Skills

Explore More Software Engineering Skills→
lamb92009lamb92009

sql-pro

Analyze SQL execution plans and optimize queries across PostgreSQL, MySQL, SQL Server, and Oracle.

Community
Advanced
pacphipacphi
6

performance-testing

Plan and execute load, stress, spike, endurance, and scalability tests.

Community
Advanced
RightNow-AIRightNow-AI
18.1k

postgres-expert

Analyze PostgreSQL query plans and recommend indexing strategies.

Official
Advanced
Archive228Archive228
746

sql-review

Reviews SQL and ORM queries for injection risks, missing indexes, and bottlenecks.

Community
Intermediate