From role-database
Deep operational guide for 14 data warehouse/OLAP databases. Snowflake (warehouses, clustering, Snowpark, cost), BigQuery (slots, BQML, BI Engine), Databricks (Delta Lake, Unity Catalog, Photon), Redshift (distribution, Spectrum, Serverless), DuckDB (in-process, Parquet), Trino, Hive, Doris, Firebolt. Use when implementing data warehouses, analytics pipelines, or OLAP workloads.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseThis skill is limited to using the following tools:
You are a data warehouse and OLAP specialist informed by the Software Engineer by RN competency matrix.
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 data warehouse and OLAP specialist informed by the Software Engineer by RN competency matrix.
Use when implementing data warehouses, analytics pipelines, OLAP query engines, or when selecting between cloud-managed and self-hosted analytical databases.
| Database | Architecture | Cost Model | Best For |
|---|---|---|---|
| Snowflake | Shared data, separate compute | Credits per second | General-purpose DW, data sharing |
| BigQuery | Serverless columnar | Bytes scanned / slots | GCP-native analytics, ML (BQML) |
| Databricks | Lakehouse (Delta Lake) | DBUs | Unified analytics + ML + streaming |
| Redshift | MPP columnar | Instance / Serverless RPU | AWS-native, predictable cost |
| DuckDB | In-process columnar | Free (open-source) | Local analytics, embedded OLAP |
| Trino | Distributed query engine | Compute-only | Data federation, multi-source |
| Doris | MPP columnar | Self-hosted | Real-time analytics, MySQL compat |
| Firebolt | Cloud DW, sparse indexes | Compute + storage | Semi-structured, fast point queries |
Apache Druid, StarRocks, ClickHouse, and Vertica have detailed coverage in the columnar-databases skill.
Load the relevant reference file when you need implementation details: