# Database Operations Manager

> 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.

- Skill: `xspoonai/database-operations-manager` (Agent Skill, multi-file: 7 files)
- Install (CLI): `npx skillmds@latest add xspoonai/database-operations-manager`
- Raw SKILL.md: https://api.skillmd.com/api/skills/xspoonai/database-operations-manager/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: XSpoonAi (https://skillmd.com/u/xspoonai)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/xspoonai/database-operations-manager

---


## Usage Examples

### Query Optimization
```python
from scripts.query_builder import QueryBuilder

builder = QueryBuilder()
optimized = builder.optimize_query(
    "SELECT * FROM users WHERE age > 25",
    database_type="postgresql"
)
print(f"Original cost: {optimized['original_cost']}")
print(f"Optimized cost: {optimized['optimized_cost']}")
```

### Schema Analysis
```python
from scripts.schema_analyzer import SchemaAnalyzer

analyzer = SchemaAnalyzer()
schema_report = analyzer.analyze_schema({
    "tables": ["users", "orders", "products"],
    "database_type": "mysql"
})
print(f"Normalization: {schema_report['normalization_level']}")
```

### Index Recommendations
```python
from scripts.optimizer import Optimizer

optimizer = Optimizer()
recommendations = optimizer.recommend_indexes(
    "SELECT * FROM orders WHERE user_id = 123",
    database_type="postgresql"
)
print(f"Suggested indexes: {recommendations['indexes']}")
```

### Connection Pool Management
```python
from scripts.connection_manager import ConnectionManager

pool = ConnectionManager()
config = pool.optimize_pool_size(
    database_type="mysql",
    expected_connections=1000
)
print(f"Pool size: {config['pool_size']}")
```

## Output Format

All modules return structured JSON:

```json
{
  "analysis_type": "string",
  "original_query": "string",
  "optimized_query": "string",
  "performance_gain": "percentage",
  "index_recommendations": ["array"],
  "execution_plan": "string",
  "estimated_cost": number,
  "normalization_status": "1NF|2NF|3NF",
  "recommendations": ["array of actionable items"]
}
```

## Severity Levels

| Level | Meaning | Impact | Action |
|-------|---------|--------|--------|
| CRITICAL | SQL injection vulnerability or data loss risk | High risk | Fix immediately |
| HIGH | Query performance issue causing slowdowns | Moderate risk | Optimize within sprint |
| MEDIUM | Schema normalization concern | Low-moderate risk | Plan refactoring |
| LOW | Minor optimization opportunity | Low risk | Consider for future |

## Version & Support

- **Version**: 1.0.0
- **Released**: February 2026
- **Status**: Production Ready
- **Confidence**: 90%

## Future Enhancements (v1.1.0)

- NoSQL optimization (MongoDB, DynamoDB)
- Sharding strategy recommendations
- Query caching suggestions
- Replication setup guidance
- Backup and recovery planning
- Multi-database migration tools
- Real-time performance monitoring integration
- Machine learning-based query prediction