Database Management Claudeスキル

PostgreSQL Patterns & Best Practices

Optimizes PostgreSQL database architecture, indexing, and security using Supabase-inspired best practices.

Optimistic Locking Patterns

Implements robust concurrency control in database repositories using version-based optimistic locking to prevent lost updates.

Database Backend Patterns

Implements robust, production-ready database patterns including transactions, pagination, and query optimization to ensure data integrity and performance.

ClickHouse Analytics & Data Engineering

Provides optimized ClickHouse database schemas, high-performance query patterns, and data engineering best practices for OLAP workloads.

JPA Patterns for Spring Boot

Implements high-performance JPA and Hibernate data modeling patterns for Spring Boot applications.

Postgres Patterns

Provides optimized PostgreSQL patterns for schema design, indexing, and high-performance querying based on Supabase best practices.

ClickHouse Analytics & Engineering

Optimizes high-performance analytical workloads and data engineering tasks using ClickHouse database patterns and best practices.

Kotlin Exposed DB Patterns

Implements production-grade JetBrains Exposed ORM patterns for Kotlin database access, including DSL, DAO, and migrations.

ClickHouse Analytics & Data Engineering

Provides expert guidance on ClickHouse schema design, high-performance query optimization, and real-time data engineering best practices.

PostgreSQL Patterns & Best Practices

Optimizes PostgreSQL database performance and security through standardized schema design, indexing strategies, and RLS policies.

Database Migration Patterns

Implements safe, reversible database schema changes and zero-downtime migration strategies across multiple ORMs and SQL dialects.

PostgreSQL Patterns

Optimizes PostgreSQL performance, schema design, and security using battle-tested industry patterns and indexing strategies.

Database Migration Expert

Implements safe, zero-downtime database schema changes and migrations across multiple frameworks and SQL dialects.

ClickHouse Analytics Patterns

Optimizes ClickHouse database performance through expert schema design, analytical query patterns, and efficient data ingestion strategies.

ClickHouse Analytics Patterns

Optimizes ClickHouse database performance with specialized table patterns, query optimization techniques, and high-performance analytical workflows.

JPA & Hibernate Patterns

Implements industry-standard JPA and Hibernate patterns for robust data modeling and high-performance database interactions in Spring Boot.

Spring Boot JPA Patterns

Optimizes Spring Boot data access by providing proven JPA and Hibernate patterns for entity design, query performance, and transaction management.

JPA & Hibernate Patterns for Spring Boot

Implements high-performance JPA and Hibernate data modeling patterns for robust Spring Boot applications.

ClickHouse Analytics & Data Engineering

Provides high-performance ClickHouse database patterns, query optimization techniques, and advanced analytical workflows.

PostgreSQL Patterns

Provides optimized PostgreSQL schema patterns, indexing strategies, and security best practices based on Supabase standards.

PostgreSQL Patterns

Provides optimized database patterns, schema best practices, and indexing strategies for PostgreSQL based on Supabase standards.

SQL Code Review & Optimization

Performs comprehensive SQL code reviews to ensure security, high performance, and best practices across all major database engines.

SQL Performance Optimizer

Optimizes database performance through advanced query tuning, indexing strategies, and execution plan analysis across all major SQL engines.

Entity Framework Core Expert

Provides expert guidance and implementation patterns for high-performance Entity Framework Core database management.

Dataverse MCP Configurator

Automates the setup of Dataverse MCP servers for GitHub Copilot to enable AI-powered data and schema interactions.

Microsoft Fabric Lakehouse

Architects and optimizes Microsoft Fabric Lakehouse solutions using best practices for unified data storage, Delta Lake management, and cross-cloud integration.

Power BI Model Design Review

Evaluates Power BI data models to optimize architecture, relationships, and performance based on Microsoft best practices.

Azure Cosmos DB Data Modeler

Guides developers through the process of designing optimized NoSQL data models for Azure Cosmos DB based on application-specific access patterns.

Dataverse Python Solution Builder

Generates complete, production-ready Python solutions for Microsoft Dataverse SDK use cases with integrated architecture recommendations.

Snowflake Semantic View Manager

Automates the creation, validation, and management of Snowflake semantic views using the Snowflake CLI.