Database Management Claude 技能

pg_dump Reference

Consults the official PostgreSQL pg_dump implementation to provide canonical guidance on system catalog queries and schema extraction.

Convex Real-time Development

Implements reactive data synchronization and live updates using Convex's automatic query subscriptions.

Migration Checker

Audits database migrations for schema safety, data integrity, and zero-downtime deployment patterns.

Sequelize Migration Expert

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

Prisma Expert

Architects and optimizes database schemas, migrations, and queries using the Prisma ORM.

PostgreSQL Syntax Reference

Consults PostgreSQL's internal parser and grammar rules to ensure precise SQL syntax implementation and DDL generation.

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 Assistant

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

PostgreSQL Table Designer

Architects high-performance, production-grade PostgreSQL schemas using modern best practices and idiomatic data patterns.

PostgreSQL Migration & Schema Expert

Provides comprehensive guidance and implementation patterns for robust, idempotent PostgreSQL database migrations and schema design.

Redis Data & Caching

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

CQRS Architectural Design

Implement Command Query Responsibility Segregation to optimize read and write operations in high-scale systems.

Convex Real-Time Sync

Implements reactive queries and real-time data synchronization using the Convex platform to create live-updating user interfaces.

Mongo TS

Executes native MongoDB query syntax directly from the command line with built-in safety features and flexible output formatting.

Backend Migration Standards

Enforces safe, reversible, and zero-downtime database schema evolutions following industry best practices.

CloudBase Web SDK Database Guide

Streamlines implementation of the CloudBase document database Web SDK for advanced data management and querying.

Backend Migration Standards

Manages database schema evolutions and data migrations using zero-downtime strategies and reversible standards.

PostgreSQL Schema Validator

Validates PostgreSQL database schemas by comparing live database states, pg_dump outputs, and system catalog queries.

CloudBase Web SDK Database Tools

Facilitates seamless data management in web applications using the Tencent CloudBase Document Database Web SDK.

InsForge Database Schema Patterns

Provides expert PostgreSQL schema patterns and RLS policies optimized for InsForge and PostgREST applications.

SQLModel ORM Helper

Design and implement production-grade database layers using SQLModel with SQLAlchemy 2.0 patterns for FastAPI projects.

SQLModel ORM Helper

Designs and implements production-grade database layers using SQLModel and SQLAlchemy 2.0 patterns for Python projects.

InsForge Schema Patterns

Provides expert PostgreSQL schema designs and Row-Level Security (RLS) patterns optimized for the InsForge and PostgREST ecosystem.

SQL Optimization Patterns

Optimizes database performance by implementing efficient indexing, query refactoring, and execution plan analysis.

SQL Optimization Patterns

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