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…
Database schema design and data modeling patterns including normalization principles (1NF-5NF), denormalization trade-offs, entity…
Enforces rigorous safety protocols, multi-layer backups, and phased execution for high-risk production database operations.
Design partitioning and sharding strategies for data at scale.
Create and manage modular portable database pods (SQLite + metadata + embeddings).
Generates data quality check code for bauplan pipelines and ingestion workflows.
Process this skill enables AI assistant to generate realistic test data
Use when large data ingestion, backfill, export, ETL, warehouse loading, manifest catch-up, or table synchronization needs to become much…
Process use when you need to ensure database integrity through comprehensive
Expert database architect specializing in data layer design from scratch, technology selection, schema modeling, and scalable database…
Process use when you need to archive historical database records to
Process use when you need to track database changes for compliance and
Automate database backup processes with scheduling, compression, and
Use when building any feature that involves database changes (new table, new column, alter column, etc.) — fork the database like a git…
Process use when you need to implement multi-tier caching to improve
Database MCP server integration for PostgreSQL, MySQL, MongoDB
Process use when you need to work with connection management.
Process use when you need to work with deadlock detection.
Reports SQL execution status and environment metadata from the terminal directly back to Notion project trackers.
Database design principles and decision-making.