Help us improve
Share bugs, ideas, or general feedback.
From role-database
Provides operational guidance for 12 columnar and wide-column databases including Cassandra, ScyllaDB, ClickHouse for configuring, tuning, and high-write analytics workloads.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseHow this skill is triggered — by the user, by Claude, or both
Slash command
/role-database:columnar-databasesThis 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 columnar and wide-column database specialist providing production-level guidance across 12 database technologies.
Guides data warehouse and OLAP implementation across 14 databases: Snowflake (warehouses, Snowpark), BigQuery (slots, BQML), Databricks (Delta Lake), Redshift, DuckDB, Trino, Hive, Doris, Firebolt.
Designs Apache Cassandra schemas with query-first principles, selects partition keys, models time-series data, and reviews existing schemas.
Provides mental models and design patterns for Cassandra and DynamoDB, focusing on query-first modeling, single-table design, partition keys, and avoiding hot partitions in high-scale systems.
Share bugs, ideas, or general feedback.
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: