Stats
Actions
Available In
Tags
Plugin
role-database
Acts as a senior DBA across 230+ database systems, handling schema design, query optimization, replication, backup, migration, monitoring, security hardening, capacity planning, and database DevOps for relational, document, key-value, graph, time-series, vector, and streaming databases.
What's Inside
Skills26
role-database:backup-recovery
/backup-recovery
Backup strategies and disaster recovery across all database engines. Full, incremental, differential backups. PITR (Point-in-Time Recovery). PostgreSQL (pg_dump, pgBackRest, Barman, WAL archiving), MySQL (mysqldump, XtraBackup, Clone Plugin), MongoDB (mongodump, Atlas backup), Redis (RDB, AOF). RPO/RTO planning, backup verification, cloud-native backup. Use when designing backup strategies, implementing disaster recovery, or troubleshooting data recovery.
role-database:capacity-planning
/capacity-planning
Database capacity and growth planning. Storage growth estimation, IOPS requirements, memory sizing (buffer pool, shared_buffers), connection count estimation, sharding triggers, read replica scaling, cost estimation per cloud provider. Load testing (pgbench, sysbench, YCSB, HammerDB). When to shard vs scale up vs read replicas. Use when planning database capacity, sizing infrastructure, or evaluating scaling strategies.
role-database:columnar-databases
/columnar-databases
Deep operational guide for 12 columnar/wide-column databases. Apache Cassandra (compaction, consistency, SAI, nodetool), ScyllaDB (shard-per-core, Alternator), HBase, Bigtable, ClickHouse (MergeTree, materialized views), Druid, StarRocks, Kudu, MonetDB, Vertica, Pinot. Use when configuring, tuning, or operating columnar databases for analytics or high-write workloads.
role-database:connection-management
/connection-management
Connection pooling and management across all engines. PgBouncer (transaction/session/statement mode), pgcat (Rust-based, load balancing, sharding), ProxySQL (MySQL query routing, caching), HikariCP (Java), application-level pooling (Prisma, SQLAlchemy, GORM, database/sql). Serverless connection strategies (Prisma Accelerate, RDS Proxy, Neon pooler). Connection limits, pool sizing, leak detection. Use when configuring connection pools, optimizing connection usage, or troubleshooting connection issues.
role-database:data-modeling
/data-modeling
Data modeling methodologies and patterns across paradigms. Entity-Relationship modeling (Chen, Crow's Foot, UML), document modeling (embedding vs referencing, polymorphic, bucket, outlier patterns), graph modeling (labeled property graph, RDF), time-series modeling, event sourcing, dimensional modeling (star/snowflake schema, SCD), Data Vault (hubs, links, satellites), polyglot persistence. Use when designing data models, choosing between modeling approaches, or mapping domain models to database schemas.
Stats
Version1.0.0
Released
LanguageShell
Stars13
Forks1
MaintenanceGood
LicenseMIT
Last Commit
Added
Available In
Safety Signals
Caution
Uses power tools
Uses Bash, Write, or Edit tools
'%20stop-opacity%3D'0.16'%2F%3E%3Cstop%20offset%3D'1'%20stop-color%3D'rgb(200%2C90%2C60)'%20stop-opacity%3D'0.03'%2F%3E%3C%2FlinearGradient%3E%3C%2Fdefs%3E%3Crect%20width%3D'320'%20height%3D'200'%20fill%3D'url(%23g)'%2F%3E%3Ccircle%20cx%3D'250'%20cy%3D'56'%20r%3D'92'%20fill%3D'rgb(200%2C90%2C60)'%20fill-opacity%3D'0.06'%2F%3E%3Ccircle%20cx%3D'64'%20cy%3D'172'%20r%3D'58'%20fill%3D'rgb(200%2C90%2C60)'%20fill-opacity%3D'0.05'%2F%3E%3C%2Fsvg%3E)
