Database Management Habilidades de Claude

pgdbm Core API Reference

Provides comprehensive technical documentation for implementing pgdbm database operations and managing PostgreSQL configurations.

dbt Development

Enforces standardized dbt coding conventions and validates model structures across staging, integration, and warehouse layers.

MongoDB Atlas Specialist

Manages MongoDB Atlas clusters, designs schemas, and optimizes complex aggregation pipelines for high-performance applications.

CRM Context Retrieval

Retrieves scoped CRM data and context from PostgreSQL to provide AI agents with precise business intelligence.

Supabase Integration Expert

Architects secure and scalable Supabase backends using optimized database schemas, RLS policies, and serverless Edge Functions.

AI Database Schema Patterns for Supabase

Generates and manages production-ready PostgreSQL schemas for AI applications, including RAG storage, chat systems, and multi-tenant architectures.

Redis Cache Strategies

Implements advanced Redis caching patterns and TTL management policies to optimize application performance and data consistency.

Redis Session Management

Implements secure, scalable Redis-based session store configurations across multiple web frameworks.

Supabase Subscription Schemas

Generates secure, production-grade Supabase database schemas and Row Level Security policies for managing SaaS subscriptions and payment workflows.

Supabase Clerk Sync

Synchronizes Clerk authentication with Supabase databases using JWT validation, RLS policies, and secure webhook patterns.

Celery Result Backend Patterns

Configures and optimizes Celery result backends for reliable task storage, retrieval, and persistence.

Redis Connection Management

Optimizes Redis reliability and performance through standardized connection pooling, client configuration, and resilient reconnection strategies.

Redis AI Cache Patterns

Implements cost-efficient embedding and vector caching strategies using Redis to optimize AI application performance and expenses.

Database Query Optimizer

Optimizes database performance by implementing EXPLAIN analysis, strategic indexing, and N+1 query prevention patterns.

SQL Optimization Patterns

Optimizes SQL queries and database performance through advanced indexing strategies and execution plan analysis.

Database Performance & Optimization

Optimizes database schemas, queries, and caching strategies to improve application speed and resource efficiency.

PostgreSQL Table Design Specialist

Designs optimized PostgreSQL database schemas using performance-first patterns and industry best practices.

Database Migration Master

Manages complex database schema migrations and data transformations across multiple ORMs with robust rollback and zero-downtime strategies.

Supabase Database Manager

Enables direct connection and SQL execution for Supabase PostgreSQL databases within the Claude Code environment.

Supabase Database Migrations

Manages Supabase schema migrations, RLS policies, and PostGIS integration with security-first patterns.

Redis Framework Integrations

Provides standardized Redis integration patterns and configuration templates for FastAPI, Next.js, and Express applications.

Async SQLAlchemy Patterns for FastAPI

Implements production-grade asynchronous SQLAlchemy 2.0+ database patterns and migrations for FastAPI applications.

SQL Optimization Patterns

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

Redis Sentinel Configurations

Deploys production-grade Redis Sentinel high availability templates and configuration patterns for resilient data infrastructure.

Vector Database Configs

Configures and optimizes vector databases like pgvector, Chroma, and Pinecone for production RAG pipelines.

Drizzle Cube Joins

Configures and manages complex relational joins between data cubes to enable seamless, secure cross-cube querying in Drizzle Cube.

Supabase Schema Validator

Validates PostgreSQL schemas and migrations for Supabase projects to ensure SQL syntax compliance, naming conventions, and security best practices.

Supabase Integration for Mem0

Configures and optimizes Supabase as a production-ready vector and graph database backend for Mem0 OSS.

Supabase pgvector Setup

Configures pgvector on Supabase to enable high-performance semantic search, RAG systems, and hybrid search capabilities.

SQL Optimization Patterns

Optimizes SQL query performance through systematic indexing strategies, execution plan analysis, and efficient query patterns.