moai-domain-database

# Database Domain Specialist ## Quick Reference Enterprise Database Expertise - Comprehensive database patterns and implementations covering PostgreSQL, MongoDB, Redis, Oracle, and advanced data management for scalable modern applications. Core Capabilities: - PostgreSQL: Advanced relational patterns, optimization, and scaling - MongoDB: Document modeling, aggregation, and NoSQL performance tuning - Redis: In-memory caching, real-time analytics, and distributed systems - Oracle: Enterprise patterns, PL/SQL, partitioning, and hierarchical queries - Multi-Database: Hybrid architectures and data integration patterns - Performance: Query optimization, indexing strategies, and scaling - Operations: Connection management, migrations, and monitoring When to Use: - Designing database schemas and data models - Implementing caching strategies and performance optimization - Building scalable data architectures - Working with multi-database systems - Optimizing database queries and performance --- ## Implementation Guide ### Quick Start Workflow Database Stack Initialization: Create a DatabaseManager instance and configure multiple database connections. Set up PostgreSQL with connection string, pool size of 20, and query logging enabled. Configure MongoDB with connection string, database name, and sharding enabled. Configure Redis with connection string, max connections of 50, and clustering enabled. Use the unified interface to query user data with profile and analytics acros...