moai-domain-database

The moai-domain-database skill provides specialized expertise for managing and optimizing modern database systems. It addresses the challenges of working with multiple types of databases by offering comprehensive support for PostgreSQL, MongoDB, and Redis, as well as advanced data patterns for scalable applications. By integrating these technologies into a unified interface, the skill simplifies the management of relational, document-oriented, and in-memory data stores, allowing developers to focus on building efficient and robust applications without the overhead of complex database orchestration.

This skill's main capabilities include advanced relational modeling, query optimization, indexing, and connection management for PostgreSQL; document modeling, aggregation pipelines, sharding, and performance tuning for MongoDB; and caching, real-time analytics, distributed locking, and pub/sub messaging for Redis. Additionally, it supports hybrid multi-database architectures, enabling polyglot persistence patterns, data routing across different stores, and integration of real-time and structured data. Operations like migrations, cache warming, and monitoring are also streamlined through unified commands and APIs.

Typical use cases include designing database schemas, implementing caching strategies, optimizing queries, and building scalable data architectures for applications that require multiple database types. The skill is particularly useful for backend developers, data engineers, and system architects working on enterprise-grade applications where performance, reliability, and efficient data management are critical. It helps teams handle complex data workflows, improve application responsiveness, and maintain consistency across diverse data stores.