a5c-ai/babysitter / library/specializations/data-engineering-analytics/skills/obt-design-optimizer
OBT Design Optimizer
VerifiedDesigns and optimizes One Big Table (OBT) patterns
SKILL.md
View on GitHub---
name: OBT Design Optimizer
description: Designs and optimizes One Big Table (OBT) patterns
version: 1.0.0
category: Data Modeling
skillId: SK-DEA-020
allowed-tools:
- Read
- Write
- Edit
- Glob
- Grep
- Bash
graph:
domains: [domain:data-engineering]
specializations: [specialization:data-engineering-analytics]
skillAreas: [skill-area:data-warehouse-modeling, skill-area:columnar-storage]
roles: [role:analytics-engineer, role:data-engineer]
workflows: [workflow:data-pipeline-deployment]
topics: [topic:database-sharding]
---
# 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
```json
{
"sourceModels": ["object"],
"queryPatterns": ["object"],
"platform": "snowflake|bigquery|redshift",
"constraints": {
"maxColumns": "number",
"refreshFrequency": "string"
}
}
```
## Output Schema
```json
{
"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
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: 322k | 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: 198k | 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: 198k | 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: 198k | Updated | Claude CodeCodex | Verified | Install |