SQL优化器

Name: SQL优化器
Availability: InStock
Author: microwind

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

Ready to run

npx skills add https://github.com/microwind/ai-skills --skill sql-microwind

💬 Prompt for ChatGPT / Claude Chat▼

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.