Database Management Claudeスキル

CQRS and Event Sourcing

Implements scalable architectural patterns for separated read/write models and immutable event logs to ensure system auditability.

CQRS & Event Sourcing Architect

Implements scalable, auditable system architectures using Command Query Responsibility Segregation and Event Sourcing patterns.

DuckDB Temporal Versioning

Implements in-process SQL databases with time-travel semantics, causality tracking, and deterministic replay capabilities.

CatColab Ologs

Constructs category-theoretic knowledge representations to define rigorous database schemas and conceptual models.

SQL Server 2025 & SqlPackage Support

Enables advanced SQL Server 2025 capabilities including native vector database support, AI model integration, and modernized deployment workflows.

Advanced T-SQL Patterns

Implements complex SQL Server techniques including recursive CTEs, temporal tables, and memory-optimized operations.

T-SQL Query Optimization

Optimizes SQL Server and Azure SQL Database performance through advanced T-SQL query tuning and execution plan analysis.

Azure SQL Optimization

Optimizes Azure SQL Database performance through platform-specific configurations, monitoring scripts, and scaling strategies.

T-SQL Functions Master

Provides a comprehensive reference and implementation patterns for T-SQL functions across SQL Server and Azure SQL Database versions.

Keboola CLI & Project Reviewer

Manages Keboola project configurations and executes comprehensive multi-agent reviews for SQL, data architecture, and financial logic.

Algebraic Database Schema Comparison

Analyzes and compares DuckDB and LanceDB architectures using category theory and algebraic data structures (ACSets).

Compositional ACSet Comparison

Compares complex data structures like DuckDB and LanceDB using algebraic databases and category-theoretic analysis.

Compositional ACSet Comparison

Compare database schemas and data structures using algebraic databases and persistent homology coverage analysis.

Keboola Configuration Manager

Simplifies the management of Keboola project structures, JSON configurations, and data pipeline transformations.

Windows Git Bash Path Manager

Resolves path conversion conflicts between Windows and Git Bash for SSDT, SqlPackage, and DACPAC workflows.

Database Architect & Drizzle ORM Specialist

Architects normalized PostgreSQL schemas and implements type-safe Drizzle ORM models with industry-standard best practices.

T-SQL Index Strategies

Optimizes SQL Server database performance through expert index design, selection, and maintenance strategies.

Domain Entity Modeling

Models domain entities from requirements using Domain-Driven Design (DDD) principles to define attributes, relationships, and state machines.

Flix-Datalog Reasoning

Implements Flix-based Datalog reasoning with lattice semantics and GF(3) coloring for declarative routing and skill composition.

Database Design Patterns

Architects scalable database schemas and optimizes query performance across relational and NoSQL systems.

Prisma Schema Design

Architects optimized Prisma database schemas using industry-standard patterns for models, relationships, and performance indexing.

TypeORM Entity Modeling

Defines and optimizes TypeORM database entities using standardized patterns for relations, indexes, and lifecycle hooks.

Database Migration Strategy

Executes complex database migrations and schema transformations using zero-downtime strategies and cross-ORM best practices.

Database Schema Designer

Architects robust data models for SQL and NoSQL databases using industry-standard normalization, indexing strategies, and migration patterns.

Prisma Migration Patterns

Manages database schema evolutions and migration workflows using Prisma ORM best practices.

Prisma Relations Patterns

Provides standardized implementation patterns for modeling and querying complex database relationships using Prisma ORM.

Mirrord DB Branching

Configures isolated database branches for safe, production-like development and testing without affecting live data.

PostgreSQL Query Patterns

Provides optimized PostgreSQL query patterns and best practices for robust database operations.

TypeORM Query Patterns

Provides standardized TypeORM query patterns and best practices for efficient database interaction.

Logseq DB Knowledge

Provides comprehensive guidance on working with Logseq's database-based data model, covering nodes, typed properties, classes, and advanced Datalog queries.