db-query-analyzer

# Database Query Analyzer Skill ## Overview Analyzes database query performance including execution plan analysis, index recommendations, slow query identification, and optimization suggestions. ## Capabilities - Query execution plan analysis - Index recommendation - Slow query identification - Query optimization suggestions - Table scan detection - Join optimization analysis - Support for PostgreSQL, MySQL, SQL Server ## Target Processes - performance-optimization - data-architecture-design ## Input Schema ```json { "type": "object", "required": ["queries"], "properties": { "queries": { "type": "array", "items": { "type": "object", "properties": { "sql": { "type": "string" }, "name": { "type": "string" } } } }, "database": { "type": "string", "enum": ["postgresql", "mysql", "sqlserver", "oracle"], "default": "postgresql" }, "connectionString": { "type": "string", "description": "Database connection string (optional, for live analysis)" }, "options": { "type": "object", "properties": { "analyzeExplain": { "type": "boolean", "default": true }, "suggestIndexes": { "type": "boolean", "default": true }, "slowQueryThreshold": { "type": "number", "default": 1000, "description": "Slow query threshold in milliseconds" } ...