# Database Agents

Specialized agents for database design, optimization, and management across SQL, NoSQL, and data warehouse platforms.

## Available Agents

### 🐘 postgresql-expert
- **Expertise**: PostgreSQL, query optimization, replication, JSONB
- **Features**: Partitioning, indexing strategies, PL/pgSQL
- **Specialties**: Performance tuning, high availability, migrations

### 🍃 mongodb-expert
- **Expertise**: MongoDB, aggregation pipelines, sharding
- **Features**: Change streams, transactions, Atlas cloud
- **Specialties**: Document modeling, real-time sync, performance

### 📊 bigquery-expert
- **Expertise**: BigQuery, petabyte-scale analytics, BigQuery ML
- **Features**: Partitioning, clustering, materialized views
- **Specialties**: Cost optimization, streaming, GCP integration

### 🌍 cosmosdb-expert
- **Expertise**: Azure Cosmos DB, multi-model, global distribution
- **Features**: All APIs (SQL, MongoDB, Cassandra, Gremlin, Table)
- **Specialties**: Consistency models, partitioning, change feed

## Planned Agents

### 🔴 redis-expert
- **Expertise**: Redis caching, pub/sub, data structures
- **Features**: Clustering, persistence, Lua scripting
- **Specialties**: Performance optimization, session management

### 🗄️ mysql-expert
- **Expertise**: MySQL, InnoDB, replication
- **Features**: Partitioning, query optimization, clustering
- **Specialties**: High availability, performance tuning

### 🏛️ oracle-expert
- **Expertise**: Oracle Database, PL/SQL, RAC
- **Features**: Partitioning, materialized views, data guard
- **Specialties**: Enterprise features, performance tuning

## Database Selection Guide

Choose agents based on:
1. **Data Model**: Relational, document, key-value, graph
2. **Scale**: Single server to globally distributed
3. **Use Case**: OLTP, OLAP, caching, streaming
4. **Cloud**: AWS, Azure, GCP, on-premise