/data--warehouse-schema

/data--warehouse-schema is a Claude Code skill in the Data section. Designs a star or snowflake warehouse schema with fact and dimension tables, dialect-correct DDL, an entity diagram and a design document.

Author's description

Design a star/snowflake warehouse schema with fact and dimension tables

How to ask for it

/data--warehouse-schema star schema for sales and customers
/data--warehouse-schema design fact and dimension tables for orders
/data--warehouse-schema turn my relational model into a snowflake schema

Install

curl -fsSL https://raw.githubusercontent.com/sgomez-dev/claude-skills/main/install.sh | bash

After installing with the script, type /data--warehouse-schema. Using Cursor, Windsurf or Codex? Platform guides

Demo coming soon

/database--erdEntity relationship diagram
Generates a Mermaid ER diagram from your database schema or ORM models, with columns, keys and relationship cardinality.
Built here
/database--migrationDatabase migrations
Generates migration files for a schema change, with both up and down versions and safety checks for risky table alterations.
Built here
/database--prisma-genPrisma schema
Creates or updates your schema.prisma from your requirements or existing database, and gives the migration and client generation commands.
Built here
/database--query-optimizeSpeed up slow SQL queries
Analyzes a slow SQL or ORM query, spots missing indexes and N+1 problems, and suggests index and rewrite fixes.
Built here
/database--schemaDatabase schema design
Designs or reviews a database schema covering normalization, keys, constraints and indexes, and delivers SQL plus an ER diagram.
Built here
/database--seedSeed data for development
Generates realistic seed data for your database, with valid relationships and edge cases, in your ORM's format and safe to re-run.
Built here

How to ask for it

Install

More from this section