# Data warehouse schema design (/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.

- Web version: https://skills.sgomez.dev/en/s/data--warehouse-schema
- Section: [Data](https://skills.sgomez.dev/en/data.md)
- Author: Santiago Gómez de la Torre
- License: MIT
- Source: https://github.com/sgomez-dev/claude-skills/blob/main/skills/data/warehouse-schema.md
- Updated 10 Jul 2026

## 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

macOS · Linux:

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

Windows:

```
irm https://raw.githubusercontent.com/sgomez-dev/claude-skills/main/install.ps1 | iex
```

Claude Code plugin:

```
/plugin marketplace add sgomez-dev/claude-skills
/plugin install data-skills@claude-skills-collection
```

## Permissions

- Reads: `**/*.sql`, `**/models/**`, `**/migrations/**`, `**/*.yml`, `**/schema*`, `**/*.prisma`, `**/*.py`
- Writes: `warehouse_schema_*.sql`, `warehouse_schema_*.md`, `ddl/*.sql`
- Runs: —
- Network: No
- Destructive: No

## Author's description

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

- [How we review this](https://skills.sgomez.dev/en/methodology.md)