From role-database
Provides operational guidance for 12 NewSQL/distributed SQL databases: CockroachDB (multi-region, CDC), YugabyteDB, TiDB (HTAP), Spanner, Vitess, more. For global SQL distribution, horizontal scaling, HTAP workloads.
How this skill is triggered — by the user, by Claude, or both
Slash command
/role-database:newsql-distributedThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
You are a NewSQL and distributed SQL database specialist providing production-level guidance across 12 database technologies.
You are a NewSQL and distributed SQL database specialist providing production-level guidance across 12 database technologies.
| Database | Consistency | PG Compatible | Scale | HTAP | Managed |
|---|---|---|---|---|---|
| CockroachDB | Serializable | Wire + SQL | Auto sharding | No | CockroachDB Cloud |
| YugabyteDB | Serializable | YSQL (PG) + YCQL (CQL) | Auto sharding | No | YugabyteDB Aeon |
| TiDB | Snapshot isolation | MySQL wire | TiKV auto-split | Yes (TiFlash) | TiDB Cloud |
| Google Spanner | External consistency | PG via pgAdapter | Auto splits | No | Fully managed |
| Vitess | MySQL-dependent | MySQL wire | Manual (VSchema) | No | PlanetScale |
| PlanetScale | MySQL-dependent | MySQL wire | Vitess sharding | No | Fully managed |
| Citus | PG defaults (RC) | Native PG extension | Manual distribution | No | Azure Cosmos for PG |
| SingleStore | Read committed | MySQL wire | Shard-nothing | Yes (columnstore) | SingleStore Helios |
| OceanBase | RC / Snapshot | MySQL + Oracle modes | Auto partitioning | Yes | OceanBase Cloud |
| Neon | PG defaults | Full PG | Scale-to-zero | No | Fully managed serverless |
| AlloyDB | PG defaults | Full PG | Read replicas | Analytics accelerator | Google Cloud managed |
Load the relevant reference for the task at hand:
NewSQL databases choose CP (Consistency + Partition Tolerance):
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseGuides configuration, tuning, operation, and troubleshooting of 20 relational/SQL databases including PostgreSQL (VACUUM, partitioning), MySQL (InnoDB, Vitess), Oracle, SQL Server in production.
Advises on database selection, schema design, indexing, query optimization, and migrations for SQL/NoSQL databases like PostgreSQL, MySQL, MongoDB, Redis, and ORMs including Prisma, Drizzle.
Guides database selection with RDBMS vs NoSQL catalogs, CAP/ACID/BASE theory, OLTP/OLAP distinctions, and specifics for PostgreSQL, MySQL, MongoDB, Redis, DynamoDB.