| name | Database Operations Manager |
| description | AI-powered database optimization, query analysis, schema design validation, and connection management. Analyzes SQL/NoSQL queries, recommends indexes, validates schema design patterns, and optimizes database performance. |
| version | 1.0.0 |
| author | Skill Builder |
| tags | ["database","optimization","sql","nosql","performance","query-analysis","schema-design"] |
| activation_triggers | [{"keyword":"analyze database"},{"keyword":"optimize query"},{"keyword":"database performance"},{"pattern":"query_analysis|schema_validation|pool_management"},{"intent":"improve_database_performance"}] |
| parameters | [{"name":"query_input","type":"string","required":true,"description":"SQL or NoSQL query to analyze (SELECT, INSERT, JOIN, aggregation, etc.)","example":"SELECT * FROM users WHERE age > 25"},{"name":"analysis_type","type":"string","required":true,"enum":["query_optimization","schema_analysis","index_recommendation","performance_metrics","connection_pool"],"description":"Type of database analysis to perform","example":"query_optimization"},{"name":"database_type","type":"string","required":true,"enum":["mysql","postgresql","mongodb","sqlite","mariadb"],"description":"Target database system","example":"mysql"},{"name":"table_stats","type":"object","required":false,"description":"Optional table statistics for performance estimation","example":{"row_count":1000000,"avg_row_size":512}},{"name":"optimization_level","type":"string","required":false,"enum":["basic","intermediate","aggressive"],"default":"intermediate","description":"Level of optimization suggestions","example":"intermediate"}] |
| scripts | [{"name":"query_builder","type":"python","path":"scripts/query_builder.py","description":"Builds optimized SQL/NoSQL queries with execution plans and cost estimation","confidence":"92%","params":["query_input","database_type","table_stats"]},{"name":"schema_analyzer","type":"python","path":"scripts/schema_analyzer.py","description":"Validates database schema design, normalization, and relationship integrity","confidence":"90%","params":["database_type","optimization_level"]},{"name":"optimizer","type":"python","path":"scripts/optimizer.py","description":"Detects optimization opportunities and recommends index strategies","confidence":"88%","params":["query_input","database_type","table_stats"]},{"name":"connection_manager","type":"python","path":"scripts/connection_manager.py","description":"Manages connection pools, sizing, and lifecycle for optimal performance","confidence":"91%","params":["database_type","optimization_level"]}] |
| capabilities | ["Query optimization (SELECT, INSERT, JOIN, aggregation)","SQL/NoSQL query analysis","Index recommendation engine","Schema design validation","Database normalization assessment (1NF, 2NF, 3NF)","Connection pool management","Performance metrics estimation","Cost analysis for queries","Relationship integrity checking","Execution plan generation"] |
| cache | true |
| composable | true |
| security_considerations | ["Validate SQL inputs to prevent injection attacks","Don't expose sensitive database credentials","Use parameterized queries","Implement proper access control for schema changes","Monitor query execution time for DoS detection","Sanitize user inputs in dynamic queries","Use connection pooling for efficient resource utilization","Implement proper error handling without exposing internals"] |
