SCD Implementation Generator

The OBT Design Optimizer skill helps developers design and optimize One Big Table patterns for analytical workloads. It balances denormalization benefits with maintainability by handling column selection, partitioning, clustering, and nested field design. Use it when creating or refining OBTs on platforms like BigQuery, Snowflake, or Redshift to optimize for specific query patterns and constraints.

This skill validates dimensional data models against Kimball methodology best practices for analytical workloads. It checks star/snowflake schemas, validates surrogate keys, SCD types, and ensures bus matrix compliance. Use it when designing or reviewing data warehouses to enforce proven dimensional modeling patterns.

This skill provides a production-tested setup for Content Collections, a TypeScript-first tool that transforms Markdown/MDX files into type-safe data collections with Zod validation. Use it when building blogs, documentation sites, or content-heavy Vite + React applications to ensure type safety and automatic content validation. It covers everything from Vite plugin configuration and MDX compilation to deployment optimization and schema validation.

This skill enables developers to build applications with the Polymarket prediction markets platform, including API integration for trading and market data. It also provides real-time data streaming via WebSocket to monitor live trades and market activity. Use it for implementing trading strategies or creating tools that process live market updates.