What is a star schema in data warehousing?

A star schema is a modeling technique that organizes data into central fact tables for metrics and surrounding dimension tables for descriptive attributes, simplifying queries and improving performance.

Does it support complex relationship modeling?

Yes, it includes bridge table patterns to handle many-to-many relationships between dimensions and facts while maintaining the integrity of the star schema.

Can it help improve query performance?

Absolutely. The skill includes patterns for materialized views and aggregate tables that pre-calculate common metrics, significantly reducing the load on large fact tables.

How does this skill handle data history?

It provides standardized SQL patterns for Slowly Changing Dimensions (SCD), specifically Type 1 (overwrite), Type 2 (history via new rows), and Type 3 (history via new columns).

Data Warehouse Architect

Name: Data Warehouse Architect
Author: pluginagentmarketplace

bypluginagentmarketplace

•

数据库管理

Architects robust data warehouses using star schemas, dimensional modeling, and enterprise SQL patterns for scalable analytics.

This skill equips Claude with specialized expertise in architecting analytical databases using Kimball-style dimensional modeling. It provides implementation patterns for fact and dimension tables, sophisticated handling of Slowly Changing Dimensions (SCD), and performance optimization techniques through aggregate tables and bridge tables. By applying these patterns, users can build high-performance data environments that ensure historical data integrity and optimize complex analytical queries for business intelligence and reporting.

主要功能

011 GitHub stars

02Bridge table patterns for many-to-many relationship management

03Star schema and dimensional modeling implementation

04Performance-focused materialized views and aggregate tables

05Slowly Changing Dimension (SCD) Types 1, 2, and 3 logic

06Conformed dimension design for cross-functional reporting

使用场景

01Designing an enterprise sales reporting system with centralized fact tables

02Implementing history tracking for customer profiles using versioned SCD Type 2 rows

03Optimizing dashboard performance with pre-calculated daily and monthly aggregate tables

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add pluginagentmarketplace/custom-plugin-sql data-engineer

For use in Claude.ai and ChatGPT

Download Skill