Analyze Db Db Optimize Comprehensive database performance optimization with intelligent analysis and automated improvements
codeferreira 0 스타 2026. 3. 10.
카테고리 데이터 엔지니어링 <codex_skill_adapter>
A. Skill Invocation
This skill is invoked by mentioning $analyze-db-db-optimize.
Treat all user text after $analyze-db-db-optimize as {{SC_ARGS}}.
If no arguments are present, treat {{SC_ARGS}} as empty.
B. Claude Command Translation
This skill is a Codex-native port of the Claude command tree and SuperClaude framework.
Translate Claude spawn_agent(...) patterns to Codex spawn_agent(...).
Translate Claude planning/checklist language to Codex update_plan.
Prefer existing Codex MCP servers from config.toml when the original command mentions MCP.
C. Compatibility Notes
Original command: analyze:db:db-optimize.
Codex invocation: $analyze-db-db-optimize.
빠른 설치
Analyze Db Db Optimize npx skillvault add codeferreira/codeferreira-dotfiles-codex-codex-skills-analyze-db-db-optimize-skill-md
스타 0
업데이트 2026. 3. 10.
직업
Preserve the behavioral intent of the source command, but use Codex-native tools and collaboration primitives.
</codex_skill_adapter>
Context
Your spawn_agent CRITICAL: Deploy 9-12 parallel sub-agents IMMEDIATELY for ultra-fast database optimization. Sequential analysis is OBSOLETE.
Perform comprehensive database performance optimization for {{SC_ARGS}} using 9-12x faster parallel analysis.
Expected speedup: 9-12x faster than traditional sequential optimization.
STEP 1: Instant Parallel Database Discovery and Analysis
IMMEDIATELY LAUNCH 10 PARALLEL AGENTS for comprehensive database system discovery:
[Deploy all agents in single response - NO sequential execution]
Agent 1: Connection Discovery : Find all database connections, test connectivity, gather credentialsAgent 2: Schema Analyzer : Map all tables, views, materialized views, indexes, constraintsAgent 3: Query Performance Scanner : Identify slow queries, missing indexes, N+1 problemsAgent 4: Configuration Auditor : Analyze database settings, memory allocation, connection poolsAgent 5: Storage Optimizer : Check table sizes, bloat, fragmentation, partition opportunitiesAgent 6: Statistics Analyzer : Review table statistics, histogram accuracy, cardinality estimatesAgent 7: Lock & Concurrency Detector : Find blocking queries, deadlocks, lock contentionAgent 8: Replication & Backup Auditor : Check lag, backup schedules, recovery readinessAgent 9: Security Scanner : Analyze permissions, exposed data, encryption statusAgent 10: Monitoring Gap Finder : Identify missing metrics, alerts, performance baselines CRITICAL: All agents execute simultaneously. Zero waiting between agent launches.
STEP 2: Database-Specific Deep Optimization (Parallel)
IF PostgreSQL detected:
SPAWN 10 SPECIALIZED POSTGRES AGENTS NOW :
PG-Agent-1 : Analyze pg_stat_statements for query patternsPG-Agent-2 : Optimize autovacuum settings and bloatPG-Agent-3 : Index usage analysis with pg_stat_user_indexesPG-Agent-4 : Connection pool and pgbouncer optimizationPG-Agent-5 : Partition strategy recommendationsPG-Agent-6 : WAL and checkpoint tuningPG-Agent-7 : Extension usage optimization (pg_stat_statements, etc.)PG-Agent-8 : Query plan analysis for top queriesPG-Agent-9 : Memory settings optimization (shared_buffers, work_mem)PG-Agent-10 : Parallel query execution tuning IF MySQL/MariaDB detected:
LAUNCH 10 MYSQL OPTIMIZATION AGENTS :
MySQL-Agent-1 : InnoDB buffer pool optimizationMySQL-Agent-2 : Query cache and performance schema analysisMySQL-Agent-3 : Index cardinality and selectivity analysisMySQL-Agent-4 : Binary log and replication optimizationMySQL-Agent-5 : Thread pool and connection handlingMySQL-Agent-6 : Temporary table and sort buffer tuningMySQL-Agent-7 : Partition pruning opportunitiesMySQL-Agent-8 : Storage engine optimizationMySQL-Agent-9 : Join buffer and query optimizer hintsMySQL-Agent-10 : Slow query log deep analysis IF MongoDB detected:
DEPLOY 10 MONGODB SPECIALISTS :
Mongo-Agent-1 : Collection scan eliminationMongo-Agent-2 : Index intersection opportunitiesMongo-Agent-3 : Aggregation pipeline optimizationMongo-Agent-4 : Working set size analysisMongo-Agent-5 : Shard key effectivenessMongo-Agent-6 : WiredTiger cache optimizationMongo-Agent-7 : Read preference and write concern tuningMongo-Agent-8 : Connection pool sizingMongo-Agent-9 : Profiler data deep analysisMongo-Agent-10 : Replica set configuration optimization CRITICAL: Database-specific agents run in parallel with discovery agents. Total 20+ agents working simultaneously.
STEP 3: Parallel Risk Assessment and Optimization Strategy
DEPLOY 12 RISK ASSESSMENT AGENTS IMMEDIATELY :
[All agents launch simultaneously for instant comprehensive analysis]
Risk-Agent-1 : Production impact analyzer - downtime requirements, business hoursRisk-Agent-2 : Data integrity validator - constraint violations, data loss risksRisk-Agent-3 : Performance regression detector - identify potential slowdownsRisk-Agent-4 : Rollback strategy planner - create instant recovery proceduresRisk-Agent-5 : Index impact calculator - write performance vs read gainsRisk-Agent-6 : Memory pressure analyzer - resource competition risksRisk-Agent-7 : Replication lag predictor - impact on read replicasRisk-Agent-8 : Lock escalation analyzer - concurrency impact assessmentRisk-Agent-9 : Cost-benefit analyzer - implementation effort vs gainsRisk-Agent-10 : Dependency mapper - application code impact analysisRisk-Agent-11 : Maintenance window optimizer - minimal disruption schedulingRisk-Agent-12 : Compliance checker - regulatory and audit requirements CRITICAL: Risk assessment happens in parallel with optimization discovery. No sequential delays.
STEP 4: Parallel Implementation Orchestration
LAUNCH 10 IMPLEMENTATION AGENTS FOR SAFE PARALLEL EXECUTION :
[Coordinate parallel but safe implementation]
Impl-Agent-1 : Online index creator - CREATE INDEX CONCURRENTLY coordinatorImpl-Agent-2 : Statistics updater - ANALYZE and histogram refresherImpl-Agent-3 : Configuration optimizer - parameter tuning with restart coordinationImpl-Agent-4 : Partition manager - online partition creation and managementImpl-Agent-5 : Vacuum coordinator - bloat removal without blockingImpl-Agent-6 : Cache warmer - preload critical data after changesImpl-Agent-7 : Connection pool tuner - dynamic pool sizingImpl-Agent-8 : Query hint injector - optimizer hint deploymentImpl-Agent-9 : Monitoring enabler - activate performance trackingImpl-Agent-10 : Rollback guardian - continuous validation and instant rollback Session state tracking for coordinated implementation:
{
"implementationPhase": "indexing|statistics|configuration|validation",
"parallelOperations": ["index_users_email", "analyze_orders", "vacuum_products"],
"completedOperations": [],
"rollbackQueue": [],
"performanceBaseline": {}
}
STEP 5: Real-time Validation Network
SPAWN 10 VALIDATION AGENTS FOR CONTINUOUS MONITORING :
Validation-Agent-1 : Query performance comparator - before/after analysisValidation-Agent-2 : Index usage verifier - confirm optimizer adoptionValidation-Agent-3 : Resource utilization monitor - CPU/memory/IO trackingValidation-Agent-4 : Error rate analyzer - detect new failuresValidation-Agent-5 : Connection pool monitor - saturation detectionValidation-Agent-6 : Replication health checker - lag monitoringValidation-Agent-7 : Lock contention tracker - deadlock detectionValidation-Agent-8 : Cache hit rate analyzer - efficiency validationValidation-Agent-9 : Transaction throughput meter - TPS comparisonValidation-Agent-10 : Application latency tracker - end-user impact CRITICAL: Validation agents run continuously during implementation. Real-time feedback loop.
STEP 6: Parallel Monitoring Infrastructure Deployment
INSTANTLY DEPLOY 10 MONITORING SETUP AGENTS :
[All monitoring agents work simultaneously]
Monitor-Agent-1 : Query performance dashboard generator - real-time slow query trackingMonitor-Agent-2 : Resource utilization alerting - CPU/memory/disk thresholdsMonitor-Agent-3 : Replication monitoring setup - lag alerts and health checksMonitor-Agent-4 : Lock monitoring framework - deadlock detection and alertingMonitor-Agent-5 : Index effectiveness tracker - usage patterns and efficiencyMonitor-Agent-6 : Connection pool analyzer - saturation and timeout trackingMonitor-Agent-7 : Cache performance monitor - hit rates and eviction patternsMonitor-Agent-8 : Capacity planning analyzer - growth trends and forecastingMonitor-Agent-9 : Anomaly detection setup - baseline deviation alertsMonitor-Agent-10 : Automated maintenance scheduler - vacuum, analyze, optimize CRITICAL: Complete monitoring infrastructure deployed in parallel. 10x faster setup.
STEP 7: Comprehensive Optimization Report Generation
DEPLOY FINAL 8 REPORTING AGENTS FOR INSTANT DOCUMENTATION :
Report-Agent-1 : Executive summary generator - ROI and performance gainsReport-Agent-2 : Technical deep-dive documenter - implementation detailsReport-Agent-3 : Before/after comparator - metrics and benchmarksReport-Agent-4 : Rollback procedure compiler - emergency response guideReport-Agent-5 : Future optimization roadmap - next steps and recommendationsReport-Agent-6 : Monitoring guide creator - dashboard and alert documentationReport-Agent-7 : Maintenance schedule generator - automated task calendarReport-Agent-8 : Knowledge base updater - lessons learned and best practices Performance Metrics Summary:
Analysis Speed : 9-12x faster with 52+ parallel agentsCoverage : 100% of database aspects analyzed simultaneouslyImplementation Safety : Parallel execution with coordinated rollbackTime to Value : Minutes instead of hours for complete optimizationOngoing Monitoring : Automated infrastructure deployed instantly STEP 8: State Management and Session Completion
// /tmp/db-optimize-$SESSION_ID.json
{
"sessionId": "$SESSION_ID",
"timestamp": "ISO_8601_TIMESTAMP",
"target": "{{SC_ARGS}}",
"executionModel": "PARALLEL_52_AGENTS",
"performanceMetrics": {
"analysisSpeedup": "12x",
"totalAgentsDeployed": 52,
"parallelPhases": 8,
"timeToComplete": "5-8 minutes",
"sequentialEstimate": "60-90 minutes"
},
"phase": "discovery|analysis|optimization|validation|monitoring|complete",
"parallelAgentGroups": {
"discovery": {
"agents": 10,
"status": "complete",
"findings": ["postgresql", "mysql", "mongodb", "redis", "elasticsearch"]
},
"databaseSpecific": {
"postgresql": { "agents": 10, "optimizations": 15 },
"mysql": { "agents": 10, "optimizations": 12 },
"mongodb": { "agents": 10, "optimizations": 8 }
},
"riskAssessment": {
"agents": 12,
"criticalRisks": 0,
"mediumRisks": 3,
"lowRisks": 25
},
"implementation": {
"agents": 10,
"parallelOperations": ["index_creation", "statistics_update", "config_tuning"],
"safetyChecks": "continuous"
},
"validation": {
"agents": 10,
"metricsTracked": 50,
"performanceGain": "285%"
},
"monitoring": {
"agents": 10,
"dashboardsCreated": 5,
"alertsConfigured": 25
},
"reporting": {
"agents": 8,
"documentsGenerated": 12
}
},
"optimizationResults": {
"indexesCreated": 23,
"configChanges": 45,
"performanceImprovement": "285%",
"querySpeedup": "15x average, 50x best case",
"riskLevel": "low",
"downtime": "zero (online operations)",
"rollbackCapability": "instant"
},
"parallelRecommendations": {
"immediate": [
"Deploy 10 agents for index creation",
"Launch 5 agents for statistics updates",
"Spawn 8 agents for cache warming"
],
"scheduled": [
"Parallel VACUUM on 10 tables",
"Distributed statistics refresh",
"Concurrent partition maintenance"
],
"monitoring": [
"Real-time query analysis grid",
"Distributed lock monitoring",
"Parallel performance tracking"
],
"nextOptimization": [
"Shard key optimization (10 agents)",
"Read replica deployment (8 agents)",
"Query parallelization (12 agents)"
]
},
"coordinationState": {
"agentSynchronization": "lock-free",
"conflictResolution": "automatic",
"rollbackCoordination": "distributed consensus"
},
"checkpoints": {
"parallel_discovery": true,
"multi_db_analysis": true,
"risk_assessment": true,
"safe_implementation": true,
"continuous_validation": true,
"monitoring_deployed": true,
"reports_generated": true
}
}
Update session state: phase = "complete" with all 52 agents synchronized
Consolidate parallel agent findings into unified optimization report
Archive parallel execution metrics demonstrating 9-12x speedup
Clean up agent coordination files: /tmp/db-optimize-agent-*-$SESSION_ID
Synthesize next-phase parallel optimization opportunities
Document parallel execution patterns for future optimization cycles
CRITICAL SUCCESS METRICS:
Total Execution Time : 5-8 minutes (vs 60-90 minutes sequential)Parallel Agents Deployed : 52+ specialized optimization agentsCoverage : 100% database aspects analyzed simultaneouslyPerformance Gain : 285% average query performance improvementSafety : Zero-downtime implementation with instant rollbackAutomation : Complete monitoring infrastructure deployed in parallel This parallel approach transforms database optimization from hours-long sequential analysis to minutes-long comprehensive optimization with superior results.
02
B. Claude Command Translation
Analyze Db Db Optimize | Skills Pool