Database Management Claudeスキル

Database Management & Design

Optimizes database performance and manages schema design, migrations, and complex SQL query generation for relational databases.

Backend Queries

Implements structured database queries and repository patterns using Prisma ORM to maintain a robust layered architecture.

Backend Migrations

Manages PostgreSQL schema changes and Prisma database migrations following a split-architecture pattern and strict coding standards.

dbt Model Builder

Constructs standardized dbt models following Kimball dimensional patterns and modern testing configurations.

Data Quality Test Generator

Generates comprehensive dbt test suites using modern 1.10+ syntax to ensure data integrity and structural consistency across analytical models.

Backend Queries

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

Backend Models

Manages database model configurations, relationships, and validation logic to ensure robust data structures and ORM integrity.

Backend Models

Defines robust database models and schemas with precise ORM mappings, relationships, and data integrity constraints.

Backend Queries

Writes efficient, secure database queries while preventing N+1 problems and SQL injection vulnerabilities.

Backend Migrations

Manages database schema evolutions and data migrations using industry-standard tools and zero-downtime best practices.

PostgreSQL Schema Design Expert

Architects high-performance PostgreSQL databases using industry-standard schema design, indexing strategies, and data integrity patterns.

Sequelize Migration Expert

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

Database Management

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

Backend Queries

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

Backend Migrations

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

MongoDB Aggregation Optimization

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

Backend Queries

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

Backend Migrations

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

PostgreSQL Database Development

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

AgentDB Vector Search

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

Supabase Expert

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

Mongo TS

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

AgentDB Performance Optimization

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

dbt Data Modeling Expert

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

Warehouse Optimization

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

Database Migration Master

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

Supabase SQLAlchemy Integration

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

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.

Database Designer

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

Supabase CLI

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