Implements high-performance data access layers using Repository patterns and ORM best practices across multiple programming languages.
Data architecture patterns (warehouse, lake, lakehouse, mesh), ETL/ELT pipelines, streaming architectures, scaling strategies, and schema…
Automate update and maintenance of data dictionaries in Treasure Data - generates 80-90% of column descriptions automatically, allowing…
Review data integrity for Rails changes.
Validate data integrity during and after migration with comprehensive verification checks
Optional advanced tool for complex data modeling.
Creates rigorous, validated models of entities, relationships, and constraints for database schemas (SQL, NoSQL, graph), knowledge graphs…
Expert guidance on building Swift database client libraries.
Create database migration with schema changes and rollback.
Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL…
Orchestrates safe, zero-downtime database schema changes and data migrations using industry-standard patterns like Expand/Contract.
Analyzes PHP code for database scaling issues.
Database schema design for PostgreSQL/MySQL with normalization, relationships, constraints.
Database comparison catalogs, RDBMS vs NoSQL selection criteria, CAP/ACID/BASE theory, OLTP vs OLAP, and technology-specific characteristics
Generate production code for Dataverse SDK using advanced patterns, error handling, and optimization techniques.
Deep expertise in creating and managing Dataverse tables, columns, relationships, option sets, and solutions via the Dataverse Web API…
Design a relational or document database schema with tables, relationships, indexes, and migration plan.
This skill should be used when the user asks to "verify database state", "check what's in the database", "assert DB rows after the…
Transform AI agents into experts on dbt project architecture and medallion layer patterns, providing guidance on structuring…
Guide AI agents through installing and configuring dbt on local machines using the dbt Fusion engine (dbt 2.0).
Airtable Automation via Rube MCP workflow skill.