Database Management Claude 技能

PostgreSQL Fundamentals

Master production-ready SQL foundations and schema design for PostgreSQL 16+ environments.

Redis Persistence & Recovery

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

PostgreSQL Streaming Replication Manager

Automates the configuration, monitoring, and failover management of PostgreSQL streaming replication clusters.

Supabase Database Integrator

Configures a PostgreSQL database for ChatGPT Apps using Supabase for persistent data storage and secure user isolation.

Redis Strings & Caching

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

Enterprise ERP Consultant

Architects and implements complex business logic for enterprise resource planning systems including finance, inventory, and supply chain modules.

Postgres Best Practices

Optimizes Postgres database performance and security using Supabase-curated best practices for queries, schemas, and Row-Level Security.

Prisma ORM Expert

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

ClickHouse Analytics Patterns

Optimizes high-performance analytical workloads and data engineering using ClickHouse-specific design patterns and best practices.

Neo4j Cypher Graph Expert

Integrates Neo4j graph databases with Claude to execute Cypher queries, manage schemas, and explore complex data relationships.

PostgreSQL PL/pgSQL Development

Develops robust PostgreSQL procedural logic including functions, triggers, and procedures with production-ready patterns.

Database Migration & Schema Evolution

Manages complex database migrations across multiple ORMs with zero-downtime strategies and automated rollback procedures.

SQL Guardrails

Enforces strict SQL standards and backend API patterns to prevent injection, data type mismatches, and contract violations.

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.

Database Management

Architects, optimizes, and manages relational and NoSQL databases to ensure high performance, data integrity, and scalability.

Conversation State Management

Implements robust, database-persisted conversation tracking for stateless AI agents using PostgreSQL.

Redis Advanced Data Types

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

ClickHouse Optimization & Analytics

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

Database Schema

Enforces strict database schema conventions for Drizzle ORM and PostgreSQL to ensure consistent table structures, constraints, and indexing patterns.

ClickHouse Analytics & Data Engineering

Provides optimized ClickHouse database schemas, high-performance query patterns, and data engineering best practices for OLAP workloads.

Supabase Typed Query

Builds type-safe, functional Supabase queries using chainable APIs and entity-based CRUD patterns for robust database interactions.

Spring Boot JPA & Hibernate Patterns

Provides optimized JPA and Hibernate patterns for building high-performance, scalable Spring Boot data layers.

Data Design & Architecture

Designs efficient, scalable, and maintainable data structures and schemas using industry-best practices for SQL and NoSQL databases.

JPA Patterns for Spring Boot

Implements high-performance JPA and Hibernate data modeling patterns for Spring Boot applications.

PostgreSQL Patterns

Optimizes PostgreSQL schema design, indexing strategies, and query performance using industry-standard best practices.

Postgres Patterns

Optimizes PostgreSQL database schemas, queries, and security configurations using industry-proven patterns and Supabase best practices.

PostgreSQL Patterns & Optimization

Optimizes PostgreSQL database performance and security through standardized schema design, indexing strategies, and performance tuning patterns.

NestJS TypeORM Integration

Integrates TypeORM into NestJS projects by configuring data sources, defining entities, managing migrations, and implementing scalable repository patterns.

Postgres Best Practices

Optimizes PostgreSQL performance, schema design, and security using Supabase-vetted standards and implementation patterns.