Database Management Habilidades de Claude

PostgreSQL Admin

Manages PostgreSQL database security, role-based access control, and routine maintenance operations.

PostgreSQL Backup & Recovery

Implements production-ready PostgreSQL backup strategies including logical, physical, and point-in-time recovery patterns.

PostgreSQL Performance Optimizer

Optimizes PostgreSQL database performance through automated query analysis, advanced indexing strategies, and database configuration tuning.

PostgreSQL Advanced Query Architect

Master complex PostgreSQL query patterns including CTEs, window functions, and recursive joins for high-performance data operations.

PostgreSQL Monitoring

Monitors PostgreSQL database performance and health through automated metric collection, observability patterns, and diagnostic alerting.

Lutece 8 DAO & Home Patterns

Implements standardized DAO and Home layer patterns for Lutece 8 development using best practices for data persistence.

Diagnostic Playground

Generates interactive HTML dashboards populated with real Supabase data to visualize application state and debug complex issues.

PostGIS Geospatial Architecture

Implements advanced geospatial features including geofencing, spatial indexing, and real-time fleet tracking using PostGIS and PGRouting.

Consolidate Discovery

Identifies duplicate and outdated content within SQLite databases to streamline knowledge bases and reduce token usage.

Database Workflows & Optimization

Streamlines database schema design, migration management, and query performance optimization across major ORMs and SQL dialects.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through advanced quantization, HNSW indexing, and efficient batch operations.

Database Performance & Anti-Patterns

Identifies and remediates common database performance bottlenecks like N+1 queries, unbounded fetches, and connection pool issues.

Laneweaver Database Design

Designs robust PostgreSQL 17 schemas and Supabase migrations tailored for the LaneweaverTMS logistics ecosystem.

Redis Persistence & Recovery

Manages Redis data durability through RDB snapshots, AOF logging, and hybrid persistence strategies for high-availability systems.

Redis Strings & Caching

Implements production-grade Redis string operations, atomic counters, and efficient caching patterns for high-performance applications.

Redis Modules Master

Extends Redis capabilities with advanced modules including RedisJSON, RediSearch, RedisTimeSeries, and RedisBloom for complex data modeling.

Redis Installation & Setup

Deploys and configures production-ready Redis instances across multiple platforms with automated verification and troubleshooting.

Redis Advanced Data Types

Implement specialized Redis data structures including Bitmaps, HyperLogLog, Streams, and Geospatial indexes for complex use cases.

Redis Replication & High Availability

Configures and manages Redis master-replica architectures and Sentinel high-availability clusters for resilient data scaling.

Redis Performance Optimizer

Optimizes Redis environments through advanced memory analysis, slow log troubleshooting, and high-concurrency benchmarking.

Prisma ORM Expert

Optimizes Prisma ORM workflows through expert schema design, migration management, and high-performance query tuning.

jOOQ Database Patterns

Implements type-safe SQL queries and repository patterns using jOOQ for robust Kotlin and Java database interactions.

Flyway Database Migrations

Manages database schema changes and versioning through standardized Flyway migration patterns and PostgreSQL best practices.

Redis Lists & Sets Master

Implements high-performance Redis data structures including reliable queues, unique collections, and complex set operations for distributed applications.

Redis Transaction Pro

Implements production-grade Redis transaction patterns using MULTI/EXEC, optimistic locking with WATCH, and atomic Lua scripting.

Redis Cluster Manager

Manages production-grade Redis Cluster operations including horizontal scaling, hash slot distribution, and automated failover procedures.

PocketBase Development

Provides comprehensive guidance and implementation patterns for building real-time backend services using the PocketBase open-source framework.

Redis Hashes and Sorted Sets

Optimizes Redis data management with advanced patterns for Hashes and Sorted Sets, including leaderboards, object storage, and ranking systems.

History & LocalStorage Manager

Manages persistent state and debate history within localStorage while ensuring data integrity and backward compatibility.

Notion Database Repair Expert

Diagnoses and fixes corrupted Notion databases by repairing schemas, cleaning orphan properties, and resolving API validation errors.