What types of database models does this skill support?

It primarily supports dimensional modeling (star schemas) for analytical workloads and normalized relational models (1NF-3NF) for transactional systems.

Can it help with historical data tracking?

Yes, it includes specific implementation patterns for Slowly Changing Dimensions (SCD) Types 1, 2, and 3 to effectively manage historical record versions.

Does this skill provide SQL templates?

Yes, it provides boilerplate SQL for creating fact tables, dimension tables, and establishing consistent naming conventions across your database layers.

Is this suitable for modern data stack tools like dbt?

Absolutely. The included naming conventions (stg, int, fct, dim) and modeling patterns are perfectly aligned with dbt best practices and modern data engineering workflows.

How does this improve AI-assisted coding?

It provides Claude with a specialized architectural context, ensuring that the SQL and schema designs it generates follow professional data engineering standards rather than just generic syntax.

Data Modeling Essentials

Name: Data Modeling Essentials
Author: timequity

bytimequity

0•

データベース管理

Designs optimized database schemas, dimensional models, and normalized structures for efficient data analytics and storage.

The Data Modeling skill empowers Claude to architect robust data warehouses and relational databases using industry-standard principles. It provides a structured framework for implementing star schemas, managing Slowly Changing Dimensions (SCD), and applying normalization rules from 1NF to 3NF. Whether you are building fact and dimension tables or establishing naming conventions for staging and intermediate layers, this skill ensures your data architecture is scalable, maintainable, and optimized for high-performance analytical queries.

主な機能

01Database normalization (1NF, 2NF, 3NF) guidance

02Standardized naming conventions for data engineering

03SQL implementation for fact and dimension tables

04Star schema and dimensional modeling architecture

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

060 GitHub stars

ユースケース

01Designing a scalable data warehouse for business intelligence reporting

02Refactoring legacy flat tables into normalized relational schemas

03Implementing historical data tracking using SCD Type 2 versioning

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add timequity/plugins data-modeling

For use in Claude.ai and ChatGPT

Download Skill