db-query-analyzerlisted
Install: claude install-skill a5c-ai/babysitter
# 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"
}