Database Management Claudeスキル

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.

Query Performance Analyzer

Analyzes database EXPLAIN plans to identify performance bottlenecks and provide actionable SQL optimization recommendations.

Drizzle Cube Definition

Defines type-safe semantic layer cubes using Drizzle ORM for multi-tenant analytics and business logic abstraction.

Database Designer

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

Backend Migrations

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

Supabase Migration Toolkit

Manages Supabase database migrations using standardized naming conventions, automated linting, and security-first SQL templates.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers across major SQL databases using natural language.

Database Deadlock Detector

Detects, analyzes, and prevents database deadlocks by monitoring transaction patterns and lock contention in real-time.

Database Deadlock Detector

Detects, analyzes, and resolves database deadlocks by monitoring transaction patterns and lock contention in real-time.

Stripe Database Sync

Syncs Stripe data to a PostgreSQL database for seamless querying, reporting, and backend integration.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers for PostgreSQL, MySQL, and SQL Server to optimize database logic.

Backend Queries

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

Go Model Query Builder

Constructs type-safe database queries using a standardized Options API for Go backend services.

Backend Models

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

Stripe Sync Database Migrations

Automates the setup and management of PostgreSQL database schemas for synchronizing Stripe data.

Backend Migrations

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

Task Search

Implements robust search capabilities for task management applications, including keyword matching, relevance ranking, and multi-criteria filtering.

MongoDB Aggregation Optimization

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

Backend Models

Defines and structures database schemas, entities, and relationships while ensuring data integrity and performance through constraints and indexing.

Backend Queries

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

SurrealDB for Dart

Integrates SurrealDB into Dart and Flutter applications with support for embedded databases, ORM features, and AI-powered vector search.

PostgreSQL Database Development

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

SQL Query Optimizer

Analyzes and optimizes SQL queries to enhance database performance through index recommendations and structural rewrites.

Supabase Expert

Manages Supabase database operations, security policies, and edge functions following project-specific standards and real-time state verification.

SQLAlchemy Conversion

Converts asyncpg database code to SQLAlchemy 2.0+ asynchronous patterns while preserving performance and transaction integrity.

AsyncPG Database Detection

Scans Python and FastAPI projects to identify asyncpg imports, connection patterns, and query logic for migration to SQLAlchemy.

Supabase SQLAlchemy Integration

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

Database Connection Pooler

Optimizes database connection pooling and lifecycle management to enhance application performance and resource efficiency.