Database Management Habilidades de Claude

Doctrine Migrations for Symfony

Manages database schema versioning and migrations within Symfony applications using Doctrine.

Symfony Cache

Implement and optimize high-performance caching strategies using the Symfony Cache component.

ETL Pipeline Architect

Builds robust, idempotent data pipelines with a focus on data quality, error handling, and operational reliability.

Supabase Database Integrator

Configures persistent PostgreSQL databases for ChatGPT applications using Supabase with a focus on secure data isolation.

Supabase Database Configurator

Configures and integrates PostgreSQL databases using Supabase for persistent data storage in AI-driven applications.

Upstash Search TypeScript SDK

Integrates high-performance AI search capabilities into TypeScript applications using the Upstash REST API.

dbt Test Generator

Generates comprehensive dbt test suites including schema validations, data quality checks, and source freshness monitors.

DBT Model Builder

Builds standardized dbt data models with structured layering, incremental strategies, and comprehensive schema documentation.

ETL Designer

Designs robust and scalable ETL/ELT pipelines with built-in orchestration, error handling, and monitoring capabilities.

SQL Query Optimizer

Optimizes SQL database performance through advanced indexing strategies, query rewriting, and execution plan analysis.

ETL Incremental Patterns

Implements efficient data loading strategies including incremental syncs, CDC, and parallel backfill operations.

Schema Designer

Architect robust relational database structures with optimized normalization, indexing, and data integrity constraints.

Database Migration Helper

Manages database schema changes safely with rollback support and best practices across multiple ORMs and SQL.

Secure Database Migrations

Enforces security-first database migrations with mandatory Row Level Security policies and architectural oversight.

SQL Query Optimizer

Analyzes and optimizes SQL queries for PostgreSQL and MySQL to improve performance and reduce execution time.

Rails AI Solid Stack (Jobs & Cache)

Configures database-backed background jobs, caching, and WebSockets using the Rails 8 Solid Stack while strictly excluding Redis and Sidekiq.

Supabase Data Manager

Manages Supabase databases through direct REST API calls for CRUD operations and advanced data filtering.

Rails Model Architect

Designs robust Ruby on Rails models using industry-standard ActiveRecord patterns and data integrity best practices.

Database Sharding Architect

Implements horizontal data partitioning and sharding strategies to scale large-scale database architectures across multiple servers.

Litestream for Rails

Configures continuous SQLite backups for Rails 8+ applications using Litestream and S3-compatible storage.

SQL Patterns & Optimization

Provides advanced SQL design patterns and optimization techniques for efficient data engineering and complex query construction.

Parquet Data Engineering

Optimizes columnar data storage using Parquet patterns for partitioning, predicate pushdown, and schema evolution.

dbt Coder

Standardizes dbt project architecture and SQL transformation patterns for scalable analytics engineering.

Database Schema Documentation

Generates comprehensive database schema documentation, ERD diagrams, and technical data dictionaries for clear data modeling.

Data Migration Script Generator

Generates robust, reversible, and production-grade database migration scripts for schema changes and data transformations.

Reference Data & Security Master

Designs and manages authoritative reference data systems including security masters, client models, and multi-source identifier mapping for financial services.

DLT Pipeline Creator

Automates the creation and maintenance of robust data ingestion pipelines using the dlt library for various APIs and databases.

Financial Data Quality Manager

Implements and manages data quality programs for financial services, focusing on golden source architecture and regulatory compliance.

Data Modeling Patterns

Designs optimized database schemas and data models using normalization, denormalization, and advanced relationship patterns.

SQL Query Optimization

Optimizes database performance through advanced query rewriting, index design strategies, and EXPLAIN plan analysis.