Skip to content

a5c-ai/babysitter / library/specializations/data-engineering-analytics/skills/obt-design-optimizer

OBT Design Optimizer

Verified

Designs and optimizes One Big Table (OBT) patterns

OBT Design Optimizer

Overview

Designs and optimizes One Big Table (OBT) patterns. This skill balances denormalization benefits with maintainability for analytical use cases.

Capabilities

  • Column selection optimization
  • Denormalization strategy
  • Nested/repeated field design (BigQuery)
  • Clustering key selection
  • Partition strategy
  • Update frequency optimization
  • Query pattern analysis
  • Storage vs. performance tradeoffs

Input Schema

{
  "sourceModels": ["object"],
  "queryPatterns": ["object"],
  "platform": "snowflake|bigquery|redshift",
  "constraints": {
    "maxColumns": "number",
    "refreshFrequency": "string"
  }
}

Output Schema

{
  "obtDesign": {
    "columns": ["object"],
    "clustering": ["string"],
    "partitioning": "object"
  },
  "buildStrategy": "object",
  "refreshConfig": "object",
  "estimatedQueryImprovement": "percentage"
}

Target Processes

  • OBT Creation
  • BI Dashboard Development
  • Query Optimization

Usage Guidelines

  1. Analyze source models and relationships
  2. Document common query patterns
  3. Define platform and constraints
  4. Balance column count with query needs

Best Practices

  • Include only columns needed for known query patterns
  • Use appropriate clustering for common filter columns
  • Partition by date for time-series analysis
  • Schedule refreshes based on source update frequency
  • Monitor query performance and adjust design
brainstormingobra/superpowersYou MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or planning anything new, in software or out of it (a talk, a business, a renovation).Stars: 321kUpdated Claude CodeCodexVerifiedInstall
brand-guidelinesanthropics/skillsApplies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply.Stars: 197kUpdated Claude CodeCodexVerifiedInstall
frontend-designanthropics/skillsGuidance for distinctive, intentional visual design when building new UI or reshaping an existing one. Helps with aesthetic direction, typography, and making choices that don't read as templated defaults.Stars: 197kUpdated Claude CodeCodexVerifiedInstall
mcp-builderanthropics/skillsGuide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK).Stars: 197kUpdated Claude CodeCodexVerifiedInstall