Analytics Engineer Documentation Assistant
Generate production-grade data documentation from SQL and schemas
What You Can Do
This skill transforms SQL queries, table definitions, and database schemas into comprehensive data documentation instantly. It produces data models, column dictionaries, metrics definitions, and data lineage—typically done manually over hours. You get governance-ready documentation that aligns your data team and informs stakeholders, all in minutes.
Features
descriptions, columns, tests, and YAMLs
Example Output
Example 1: Generated Data Dictionary
| Column | Type | Description | Business Logic |
|---|---|---|---|
| customer_id | INT | Unique customer identifier | Primary key, never null |
| VARCHAR(255) | Customer email address | Deduplicated, normalized to lowercase | |
| lifetime_value | DECIMAL(10,2) | Total revenue from customer | Sum of all completed orders, refreshed daily |
| segment | VARCHAR(50) | Customer cohort | Calculated from RFM analysis, updated weekly |
| created_at | TIMESTAMP | Account creation date | UTC timezone, immutable |
Example 2: Generated dbt Model YAML
version: 2
models:
- name: customers_dim
description: 'Core customer dimension with RFM segmentation'
owner: 'analytics-team'
columns:
- name: customer_id
description: 'Unique customer identifier'
tests:
- unique
- not_null
- name: lifetime_value
description: 'Total customer lifetime value, refreshed nightly'
Example 3: Data Lineage Map
[raw.postgres.orders] → [stg_orders] → [fact_orders] → [dashboard.revenue]
[raw.postgres.customers] → [stg_customers] → [customers_dim] → [dashboard.customer_360]
What's Included
- SKILL.md: Complete documentation assistant with SQL analysis and generation prompts
- Data Dictionary Template: Column metadata, definitions, and business logic format
- dbt YAML Generator Template: Converts SQL into production-ready dbt model YAMLs
- Metrics Definition Template: Standardized KPI and calculation documentation
- Lineage Mapping Template: Table dependencies and data flow diagrams
- Schema Analysis Checklist: Questions to extract all critical documentation elements
- Quality Rules Template: Data validation and SLA documentation format
Who It's For
- Analytics Engineers — Document dbt projects and maintain data governance
- Data Analysts — Create self-service data dictionaries for business teams
- Data Platform Teams — Build comprehensive data catalogs and lineage maps
- Business Analysts — Understand technical data assets in business language
- Data Stewards — Manage data quality rules, ownership, and SLAs
Best For
- Documenting dbt projects — Auto-generate model YAMLs from SQL queries
- Data lineage analysis — Map upstream sources and downstream impacts
- Metrics and KPI definitions — Capture calculation logic and ownership
- Column-level data dictionaries — Define every field's business meaning
- Schema change documentation — Generate migration notes and impact summaries
- Data governance — Assign ownership, refresh schedules, and quality rules
- Onboarding — Give new team members instant schema and lineage reference
You might also like
This skill helps you systematically diagnose failures in distributed ML training and serving infrastructure. You provide system logs, metrics, and error traces, and Claude performs structured root-cause analysis to identify the underlying issue—whether it's resource exhaustion, distributed system deadlock, data pipeline corruption, or model serving misconfiguration. You get a detailed diagnosis with remediation steps ranked by likelihood and implementation effort.
by moonwell-fi
You can systematically diagnose why your RAG system isn't returning relevant results and identify specific misalignments between queries and context. This skill walks you through analyzing retrieval quality, scoring context relevance, and optimizing prompt-retrieval alignment to improve your RAG accuracy. You'll get concrete, actionable recommendations for fixing bottlenecks in your pipeline.
by moonwell-fi
You'll handle difficult guest conversations with structured communication templates that de-escalate tension while protecting your property. Generate professional damage assessments, complaint responses, and resolution protocols that document interactions clearly and mitigate liability. Create personalized communication strategies tailored to each guest situation, from minor maintenance requests to serious damage claims.
by moonwell-fi
Systematically evaluate your Claude prompts using quantitative scoring frameworks to identify weaknesses in clarity, task alignment, and output quality. You'll receive detailed optimization recommendations with A/B testing guidance to improve prompt effectiveness and consistency across different use cases and input variations.
by moonwell-fi
You can prepare your domain-specific datasets, train fine-tuned Claude models optimized for your use case, benchmark performance against base models, and deploy production-ready custom models. This skill automates the entire fine-tuning pipeline from raw data to live inference, complete with cost-benefit analysis and version control.
by moonwell-fi
You get structured guidance for designing controlled experiments, selecting appropriate metrics, and analyzing results with statistical rigor. Claude helps you identify confounding variables, calculate required sample sizes, interpret statistical significance, and document methodology for reproducible benchmarking that stands up to scrutiny.
by moonwell-fi
Design experiments with statistical rigor from the ground up. You'll generate power analyses, create randomization strategies, write preregistration documents, and get AI-assisted reviews of your experimental design to catch biases before data collection. Whether you're planning a clinical trial, A/B test, or academic study, you'll have a complete, defensible experimental protocol.
by moonwell-fi
This skill transforms high-level feature requests into actionable implementation plans by conducting deep requirement interviews, analyzing existing codebases (or planning greenfield projects), and producing comprehensive handoff documents. It distinguishes between brownfield development (with existing code to integrate) and greenfield projects (starting from scratch), ensuring your technical strategy accounts for your actual constraints and patterns.
by moonwell-fi