Database Management Claude 스킬

Spring Boot JPA & Hibernate Patterns

Provides optimized JPA and Hibernate patterns for building high-performance, scalable Spring Boot data layers.

JPA Patterns for Spring Boot

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

PostgreSQL Patterns

Optimizes PostgreSQL schema design, indexing strategies, and query performance using industry-standard best practices.

Postgres Patterns

Optimizes PostgreSQL database schemas, queries, and security configurations using industry-proven patterns and Supabase best practices.

PostgreSQL Patterns & Optimization

Optimizes PostgreSQL database performance and security through standardized schema design, indexing strategies, and performance tuning patterns.

Rails Delegated Types Pattern

Implements a unified container model for complex Ruby on Rails content systems with 5 or more distinct types.

Vanilla Rails Models

Enforces production-grade Rails model patterns including state-as-records, namespaced concerns, and invocation-based method ordering.

Vanilla Rails Data Modeling

Enforces high-performance, multi-tenant database schema patterns and migrations for Ruby on Rails applications based on 37signals conventions.

SQL Query Optimizer

Analyzes and optimizes SQL queries to improve performance by identifying bottlenecks and suggesting efficient indexing strategies.

Supabase RLS Policy Expert

Generates production-ready, optimized PostgreSQL row-level security (RLS) policies for Supabase databases following security best practices.

PostgreSQL Table Design

Designs high-performance, production-ready PostgreSQL schemas following industry best practices and modern database patterns.

ActiveRecord Patterns & Optimization

Optimizes database interactions by providing enterprise-grade ActiveRecord query patterns, association designs, and PostgreSQL-specific performance strategies.

dbt Development

Validates dbt models against standardized coding conventions to ensure consistent naming, SQL structure, testing coverage, and documentation.

Recce dbt Data Validation

Automates data validation and impact analysis for dbt projects using the Recce framework.

Prisma Database Patterns

Implements production-ready Prisma ORM patterns for database schema design, migrations, and high-performance queries.

Database Assistant

Expertly designs database schemas, optimizes complex SQL queries, and manages data migrations with industry-leading best practices.

Databases & Architecture

Design and implement scalable database schemas, system architectures, and robust APIs for modern software applications.

Supabase Setup & Management

Configures and secures Supabase backends including database schemas, RLS policies, authentication providers, and Edge Functions.

SaaS Production Templates

Generates production-ready boilerplate for Supabase authentication, environment validation, and core Next.js layouts.

Database Stored Procedure Generator

Generates production-grade stored procedures, functions, and triggers across major SQL databases to streamline complex backend logic and data integrity.

Optimistic Locking Patterns

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

Domain-Driven Design Modeling

Models complex business logic using Domain-Driven Design patterns like Entities, Value Objects, and Aggregates.

Database Connection Pooler

Optimizes and manages database connection pooling across PostgreSQL, MySQL, and MongoDB environments to ensure high performance and resource efficiency.

Supabase SDK & Auth Setup

Installs and configures the Supabase SDK and CLI while managing authentication credentials for seamless backend integration.

Database Management & Optimization

Simplifies database schema design, query optimization, and administration for MongoDB and PostgreSQL environments.

Database Backend Patterns

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

Logseq Datalog Expert

Builds and optimizes complex Datalog queries for Logseq's database-driven graphs.

Logseq Database Schema Expert

Explains Logseq's Datascript database architecture, including entity relationships, built-in classes, and property type systems.

Wasp Dev Server Manager

Orchestrates the Wasp development environment by managing local servers, database containers, and schema migrations.

Database Schema

Enforces strict database schema conventions for Drizzle ORM and PostgreSQL to ensure consistent table structures, constraints, and indexing patterns.