Database Management Claude 技能

SQL Performance Optimization Patterns

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

Database Diff & Migration Adapter

Compares database schemas and generates transaction-safe migration scripts and rollback procedures for PostgreSQL and MySQL.

PostgreSQL Read-Only Explorer

Executes safe, read-only SQL queries and explores schemas across multiple PostgreSQL databases.

Data Management Patterns

Implements robust database strategies for zero-downtime migrations, automated backups, and regulatory data compliance.

Database Anti-Pattern Detection

Identifies and resolves common database performance bottlenecks and inefficient query patterns in modern ORMs.

Supabase Next.js Integration

Integrates Supabase with Next.js App Router projects using secure patterns for authentication, database management, and row-level security.

SQL Optimization Patterns

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

Drizzle ORM Development

Enforces database query conventions, type safety, and permission filtering using standardized Drizzle ORM patterns.

Redis Installation & Setup

Deploys and configures production-ready Redis instances across multiple platforms with automated verification and troubleshooting.

PocketBase API Field Adder

Provides programmatic guidance for adding fields to PocketBase collection schemas using the JavaScript SDK.

Subgraph Migration

Migrates blockchain data indexers from TheGraph subgraphs to Envio HyperIndex for faster performance and modern TypeScript development.

World Weaver Memory Consolidator

Optimizes AI memory structures through automated clustering, pruning, and relationship strengthening to maintain long-term context efficiency.

Database Design & Architecture

Architects scalable database schemas and optimizes query performance using context-aware design principles.

AgentDB Performance Optimization

Optimizes AgentDB vector databases using quantization, HNSW indexing, and batch operations to achieve massive performance gains and memory reduction.

Database Management

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

Trading MCP Server Configuration

Configures Model Context Protocol (MCP) servers to integrate Claude Code with Alpaca trading APIs and local SQLite databases.

Supabase Database Integrator

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

Crypto Trading Database Population

Populates trading databases with cryptocurrency symbols to ensure model availability and enable 24/7 market coverage.

Frappe DocType Builder

Constructs complete DocType definitions for the Frappe Framework, including fields, permissions, and configurations.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance through high-performance schema design, advanced query patterns, and efficient data engineering practices.

SQL Writer for Game Analytics

Generates, validates, and executes Databricks SQL queries specifically for mobile game analytics and user behavior tracking.

Data Engineer Agent

Builds and maintains robust data pipelines, analytics infrastructure, and ETL processes with high data quality standards.

Prisma ORM Expert

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

Convex Backend Development

Streamlines the implementation of Convex backend features using Zod validation, custom function wrappers, and type-safe database interactions.

ClickHouse Optimization & Analytics

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

SQL Data Analysis Expert

Performs advanced SQL data analysis, query optimization, and complex transformations using modern database patterns.

ClickHouse Analytics & Data Engineering

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

Spring Boot JPA & Hibernate Patterns

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

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.