OBT Design Optimizer

This skill generates Slowly Changing Dimension (SCD) implementations for historical data tracking across data platforms like Snowflake, BigQuery, and dbt. It automates the creation of SCD Types 1-6, including DDL, MERGE statements, and snapshot configurations with proper surrogate key and effective date management. Use it when you need to quickly implement consistent SCD patterns for dimension tables in your data warehouse projects.

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.