Database Management Habilidades de Claude

SQLAlchemy 2.0 Async Patterns

Implements high-performance asynchronous database operations using SQLAlchemy 2.0 and FastAPI best practices.

SQLAlchemy 2.0 Async Patterns

Implements high-performance asynchronous database patterns using SQLAlchemy 2.0 and FastAPI integration.

Alembic Database Migrations

Manages SQLAlchemy 2.0 async database migrations and zero-downtime schema changes with production-ready patterns.

Zero-Downtime Database Migrations

Implements safe database schema changes using the expand-contract pattern and online tools to ensure continuous service availability.

Database Versioning Patterns

Manages database schema history and change management patterns across environments using industry-standard versioning strategies.

Event Sourcing & CQRS Architecture

Implements robust event-driven architectures by storing application state as a sequence of immutable domain events for complete auditability and temporal queries.

PGVector Hybrid Search

Implements production-grade hybrid search using PostgreSQL PGVector and BM25 with Reciprocal Rank Fusion for high-accuracy retrieval.

Database Schema Designer

Designs robust SQL and NoSQL database schemas with a focus on normalization, performance optimization, and safe migration patterns.

PGVector Hybrid Search

Implements high-performance hybrid retrieval by combining semantic vector search with BM25 keyword matching using Reciprocal Rank Fusion.

Zero-Downtime Database Migrations

Implements safe, non-blocking database schema changes using the expand-contract pattern and online migration tools.

Backend Caching Strategies

Implements production-ready Redis caching patterns and invalidation strategies to optimize backend performance and reduce database load.

Event Sourcing Patterns

Implements immutable event logs and CQRS patterns for high-integrity, auditable application state management.

Upstash Vector TypeScript SDK

Streamlines the integration of Upstash Vector database features for high-performance similarity search and AI applications.

Memory Fabric

Orchestrates graph-based and semantic memory systems to provide unified, high-context information retrieval for AI development.

Reliable Outbox Pattern Implementation

Implements the transactional outbox pattern to ensure atomic database writes and reliable event delivery in microservices.

Database Schema Designer

Designs and optimizes SQL and NoSQL database schemas with professional-grade normalization, indexing, and migration patterns.

Supabase Postgres Best Practices

Optimizes PostgreSQL performance and schema design using production-ready patterns and Supabase-recommended database rules.

Safe Code Migrations

Facilitates secure, backward-compatible software transitions including database schema changes, API versioning, and framework upgrades.

Ecto Constraint Debugger

Diagnoses and resolves Ecto database constraint violations in Elixir and Phoenix applications.

Tidewave MCP Integration for Phoenix

Provides real-time introspection and debugging tools for Elixir Phoenix applications via the Model Context Protocol (MCP).

Ecto N+1 Query Auditor

Identifies and remediates N+1 query anti-patterns in Elixir Ecto code to optimize database performance.

SQLiteData Advanced Reference

Provides advanced schema composition, polymorphic data modeling, and complex query patterns for SQLiteData in Swift applications.

GRDB SQLite for Swift

Implements type-safe SQLite database layers, complex SQL queries, and reactive data observation using GRDB.swift.

GRDB

Facilitates direct SQLite access and advanced database management patterns for iOS and macOS development using GRDB.swift.

SwiftData to SQLiteData Migration

Guides the migration of xOS data layers from SwiftData to SQLiteData to achieve better performance and advanced CloudKit sharing capabilities.

Realm to SwiftData Migration

Provides a comprehensive reference and implementation path for migrating xOS applications from Realm to SwiftData.

Database Migration

Executes safe, data-loss-free database schema evolution for iOS and macOS applications using production-ready patterns for SQLite, GRDB, and SwiftData.

SwiftData Migration Diagnostics

Diagnoses and resolves SwiftData migration failures, including schema version mismatches, relationship integrity errors, and data loss across iOS platforms.

SQLite Data for Swift

Simplifies type-safe SQLite persistence and CloudKit synchronization for Swift applications using modern macros and property wrappers.

ClickHouse Analytics & Data Engineering

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