Separate command (write) and query (read) models for complex domains.
Cloudflare D1 migration workflow: generate with Drizzle, inspect SQL for gotchas, apply to local and remote, fix stuck migrations, handle…
Process large datasets efficiently using chunk(), chunkById(), lazy(), and cursor() to reduce memory consumption and improve performance
Evaluation criteria and scoring for data engineering artifact reviews
Establish data ownership, quality standards, compliance policies, and metadata management.
Design field mapping specifications between source and destination systems for synchronizing insurance AMS and CRM data, LOS to reporting…
Plan and execute database migrations, data transformations, and system migrations safely with rollback strategies and data integrity…
Data modeling methodologies and patterns across paradigms.
Gate 5: Data structures document - defines entities, relationships, and ownership before database technology selection.
You are a data pipeline architecture expert specializing in scalable, reliable, and cost-effective data pipelines for batch and streaming…
Profile source data quality, completeness, and anomalies before migration to identify cleansing requirements and assess fitness for…
Use when adding or reviewing data quality tests for dbt models in warehouse-backed analytics projects.
Automatically discover data pipeline and ETL skills when working with ETL, data pipelines, streaming, batch processing, data validation…
Load before calling data-tables or parse-file. Use for natural standalone requests like "what data tables do I have?", "show/list my tables", or "what columns are in this table?", and whenever the…
Architects complex database structures and manages data lifecycles through autonomous schema design and terminal-based execution.
Guides database schema design, migration planning, and query optimization based on universal development standards.
Guide database design, migration, and query optimization.
PgBouncer, connection optimization, and pooling strategies for database performance.
Architects robust database systems by implementing multi-tenant isolation, transaction boundaries, and data consistency strategies.
Guides database schema design, migration planning, and query optimization using universal development standards.
Guides database schema design, migration workflows, and query optimization using industry-standard development practices.