Database Management Claude 技能

MongoDB Transactions

Implements robust ACID transactions and multi-document operations for MongoDB data consistency.

Drizzle Schema & Migration Manager

Standardizes and automates the Drizzle ORM schema management, migration generation, and database seeding workflow.

ORM Code Generator

Generates production-ready ORM models and database schemas from natural language descriptions or existing database structures.

PostgreSQL Table Design

Architects optimized PostgreSQL schemas using industry-standard best practices for data integrity and high-performance indexing.

AgentDB Performance Optimization

Optimizes vector database performance and memory efficiency through advanced quantization techniques, HNSW indexing, and intelligent caching strategies.

AgentDB Vector Search

Implements high-performance semantic vector search and intelligent document retrieval using HNSW indexing and quantization for sub-millisecond querying.

AgentDB Vector Search

Implements high-performance semantic vector search and document retrieval for RAG systems and intelligent knowledge bases.

AgentDB Advanced Features

Implements advanced vector database capabilities including QUIC synchronization, hybrid search, and distributed multi-agent coordination.

Devops Database

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

Neon Postgres Connection & Migrations

Configures reliable PostgreSQL connections and manages schema migrations for Neon's serverless database platform.

LLM Data Layer Architecture

Implements a robust 2-layer architecture to manage LLM extraction logs while protecting human-verified data integrity.

ORM Reviewer

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

Database Migration & Schema Management

Execute database migrations across multiple ORMs and platforms using zero-downtime strategies and robust rollback procedures.

Sequelize Migration Expert

Provides battle-tested Sequelize migration patterns and best practices for safe PostgreSQL schema changes.

SQL Optimization Patterns

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

PostgreSQL Table Design

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

OP Database Metadata Manager

Provides specialized SQL query templates for managing and exploring v3_metadata database structures, including business objects and custom fields.

Universal Database Query Tool

Executes and manages SQL queries while providing structured schema insights and formatted data results via MCP tools.

Common Database Queries

Provides a standardized workflow and SQL templates for efficient database querying and structured result analysis using the exec_sql tool.

Black Lake DB Metadata Helper

Accesses and queries Black Lake v3_metadata database tables for object codes, events, custom fields, and system configurations.

Blacklake User & Organization DB Query

Queries tenant and organizational data from the v3_user database using standardized SQL templates and structured reporting.

Blacklake E-Report DB Assistant

Provides SQL query templates and automated reporting for the v3_e-report database to manage and analyze alert configurations.

Database Migration & Schema Management

Executes seamless database migrations across multiple ORMs and platforms using zero-downtime strategies and robust rollback procedures.

Database Migration Assistant

Executes and manages database schema migrations, data transformations, and zero-downtime deployment strategies across major ORMs.

PostgreSQL Table Design

Designs optimized PostgreSQL schemas using industry best practices for performance, data integrity, and scalability.

Redis Data & Caching

Optimizes application performance through Redis caching, real-time pub/sub messaging, and distributed data structures.

Supabase Query Optimizer

Optimizes Supabase PostgreSQL database performance by analyzing execution plans and implementing advanced indexing and RLS strategies.

SQL Optimization Patterns

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

PostgreSQL Table Design

Architects optimized, production-ready PostgreSQL schemas using industry best practices for data integrity and performance.

SQL Expert

Simplifies complex SQL query writing, database schema design, and performance optimization across major relational database systems.