Skills
.Work. You
Rest

preferences-data-modeling

Community

Design robust data schemas and pipelines.

Data & Analytics#schema design#data quality#data modeling#data pipelines#duckdb#sqlmesh#semantic layer
Authorcameronraysmith
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill addresses the complexities of designing, managing, and evolving data schemas and pipelines, ensuring data integrity, consistency, and efficient processing.

Core Features & Use Cases

  • Schema Design: Provides conventions for database schemas, normalization, and ER diagrams.
  • Incremental Processing: Details patterns for handling time-partitioned data and state tracking.
  • Semantic Layer: Guides on separating logical metrics from physical storage for reusability.
  • Tool Integration: Offers specific patterns for DuckDB, DuckLake, and SQLMesh.
  • Use Case: When designing a new data warehouse for sales analytics, use this Skill to establish best practices for table structures, incremental updates, and defining key business metrics.

Quick Start

Apply data modeling conventions for designing database structures and data relationships.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: preferences-data-modeling
Download link: https://github.com/cameronraysmith/vanixiets/archive/main.zip#preferences-data-modeling

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.