Database Management Claude 技能

Postgres Best Practices

Optimizes PostgreSQL performance and schema design using Supabase-vetted patterns and best practices.

Supabase Postgres Best Practices

Optimizes PostgreSQL performance and schema design using Supabase-verified best practices and implementation patterns.

Postgres Performance & Best Practices

Optimizes PostgreSQL database performance and schema design using expert-refined guidelines and industry best practices.

ClickHouse Database & Analytics Patterns

Optimizes ClickHouse database performance with expert patterns for schema design, high-speed analytical queries, and efficient data engineering workflows.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance through high-performance schema design, query optimization, and advanced analytical patterns.

Event Store Design

Design and implement robust event stores for event-sourced systems using industry-standard persistence patterns.

Database Migration Specialist

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

PostgreSQL Table Design

Architects high-performance PostgreSQL schemas using industry best practices for data types, indexing, and normalization.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance with specialized patterns for high-speed analytical queries and data engineering.

dbt Transformation Patterns

Implements production-ready dbt patterns for scalable analytics engineering, model layering, and automated testing.

ClickHouse Analytics & Data Engineering

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

ClickHouse Analytics & Data Patterns

Provides optimized ClickHouse database patterns, high-performance query strategies, and data engineering best practices for large-scale analytical workloads.

SQL Optimization Patterns

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

ER Diagram and Data Modeling

Generates entity-relationship diagrams and provides expert data modeling guidance for robust database schema design.

Zod Firestore Type Safety

Implements end-to-end type safety for Firestore databases using Zod schemas and the withConverter API.

Firebase Admin SDK for Next.js

Implements secure server-side Firebase Admin SDK patterns for Next.js 14+ to manage privileged operations and authentication.

Zod Firestore Type Safety

Ensures end-to-end type safety and runtime validation for Firestore databases using Zod schemas and the withConverter API.

Firebase Next.js Integration Strategies

Implements robust Firebase integration patterns for Next.js 14+ App Router environments using dual SDK architectures.

Firestore Data Modeling Patterns

Provides expert guidance on structuring Firestore NoSQL databases for optimal performance, scalability, and cost-efficiency.

Database Schema Evaluator

Performs comprehensive multi-perspective audits of database architectures to optimize performance, integrity, and long-term scalability.

Firebase Next.js Integration Strategies

Streamlines Next.js 14+ App Router integration with Firebase using optimized dual-SDK architecture and server-side data fetching patterns.

Firestore Data Modeling Patterns

Optimizes NoSQL database structures using Firestore best practices for subcollections, data denormalization, and atomic operations.

Database Schema Evaluator

Analyzes database schemas using a multi-perspective expert panel to identify performance bottlenecks, normalization issues, and maintenance risks.

Firestore Security Rules Generator

Generates secure, production-ready Firestore security rules for user-scoped access and role-based control.

Oxy Semantic Layer Builder

Builds and maintains structured Oxy semantic layer files to enable natural language data querying from database schemas.

ETL Pipeline Builder

Builds and extends robust, maintainable ETL pipelines using DLT for API connectors and spreadsheet ingestion.

SQL Optimization Patterns

Optimizes database performance through systematic query analysis, advanced indexing strategies, and efficient execution patterns.

Python Data Engineering

Builds production-grade data pipelines and dimensional models using SQLAlchemy 2.0 and modern warehouse architectures.

SQL Query Optimization

Optimizes PostgreSQL database performance through structured analysis, index recommendations, and advanced query refactoring patterns.

Database Operations

Streamlines database interactions by providing standardized patterns for CRUD operations, session management, and performance optimization.