Database Management Habilidades de Claude

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance with specialized table patterns, query optimization, and real-time analytical workflows.

PostgreSQL Design & Performance Patterns

Implements high-performance PostgreSQL database schemas, optimized queries, and robust security policies based on industry best practices.

PostgreSQL Patterns

Optimizes PostgreSQL database design and performance using industry-standard best practices and patterns.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database schemas, queries, and data pipelines for high-performance analytical workloads.

JPA Patterns for Spring Boot

Optimizes Spring Boot data access layers with high-performance JPA and Hibernate design patterns.

SwiftData Migration

Implements complex SwiftData schema migrations using versioned schemas, two-stage transformation patterns, and relationship preservation strategies for iOS applications.

Neon Serverless Database Connector

Integrates the Neon Serverless Driver into applications to enable low-latency PostgreSQL access in edge and serverless environments.

Neon Drizzle Database Setup

Automates the configuration of Drizzle ORM with Neon databases, including schema generation and migration workflows.

Neon JS SDK Integration

Configures the full Neon JS SDK for unified authentication and PostgREST-style database queries in modern web applications.

Neon Toolkit

Automates the lifecycle of ephemeral Neon databases for automated testing, CI/CD pipelines, and isolated development environments.

Database Skills Discovery

Automatically identifies and loads specialized skills for SQL, NoSQL, schema design, and query optimization within the Claude Code environment.

Data Pipeline & ETL Discovery

Automatically activates specialized data engineering skills for ETL, batch processing, and real-time stream orchestration.

Snowflake SQL Optimizer

Optimizes Snowflake SQL queries for peak performance by identifying anti-patterns and rewriting logic while preserving exact results.

Ecotone Business Interface Builder

Generates auto-implemented PHP interfaces for database queries, messaging gateways, and data converters using the Ecotone Framework.

Ecotone Event Sourcing

Implements robust event sourcing patterns, projections, and event versioning within the Ecotone framework.

Database Designer

Architects, optimizes, and migrates professional database schemas for SQL and NoSQL systems using expert-level design patterns.

Migration Architect

Designs and executes zero-downtime system migrations with automated rollback strategies and compatibility validation.

PHP Database Read-Write Proxy Generator

Generates robust database connection proxies for PHP 8.4 to implement seamless read/write splitting and replica routing.

Database Replication & Sharding Knowledge

Implements scalable database architectures in PHP through application-level read/write splitting and replica lag management.

Database Scaling Analyzer

Analyzes PHP applications for database access patterns that hinder horizontal scaling and primary database performance.

Database Migration

Generates database migration files with automated schema changes and corresponding rollback logic.

Consistency Patterns Knowledge

Provides expert guidance on consistency models, locking strategies, and distributed systems patterns for robust PHP applications.

PHP Unit of Work Generator

Generates robust Unit of Work infrastructure for PHP 8.4 to ensure transactional consistency across multiple domain aggregates.

Event Sourcing Architecture Expert

Implements and audits high-performance Event Sourcing architectures using PHP 8.4 patterns and Domain-Driven Design principles.

PHP Batch Processing Optimizer

Identifies and refactors inefficient PHP loops that perform repetitive database, API, and file operations into high-performance batch processes.

PHP Connection Pool Analyzer

Identifies and resolves database connection leaks, pool exhaustion, and lifecycle issues in PHP applications.

PHP Event Store Generator

Generates robust Event Store infrastructure for PHP 8.4 applications using Event Sourcing and DDD patterns.

PHP DDD Repository Generator

Generates DDD-compliant Repository interfaces and PHP 8.4 infrastructure implementations for clean architecture.

PHP Query Efficiency Analyzer

Analyzes PHP code and SQL queries to identify performance bottlenecks, missing indexes, and inefficient data retrieval patterns.

PostgreSQL Development Standards

Enforces strict transaction safety, type-safe schema designs, and robust PostgreSQL naming conventions for reliable database architecture.