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

{
  "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"
        }
      }
    }
  }
}