Database Management Claude 技能

Devops Database

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

ORM Reviewer

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

PostgreSQL Table Design

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

Data Governance Manager

Manages data lineage, metadata cataloging, access control, and compliance standards for modern data platforms.

Data Modeling Essentials

Designs optimized database schemas, dimensional models, and normalized structures for efficient data analytics and storage.

Pipeline Design

Architects robust ETL/ELT data pipelines with standardized patterns for reliability and scalability.

Supabase CLI

Manages Supabase local development environments, database migrations, and multi-language type generation via comprehensive CLI command guidance.

Database Designer

Infers and generates database schemas, migrations, and ORM models directly from natural language feature descriptions.

SQL Batching

Prevents D1/SQLite 'too many SQL variables' errors by automatically batching Drizzle ORM queries with dynamic arrays.

CHGIS Temporal Gazetteer

Queries the China Historical GIS Temporal Gazetteer API to retrieve and analyze historical Chinese placenames and administrative structures from 222 BCE to 1911 CE.

Supabase SQLAlchemy Integration

Configures high-performance SQLAlchemy async patterns for Supabase, including Row Level Security (RLS) authentication and optimized connection pooling.

Database Migration Master

Facilitates seamless database schema and data migrations across multiple ORMs with a focus on zero-downtime strategies and safety.

MySQL Database Skill

Executes safe SELECT queries against MySQL and MariaDB databases with built-in connection pooling and SQL injection prevention.

Warehouse Optimization

Optimizes data warehouse performance through efficient partitioning, query tuning, and cost-effective resource management.

dbt Data Modeling Expert

Implements industry-standard dbt patterns for scalable data transformation, automated testing, and comprehensive documentation.

Database Schema Design

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

AgentDB Performance Optimization

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

Postgres Query Optimization

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

Mongo TS

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

Supabase Expert

Implements high-performance database architectures, secure Row Level Security policies, and type-safe data services for Supabase environments.

Sequelize Model Expert

Standardizes Sequelize ORM model definitions and best practices for high-performance PostgreSQL implementations.

AgentDB Vector Search

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

PostgreSQL Database Development

Provides expert guidance on PostgreSQL schema design, Alembic migrations, SQLAlchemy patterns, and query optimization for high-performance database applications.

Backend Migrations

Generates robust database migrations following Laravel best practices for reversible schema changes and optimal performance.

Backend Queries

Optimizes database performance and security through efficient query patterns, eager loading, and transaction management.

MongoDB Aggregation Optimization

Optimizes MongoDB aggregation pipelines through strategic stage ordering, index utilization, and performance-driven query patterns.

Backend Migrations

Manages database schema changes through reversible migrations, clear naming conventions, and safe deployment practices for backend services.

Backend Queries

Writes secure, optimized database queries and data access logic using industry best practices for performance and scalability.

Database Management

Configures and manages TinyDB document databases for efficient JSON-based data persistence in Python applications.

Sequelize Migration Expert

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