Database Management Habilidades de Claude

SQL Query Optimization

21

Optimizes SQL queries for PostgreSQL and MySQL using indexing, execution plan analysis, and performance-driven pattern rewriting.

Cloudflare Vectorize for RAG & AI

21

Implements high-performance semantic search and RAG workflows using Cloudflare's globally distributed vector database.

Drizzle ORM for Cloudflare D1

21

Streamlines Cloudflare D1 database management using Drizzle ORM with type-safe schemas, automated migrations, and optimized query patterns.

Bun Redis Integration

21

Implements high-performance Redis patterns for Bun environments including caching, session management, and real-time data structures.

Bun Drizzle Integration

21

Integrates Drizzle ORM with Bun's SQLite driver to provide type-safe database schemas and streamlined migration workflows.

Cloudflare Workers KV

21

Integrates Cloudflare Workers KV storage into Claude Code for high-performance global key-value management and edge caching.

Database Sharding

21

Implement horizontal scaling and high-performance sharding strategies for PostgreSQL and MySQL databases.

Vercel KV Storage & Caching

21

Implements production-ready Vercel KV (Redis) storage patterns for caching, session management, and rate limiting in serverless applications.

Bun SQLite

21

Integrates high-performance local data storage and management using Bun's native SQLite driver.

Cloudflare Hyperdrive Integration

21

Connects Cloudflare Workers to PostgreSQL and MySQL databases with high-performance connection pooling and query caching.

Database Schema Design

21

Designs and optimizes production-ready PostgreSQL and MySQL database schemas using normalization and performance best practices.

Symfony Cache

21

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

Doctrine Entity Relations for Symfony

21

Configures and optimizes Doctrine ORM entity relationships, fetch modes, and cascade operations for Symfony applications.

Doctrine Transaction Manager

21

Manages database transactions and concurrency in Symfony applications using Doctrine ORM best practices.

Doctrine Performance & Fetch Modes

21

Optimizes Symfony Doctrine queries using fetch modes, lazy loading strategies, and advanced query hints to eliminate N+1 issues.

Doctrine Migrations for Symfony

21

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

SQL Query Optimizer

19

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

ETL Designer

19

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

DBT Model Builder

19

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

dbt Test Generator

19

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

Database Migration Helper

19

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

Schema Designer

19

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

Secure Database Migrations

19

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

ETL Incremental Patterns

19

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

Rails Model Architect

18

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

SQL Query Optimization

18

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

Data Modeling Patterns

18

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

Data Migration Script Generator

18

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

Database Schema Documentation

18

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

Database Sharding Architect

18

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