Prepare a replication package for the sewage-house-prices project.
Automate update and maintenance of data dictionaries in Treasure Data - generates 80-90% of column descriptions automatically, allowing…
Build scalable data pipelines, modern data warehouses, and real-time streaming architectures.
Evaluation criteria and scoring for data engineering artifact reviews
Data Engineering and Analytics, in 27 concepts.
Export Claude Code session and analytics data in JSON, CSV, or Markdown formats.
Common patterns for extracting analytics data from GA4 and GSC with API handling
Generates a Mermaid sequence diagram showing how data moves between components.
Quick data freshness check. Use when the user asks if data is up to date, when a table was last updated, if data is stale, or needs to…
Establish data ownership, quality standards, compliance policies, and metadata management.
🐉 Fetches and parses time-series data from various sources.
Constraints, triggers, audit trails, referential integrity, and data validation.
Join two datasets with automatic strategy selection (joinp vs join vs sqlp)
Design field mapping specifications between source and destination systems for synchronizing insurance AMS and CRM data, LOS to reporting…
Create safe, reversible database migration scripts with rollback capabilities, data validation, and zero-downtime deployments.
Design data models for business domains using entity-relationship or domain-driven design.
Design Power BI data model relationships and Power Query transformation specifications for combining insurance and financial services data…
Data modeling methodologies and patterns across paradigms.
Database schema design and data modeling patterns including normalization principles (1NF-5NF), denormalization trade-offs, entity…
When implementing features that handle large datasets, prioritize performance and scalability.
Use when working with ANY data persistence, database, storage, CloudKit, migration, or serialization.