Database Management Habilidades de Claude

Backend Migration Standards

Establishes best practices for creating reversible, zero-downtime database migrations with consistent naming and structure.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through advanced indexing, quantization, and high-efficiency caching strategies.

AgentDB Performance Optimizer

Optimizes AgentDB vector databases using quantization, HNSW indexing, and caching to significantly improve search speed and memory efficiency.

InsForge Database Schema Patterns

Provides optimized PostgreSQL schema patterns and Row Level Security policies for building secure, scalable InsForge applications.

Database Testing

Validates database schemas, ensures data integrity, and verifies migration safety to prevent data loss or corruption.

Convex Data Migrations

Guides developers through safe, idempotent data migrations within the Convex backend ecosystem using best-practice workflows.

Data Engineer

Architects and maintains robust data pipelines, analytics infrastructure, and integration workflows.

Database Migration & Schema Evolution

Executes and manages database schema migrations, data transformations, and zero-downtime deployment strategies across multiple ORMs.

Ghost CMS Database Migration

Automates the creation, implementation, and testing of database schema migrations for Ghost CMS.

SQLModel Task & User Schemas

Generates robust, type-safe SQLModel database schemas optimized for PostgreSQL performance and Better Auth integration.

Backend Queries

Writes efficient, secure database queries while preventing N+1 problems and SQL injection vulnerabilities.

TimescaleDB Hypertable Setup

Guides the design and implementation of optimized TimescaleDB schemas for high-performance time-series data storage and analysis.

Wheels Migration Generator

Generates database-agnostic CFWheels migrations for schema management, table creation, and cross-platform database consistency.

Backend Models

Defines robust database models and schemas with precise ORM mappings, relationships, and data integrity constraints.

Firebase Firestore Specialist

Architects high-performance NoSQL databases and manages real-time synchronization for mobile-first Firestore applications.

Database Administrator

Manages database operations, performance tuning, backup/recovery, and security through structured guidance and implementation patterns.

Firebase Firestore Specialist

Architects and implements scalable NoSQL database solutions using Firebase Firestore with real-time sync and offline-first capabilities.

NestJS TypeORM Integration

Streamlines the setup, configuration, and refactoring of TypeORM within NestJS TypeScript projects for scalable database management.

Wheels Migration Generator

Generates database-agnostic CFWheels migrations for schema management while enforcing best practices and fixing common CLI bugs.

Firebase Firestore Specialist

Optimizes Firebase Firestore implementations with expert guidance on NoSQL patterns, real-time synchronization, and robust security rules.

PostgreSQL MCP Analyst

Analyzes PostgreSQL databases through schema discovery and read-only SQL queries to generate actionable data insights.

Cloudflare R2 & D1 Storage Mastery

Optimizes development with Cloudflare's edge storage products including R2 object storage, D1 SQL databases, and KV namespaces through battle-tested patterns.

PostgreSQL Table Design

Architects optimized, production-grade PostgreSQL schemas using industry-standard best practices and performance patterns.

Data Quality Frameworks

Implements production-grade data validation and observability using Great Expectations, dbt tests, and formal data contracts.

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, query plan analysis, and efficient SQL implementation patterns.

Database Migration & Schema Management

Executes seamless database migrations, schema transformations, and zero-downtime deployment strategies across multiple ORMs and platforms.

CQRS Projection Patterns

Builds efficient read models and materialized views from event streams using CQRS and event sourcing patterns.

dbt Transformation Patterns

Implements production-ready dbt patterns for scalable data modeling and analytics engineering.

Prisma 7 Expert

Optimizes database workflows using the Rust-free Prisma 7 ORM with high-performance queries and ESM-first architecture.

Laravel Migrations Expert

Streamlines database schema design and migration management for Laravel applications using industry-standard patterns.