Does it support Database-as-Code for migrations?

Absolutely. It includes comprehensive templates for managing migrations using tools like Alembic and SQLAlchemy to ensure version-controlled schema updates.

How does this skill handle database security and compliance?

It implements advanced security measures such as Row-Level Security (RLS), replication user management, and secure department-based access policies.

Can this skill help with database performance tuning?

Yes, it provides automated patterns for analyzing execution plans, generating optimization tips, and creating concurrent indexes to resolve slow queries.

Which database engines does this skill support?

The skill specializes in enterprise versions including PostgreSQL 17, MySQL 8.4 LTS, MongoDB 8.0, Redis 7.4, MariaDB 11.4, and Cassandra 5.0.

Enterprise Database Architect

Name: Enterprise Database Architect
Author: jg-chalk-io

byjg-chalk-io

Database Management

Architects, optimizes, and manages enterprise-grade SQL and NoSQL database systems with expert-level performance tuning and security.

About

The moai-domain-database skill empowers Claude with deep expertise in enterprise database architecture, covering PostgreSQL 17, MySQL 8.4 LTS, MongoDB 8.0, and Redis 7.4. It provides advanced implementation patterns for high-availability clusters, connection pooling via PgBouncer, and sophisticated query optimization using execution plan analysis. Ideal for developers building scalable backends, this skill facilitates database-as-code migrations, multi-region replication, and robust security through Row-Level Security (RLS) and comprehensive monitoring integration.

Key Features

Expert configuration for PostgreSQL 17, MySQL 8.4, and MongoDB 8.0
Database monitoring and observability using Prometheus and custom metrics
Advanced query optimization using EXPLAIN ANALYZE and indexing strategies
0 GitHub stars
Automated migration workflows and multi-database logical replication
High-performance connection pooling setup with PgBouncer and ProxySQL

Use Cases

Implementing enterprise security compliance with Row-Level Security and encryption
Diagnosing and resolving performance bottlenecks in complex SQL query execution
Scaling backend applications to high-availability clusters with logical replication

About

Key Features

Expert configuration for PostgreSQL 17, MySQL 8.4, and MongoDB 8.0
Database monitoring and observability using Prometheus and custom metrics
Advanced query optimization using EXPLAIN ANALYZE and indexing strategies
0 GitHub stars
Automated migration workflows and multi-database logical replication
High-performance connection pooling setup with PgBouncer and ProxySQL

Use Cases

Implementing enterprise security compliance with Row-Level Security and encryption
Diagnosing and resolving performance bottlenecks in complex SQL query execution
Scaling backend applications to high-availability clusters with logical replication