Obt design optimizer

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

Designs and optimizes One Big Table (OBT) patternsFrom its SKILL.md

Install

npx -y skills add a5c-ai/babysitter --skill obt-design-optimizer

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

SKILL.md

2.0 KB, 330 tokens by cl100k_base, as published. Nobody here has run it

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

Analyze source models and relationships
Document common query patterns
Define platform and constraints
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

What ships with it: 1 file

461 B alongside SKILL.md

README.md461 B