Database Management Claude 技能

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, query plan analysis, and systematic refactoring of slow SQL queries.

Supabase Project Bootstrapper

Bootstraps new Supabase projects with professional tooling for task management, SQL formatting, and schema introspection.

PostgreSQL Table Design

Architects production-grade PostgreSQL schemas using expert-level best practices for data integrity, performance, and scalability.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through quantization, HNSW indexing, and advanced caching strategies.

DynamoDB Single-Table Designer

Architects high-performance, production-ready AWS DynamoDB schemas using single-table design principles to optimize scalability and cost.

Metadata Manager

Streamlines the creation and management of BigQuery table schemas, metadata configurations, and Airflow DAG schedules following Mozilla ETL conventions.

Backend Queries

Optimizes and secures database interactions by implementing efficient query patterns, preventing security vulnerabilities, and managing data performance.

SQL Optimization Patterns

Optimizes SQL queries and database schemas using advanced indexing, EXPLAIN analysis, and performance-tuning patterns.

Supabase RLS Optimizer

Implements high-performance and secure Row Level Security (RLS) policies and functions for Supabase projects.

Supabase RLS Policy Generator

Generates secure, production-ready Row-Level Security (RLS) policies for Supabase databases using multi-tenant and role-based access patterns.

Event Stream Projection Patterns

Implements high-performance read models and CQRS projections from event streams for optimized data retrieval.

Event Store Design

Designs and implements robust event stores for event-sourced architectures and distributed systems.

SQL Optimization Patterns

Optimizes database performance through systematic query tuning, advanced indexing strategies, and execution plan analysis.

Devops Database

Manages PostgreSQL database operations including Alembic migrations, backups, restorations, and pgvector extension management for development and production environments.

Vector Database Configs

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

SQL Optimization Patterns

Optimizes SQL query performance through systematic execution plan analysis, advanced indexing strategies, and proven query restructuring patterns.

dbt Development

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

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.

Redis Sentinel Configurations

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

SQL Optimization Patterns

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

ORM Reviewer

Reviews and optimizes ORM code for efficiency, transaction handling, and N+1 query prevention.

PostgreSQL Table Design

Architects high-performance PostgreSQL schemas using industry best practices for data integrity, indexing, and advanced features.

Convex Data Migrations

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

Supabase Database Design

Enforces lean PostgreSQL conventions and a tight-fit design philosophy for optimized Supabase database schemas.

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.

Async SQLAlchemy Patterns for FastAPI

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

Database Migration Master

Facilitates seamless database schema and data migrations across multiple ORMs with a focus on zero-downtime strategies and safety.

dbt Data Modeling Expert

Implements industry-standard dbt patterns for scalable data transformation, automated testing, and comprehensive documentation.