Dimensional Model Validator

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 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 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.