Database Management Claudeスキル

Database Designer

Architects, optimizes, and migrates professional database schemas for SQL and NoSQL systems using expert-level design patterns.

Migration Architect

Designs and executes zero-downtime system migrations with automated rollback strategies and compatibility validation.

Consistency Patterns Knowledge

Provides expert guidance on consistency models, locking strategies, and distributed systems patterns for robust PHP applications.

Database Migration

Generates database migration files with automated schema changes and corresponding rollback logic.

Database Scaling Analyzer

Analyzes PHP applications for database access patterns that hinder horizontal scaling and primary database performance.

Database Replication & Sharding Knowledge

Implements scalable database architectures in PHP through application-level read/write splitting and replica lag management.

PHP Database Read-Write Proxy Generator

Generates robust database connection proxies for PHP 8.4 to implement seamless read/write splitting and replica routing.

PHP DDD Repository Generator

Generates DDD-compliant Repository interfaces and PHP 8.4 infrastructure implementations for clean architecture.

PHP Unit of Work Generator

Generates robust Unit of Work infrastructure for PHP 8.4 to ensure transactional consistency across multiple domain aggregates.

PHP Lazy Loading Analyzer

Optimizes PHP performance by identifying inefficient database loading patterns, missing pagination, and memory-intensive queries.

PHP N+1 Query Detector

Identifies and fixes inefficient N+1 database query patterns in PHP applications to optimize performance.

Caching Strategies & Redis Patterns

Provides a comprehensive knowledge base for implementing efficient caching patterns, invalidation strategies, and Redis data structures.

Transactional Outbox Pattern Knowledge

Implements and audits the Transactional Outbox pattern in PHP applications to ensure reliable event delivery and data consistency.

PHP Connection Pool Analyzer

Identifies and resolves database connection leaks, pool exhaustion, and lifecycle issues in PHP applications.

Event Sourcing Architecture Expert

Implements and audits high-performance Event Sourcing architectures using PHP 8.4 patterns and Domain-Driven Design principles.

PostgreSQL Development Standards

Enforces strict transaction safety, type-safe schema designs, and robust PostgreSQL naming conventions for reliable database architecture.

Backend Queries

Standardizes backend query implementation by applying specialized coding patterns and optimization guidelines.

PHP Batch Processing Optimizer

Identifies and refactors inefficient PHP loops that perform repetitive database, API, and file operations into high-performance batch processes.

PHP Cache-Aside Generator

Generates robust Cache-Aside infrastructure for PHP 8.4 applications with stampede protection and tag-based invalidation.

Backend Migrations

Manages database schema transitions and production migration workflows according to established backend engineering standards.

Backend Models

Standardizes the implementation and management of backend data models to ensure architectural consistency and best practices.

PHP Event Store Generator

Generates robust Event Store infrastructure for PHP 8.4 applications using Event Sourcing and DDD patterns.

PHP Query Efficiency Analyzer

Analyzes PHP code and SQL queries to identify performance bottlenecks, missing indexes, and inefficient data retrieval patterns.

PHP Snapshot Pattern Generator

Generates Snapshot pattern infrastructure for PHP 8.4 to optimize event sourcing aggregate rebuild performance.

PHP Database Index Auditor

Identifies missing database indexes and optimizes query performance within PHP and Doctrine-based applications.

PostgreSQL Schema Dumper

Exports a clean, stripped-down PostgreSQL database schema to a local file and copies the file path to the clipboard.

JPA Entity Creator

Generates robust, production-ready JPA entities following Spring Boot best practices and Domain-Driven Design principles.

Claimable Postgres

Provisions instant, temporary Postgres databases without requiring a login, signup, or credit card for rapid prototyping and testing.

Python Data Modeling & Dataclasses

Streamlines Python data modeling using dataclasses, attrs, and Pydantic for clean, type-safe structures with robust validation.

Ecto Schema Modeling

Models database entities in Elixir by defining Ecto schemas, complex associations, and embedded data structures.