data-warehouse skills

10 tagged data-warehouse, measured the same way as everything else here.

Browse within: data 13data-analytics 12business-intelligence 11data lake 10data-analysis 10

erd-studio-setup

01

liam-machine/erd-studio

Skill Claude Code

Friendly, step-by-step setup for ERD Studio in an existing dbt project, for people who may be new to dbt or data modelling. By default a quick start: checks the dbt CLI, draws one business area as an ERD Studio logical model that mirrors dbt, checks it with the ERD Studio diff until logical matches physical and opens…

not rated 166 +1 changed 6d ago B 247 tokens

sql-sentinel

02

takeaseatventure/sql-sentinel

Skill Claude CodeCodex needs its repo

Audit SQL for the cost & performance anti-patterns that burn warehouse credits. Catches SELECT , full-table scans, non-sargable predicates, Cartesian joins, NULL-trap NOT IN, and 17 more rules. Scores warehouse health 0-100 and outputs a prioritized cost-reduction plan for BigQuery, Snowflake, Redshift, and Postgres.

not rated 1 2mo ago A 77 tokens original MIT