Database Management Claude 技能

PostgreSQL pg_dump Reference Guide

Consults PostgreSQL's pg_dump source code to provide authoritative guidance on system catalog queries and schema extraction patterns.

PostgreSQL Migrations & Schema Management

Provides expert guidance on PostgreSQL migrations, including idempotent patterns, index optimization, and resolving complex database errors.

PostgreSQL Schema Validator

Connects to live PostgreSQL databases to validate schema assumptions, perform system catalog queries, and cross-validate DDL outputs.

PostgreSQL Schema Design

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

Database Code Reviewer

Reviews database migrations, query performance, and transaction logic to ensure data integrity and prevent production downtime.

Neon CLI Expert

Manages serverless PostgreSQL projects and branching workflows using the Neon CLI directly within your development environment.

PostgreSQL Table Design

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

Drizzle ORM Setup & Patterns

Configures Drizzle ORM for Node.js applications with type-safe schemas and SQL-first query patterns.

Node.js Database Query Optimization

Optimizes database performance in Node.js applications by implementing indexing, pagination, and N+1 query prevention strategies.

Database Migration Strategies

Implements safe, zero-downtime database schema changes and data migrations using industry-standard patterns and ORM best practices.

Supabase Infrastructure Manager

Manages Supabase projects including database migrations, Edge Functions deployment, and local development environments via the Supabase CLI.

Database Implementer

Generates robust database schemas, versioned migrations, and optimized data access layers for efficient application development.

PostgreSQL Explorer & Debugger

Explores, debugs, and manages PostgreSQL databases using AI-optimized JSON outputs and comprehensive schema discovery tools.

Data Engineering

Standardizes data pipeline design, ETL processes, and schema evolution using data-as-a-product principles.

PowerSync Local-First Sync

Builds offline-capable, local-first TypeScript applications with real-time SQLite-to-backend synchronization.

PostgreSQL Guide

Retrieves real-time, official PostgreSQL documentation for accurate SQL syntax, database configuration, and performance optimization.

East Node I/O

Provides a comprehensive suite of I/O functions for the East programming language, enabling seamless integration with databases, cloud storage, and file formats.

Persistence Layer Auditor

Audits and optimizes SQLite persistence layers by identifying unused tables, broken method calls, and schema inconsistencies.

Event Store Design Patterns

Designs and implements robust event storage solutions for event-sourced architectures and high-performance distributed systems.

Event-Sourced Projection Patterns

Builds efficient read models and materialized views from event streams to optimize query performance in event-sourced systems.

PostgreSQL Syntax & Grammar Reference

Consults PostgreSQL's internal parser and grammar rules to provide precise guidance on SQL syntax and DDL structure.

Supabase Database Integration

Query and interact with Supabase databases using real-time subscriptions and PostgreSQL-compatible syntax while respecting Row Level Security policies.

Database Connection Pooling

Optimizes database performance and reliability by configuring robust connection pools for SQLAlchemy across traditional and serverless architectures.

Alembic Migration Manager

Manages database schema and data migrations using Alembic through standardized workflows and production-ready best practices.

Database Schema Design

Designs robust, scalable relational database schemas through structured workflows, entity-relationship modeling, and SQL generation.

DBF Data Analysis

Analyzes and converts legacy Thai accounting DBF databases into efficient Parquet format for high-performance SQL querying with DuckDB.

Splunk KV Store Manager

Manages Splunk App Key Value Store collections and records for persistent metadata and application state storage.

Database Operations

Implements high-performance, production-ready database architectures using async patterns and modern ORM best practices.

Backend Migrations

Manages database schema changes and data migrations using industry best practices to ensure data integrity and zero-downtime deployments.

Model Requirements Gatherer

Guides the structured gathering of requirements for new and existing BigQuery data models to ensure robust ETL pipeline planning.