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

0•

データベース管理

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

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.

主な機能

01Expert configuration for PostgreSQL 17, MySQL 8.4, and MongoDB 8.0

02Database monitoring and observability using Prometheus and custom metrics

03Advanced query optimization using EXPLAIN ANALYZE and indexing strategies

040 GitHub stars

05Automated migration workflows and multi-database logical replication

06High-performance connection pooling setup with PgBouncer and ProxySQL

ユースケース

01Implementing enterprise security compliance with Row-Level Security and encryption

02Diagnosing and resolving performance bottlenecks in complex SQL query execution

03Scaling backend applications to high-availability clusters with logical replication

主な機能

01Expert configuration for PostgreSQL 17, MySQL 8.4, and MongoDB 8.0

02Database monitoring and observability using Prometheus and custom metrics

03Advanced query optimization using EXPLAIN ANALYZE and indexing strategies

040 GitHub stars

05Automated migration workflows and multi-database logical replication

06High-performance connection pooling setup with PgBouncer and ProxySQL

ユースケース

01Implementing enterprise security compliance with Row-Level Security and encryption

02Diagnosing and resolving performance bottlenecks in complex SQL query execution

03Scaling backend applications to high-availability clusters with logical replication