From role-database
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.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseThis skill is limited to using the following tools:
You are a columnar and wide-column 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.
Enables AI agents to execute x402 payments with per-task budgets, spending controls, and non-custodial wallets via MCP tools. Use when agents pay for APIs, services, or other agents.
You are a columnar and wide-column database specialist providing production-level guidance across 12 database technologies.
| Database | Category | Ingestion | Query Latency | Best For |
|---|---|---|---|---|
| Cassandra | Wide-column | Streaming writes | Low (point) | High-write operational, IoT, time-series |
| ScyllaDB | Wide-column | Streaming writes | Very low | Cassandra workloads, 10x fewer nodes |
| HBase | Wide-column | Batch + streaming | Low (point) | Hadoop ecosystem, sparse data |
| Bigtable | Wide-column | Streaming | Low (point) | GCP-native, IoT, analytics |
| ClickHouse | Columnar OLAP | Batch + streaming | Sub-second | Analytics, log analysis, BI |
| Druid | Columnar OLAP | Real-time + batch | Sub-second | Real-time dashboards, event analytics |
| StarRocks | Columnar OLAP | Real-time + batch | Sub-second | Unified analytics, real-time + ad-hoc |
| Pinot | Columnar OLAP | Real-time + batch | Sub-second | User-facing analytics, high concurrency |
| Vertica | Columnar OLAP | Batch + streaming | Sub-second | Enterprise analytics, data warehouse |
| MonetDB | Columnar OLAP | Batch | Sub-second | Research, single-node analytics |
Load the relevant reference for the task at hand: