Database Management Claude 技能

Data Warehouse Architect

Architects robust data warehouses using star schemas, dimensional modeling, and enterprise SQL patterns for scalable analytics.

NoSQL Database Expert

Provides professional architectural guidance and design patterns for high-scale distributed NoSQL databases like Cassandra and DynamoDB.

Semantic RDF Modeling

Models software feature specifications and domain architectures using RDF ontologies and Turtle syntax.

Redis Persistence & Recovery

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

Database Migration Mastery

Automates database schema and data migrations with zero-downtime strategies and robust rollback procedures across multiple ORMs.

Supabase PostgreSQL Functions

Generates secure, production-ready PostgreSQL functions and triggers optimized for Supabase databases.

Event Store Design & Implementation

Designs and implements robust event stores for event-sourced systems using various database technologies and architectural patterns.

Projection Patterns

Design and implement efficient read models and materialized views from event streams for event-sourced architectures.

Data Quality Frameworks

Implements robust data validation and quality assurance using Great Expectations, dbt tests, and formal data contracts.

Database Deadlock Detector

Identifies, resolves, and prevents database deadlocks across PostgreSQL, MySQL, and MongoDB environments.

SQL & Relational Databases Mastery

Master production-grade SQL optimization, schema design, and database performance tuning for data engineering workflows.

dbt Transformation Patterns

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

ClickHouse Analytics Patterns

Optimizes ClickHouse database schemas, queries, and data engineering workflows for high-performance analytical workloads.

PostgreSQL Schema Design

Guides the creation of performant, scalable, and normalized PostgreSQL database schemas using industry best practices.

NoSQL Expert Architect

Provides expert guidance for designing and optimizing distributed NoSQL databases like Cassandra and DynamoDB using query-first modeling.

dbt Development

Validates dbt models against standardized coding conventions to ensure consistent naming, SQL structure, testing coverage, and documentation.

Slow Query Analysis & DB Tuning

Analyzes database slow query logs to identify performance bottlenecks and provide actionable indexing and optimization strategies.

Recce dbt Data Validation

Automates data validation and impact analysis for dbt projects using the Recce framework.

Convex Backend Development

Streamlines Convex backend development with standardized function syntax, schema definitions, and type-safe data modeling.

Database Connection Pooler

Optimizes and manages database connection pooling across PostgreSQL, MySQL, and MongoDB environments to ensure high performance and resource efficiency.

Supabase SDK & Auth Setup

Installs and configures the Supabase SDK and CLI while managing authentication credentials for seamless backend integration.

Prisma Database Patterns

Implements production-ready Prisma ORM patterns for database schema design, migrations, and high-performance queries.

Database Assistant

Expertly designs database schemas, optimizes complex SQL queries, and manages data migrations with industry-leading best practices.

Redis Strings & Caching

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

Databases & Architecture

Design and implement scalable database schemas, system architectures, and robust APIs for modern software applications.

NoSQL Architecture Expert

Provides expert architectural guidance and design patterns for high-scale distributed databases like DynamoDB and Cassandra.

Consolidate Discovery

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

ClickHouse Analytics Patterns

Implements high-performance ClickHouse database patterns, query optimizations, and data engineering best practices for analytical workloads.

Supabase Setup & Management

Configures and secures Supabase backends including database schemas, RLS policies, authentication providers, and Edge Functions.

Database Design Architect

Architects efficient, scalable database schemas and selects optimal data stacks based on specific project requirements.