From role-database
Deep operational guide for 12 NewSQL/distributed SQL databases. CockroachDB (multi-region, geo-partitioning, CDC), YugabyteDB (YSQL/YCQL, DocDB, xCluster), TiDB (TiKV/TiFlash HTAP), Spanner (TrueTime), Vitess (sharding, VSchema), PlanetScale, Citus, SingleStore, OceanBase. Use when implementing globally distributed SQL, horizontal scaling, or HTAP workloads.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseThis skill is limited to using the following tools:
You are a NewSQL and distributed SQL database specialist providing production-level guidance across 12 database technologies.
Searches, retrieves, and installs Agent Skills from prompts.chat registry using MCP tools like search_skills and get_skill. Activates for finding skills, browsing catalogs, or extending Claude.
Searches prompts.chat for AI prompt templates by keyword or category, retrieves by ID with variable handling, and improves prompts via AI. Use for discovering or enhancing prompts.
Designs and optimizes AI agent action spaces, tool definitions, observation formats, error recovery, and context for higher task completion rates.
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):