a5c-ai/babysitter / library/specializations/data-engineering-analytics/skills/obt-design-optimizer
OBT Design Optimizer
VerifiedDesigns 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
- 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
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 321k | Updated | Claude CodeCodex | Verified | Install |
| 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: 197k | Updated | Claude CodeCodex | Verified | Install |
| 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: 197k | Updated | Claude CodeCodex | Verified | Install |
| 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: 197k | Updated | Claude CodeCodex | Verified | Install |