Data Modeling

A comprehensive reference guide for dbt (data build tool) analytics engineering. It covers model organization using the medallion architecture (staging, intermediate, marts layers), testing strategies, documentation practices, incremental model patterns, and common dbt commands. Ideal for data engineers building transformation pipelines.

This skill provides comprehensive PostgreSQL database design guidance covering data types, indexing strategies, constraints, partitioning, and schema design patterns. It includes detailed recommendations for handling JSONB, time-series data, update-heavy tables, and safe schema evolution practices.

A comprehensive PostgreSQL database design guide that covers data types, indexing strategies, constraints, partitioning, JSONB usage, and performance optimization patterns. Includes AI agent definitions for database architecture and SQL expertise to help design scalable, maintainable database schemas.