Database Management Claude 技能

Database Sharding Manager

Architects and implements horizontal database sharding strategies to scale data storage and performance across multiple servers.

Database Transaction Monitor

Monitors database transactions in real-time to detect long-running queries, lock contention, and transaction anomalies.

Database Seeder & Data Generator

Generates realistic, schema-aware test data and database seed scripts to populate development and testing environments.

Database Integrity & Validation Engine

Ensures database reliability by automatically implementing data types, ranges, and referential integrity constraints using a specialized validation engine.

NoSQL Data Modeler

Designs high-performance NoSQL schemas and data models optimized for scalability in databases like MongoDB and DynamoDB.

ORM & Database Schema Generator

Generates production-ready ORM models and database schemas for frameworks like TypeORM, Prisma, and SQLAlchemy using natural language.

Database Query Performance Optimizer

Optimizes database query execution by analyzing EXPLAIN plans and identifying performance bottlenecks.

SQL Query Optimizer

Analyzes and refines SQL queries to enhance database performance through index recommendations and structural rewrites.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers for major SQL databases to optimize performance and enforce business logic.

Unified SQL Data Analyst

Queries and joins data across PostgreSQL, MySQL, and SQLite databases using a unified SQL engine for advanced data exploration.

Supabase Expert

Provides comprehensive guidance for building secure and scalable applications using Supabase database, auth, storage, and edge functions.

PostgreSQL Nanoid Identifiers

Implements a hybrid ID strategy using Nanoids for public-facing identifiers and UUIDs for internal PostgreSQL references.

Drizzle ORM Expert

Provides comprehensive documentation and implementation patterns for Drizzle ORM, covering type-safe queries, schema management, and multi-database integrations.

PostgreSQL Table Design

Designs optimized, production-grade PostgreSQL schemas following industry best practices and performance patterns.

JGI Lakehouse Query

Facilitates querying and exploring the Joint Genome Institute (JGI) Dremio Lakehouse, including GOLD and IMG genomics databases.

Supabase Database

Streamlines Supabase database management through optimized CRUD operations, Row Level Security (RLS) implementation, and PostgreSQL function support.

Postgres Hypothetical Index Helper

Generates Ruby and ActiveRecord commands to create and test PostgreSQL hypothetical indexes using the HypoPG extension.

Database Schema Conflict Resolver

Resolves database schema version conflicts by automatically selecting the most recent migration timestamp.

Supabase Next.js Integration

Streamlines the integration of Supabase backend services into React and Next.js applications using modern App Router patterns and SSR.

ClickHouse Analytics & Data Patterns

Optimizes ClickHouse database performance with expert patterns for schema design, high-volume data ingestion, and complex analytical queries.

Optimizing Performance

Identifies and resolves performance bottlenecks across databases, application logic, and infrastructure using proven optimization patterns.

Codebase & Schema Explorer

Accelerates codebase onboarding by automating the discovery of database schemas, API endpoints, and architectural patterns.

Supabase Storage Manager

Manages file storage, bucket configurations, and secure access policies within the Supabase ecosystem.

Prisma ORM Development

Streamlines database development using Prisma 5+ with type-safe schema design, migration workflows, and optimized query patterns.

Prisma ORM Setup & Patterns

Configures and optimizes Prisma ORM for type-safe database access and streamlined schema management in Node.js applications.

Postgres Query Optimization

Optimizes PostgreSQL database performance by analyzing execution plans, identifying bottlenecks, and implementing advanced indexing strategies.

Spring Data JPA Best Practices

Implements high-performance Spring Data JPA repositories and entities using modern aggregate-centric patterns.

ClickHouse Analytics & I/O

Optimizes high-performance analytical workloads by implementing ClickHouse-specific database patterns and query best practices.

Ghost Database Migration Tool

Automates the process of creating, testing, and verifying database migrations within the Ghost CMS ecosystem.

PostgreSQL Table Design

Architects high-performance, production-ready PostgreSQL schemas using industry-standard best practices and data modeling patterns.