skills.rest
microwind
microwindOFFICIAL
Explore all skills by this author →
Website𝕏@jarryliGitHub

SQL优化器

Analyze SQL execution plans and provide index optimization suggestions for multiple databases.

65|15|Updated Mar 8, 2026
Search Tags:#indexing#sql#query-tuning#analyze#execution-plan#optimizer#db-performance
One-click install
npx skills add https://github.com/microwind/ai-skills --skill sql-microwind
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: SQL优化器
Source: https://github.com/microwind/ai-skills/tree/main/database/sql-optimizer
Command: npx skills add https://github.com/microwind/ai-skills --skill sql-microwind

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

SQL优化器解决慢SQL查询导致的性能问题，通过分析执行计划、检查索引使用、并提供优化建议来提升数据库性能。

Core Features & Use Cases

  • 自动分析执行计划并给出改进建议，覆盖查询分析、索引优化、表结构优化、执行计划优化和统计信息管理等方面。
  • 支持多数据库环境（MySQL、PostgreSQL、Oracle、SQL Server），用于常见场景的性能瓶颈定位和优化。
  • 实时监控与报告能力，帮助数据团队持续优化查询性能并跟踪改进效果。

Quick Start

Provide a SQL query and receive actionable optimization suggestions and execution plan improvements.

Frequently Asked Questions about SQL优化器

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

FAQPage Schema
How do I analyze an execution plan to fix slow SQL queries?▼

To fix slow SQL queries, analyze the execution plan to identify performance bottlenecks, check index usage, and apply optimization suggestions for table structures and query syntax.

Does this SQL query tuning tool support PostgreSQL and Oracle?▼

Yes, SQL query tuning supports multiple database environments including PostgreSQL, Oracle, MySQL, and SQL Server for performance bottleneck location and index design.

What is the best way to optimize indexing for database performance?▼

The best way to optimize indexing for database performance is to analyze execution plans, review query patterns, and implement index suggestions to improve retrieval speed.

How do I start optimizing a slow SQL query?▼

To start optimizing a slow SQL query, provide the SQL statement to receive actionable optimization suggestions, execution plan improvements, and index design guidance automatically.

Why does my SQL execution plan show a full table scan despite indexing?▼

A SQL execution plan may show a full table scan despite indexing due to outdated statistics or inefficient query predicates, requiring execution plan analysis and statistics management.

Related Skills

Explore More Software Engineering Skills→
PriyanshKuniyalPriyanshKuniyal

sql-optimization-patterns

Analyzes SQL queries and applies indexing strategies using EXPLAIN output.

Community
Advanced
JeffallanJeffallan
10.9k

sql-pro

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

Community
Advanced
allthingslinuxallthingslinux
1

database-monitoring

Monitor PostgreSQL and MySQL health with structured queries and alerting rules.

Official
Intermediate
iCesofTiCesofT
1

database-optimizer

Optimize PostgreSQL and MySQL queries with EXPLAIN ANALYZE and index tuning.

Community
Advanced