query-optimizer

Files

---
name: query-optimizer
description: Analyze and optimize SQL queries
version: 1.2.0
---

# SQL Query Optimizer

Improve query performance with analysis and suggestions.

## Analysis Includes

- Execution plan review
- Index recommendations
- Query rewrite suggestions
- N+1 detection
- Join optimization

## Supported Databases

- PostgreSQL
- MySQL
- SQLite
- SQL Server

## Optimization Types

### Index Suggestions
```sql
-- Suggested index for query
CREATE INDEX idx_users_email ON users(email);
```

### Query Rewrites
```sql
-- Original (slow)
SELECT * FROM orders WHERE customer_id IN 
  (SELECT id FROM customers WHERE country = 'US');

-- Optimized (faster)
SELECT o.* FROM orders o
JOIN customers c ON o.customer_id = c.id
WHERE c.country = 'US';
```

### Anti-Pattern Detection
- SELECT *
- Missing indexes on joins
- Implicit conversions
- Non-sargable predicates