Database Management Claude 스킬

Snowflake Semantic Views

Automates the creation, validation, and optimization of Snowflake semantic views and data layers via the Snowflake CLI.

Architecture Performance Optimizer

Analyzes and resolves performance bottlenecks across database queries, API endpoints, and frontend rendering frameworks.

Database Migration Manager

Manages database schema evolution by generating and executing version-controlled migrations for PostgreSQL, MySQL, SQLite, and MongoDB.

Database Data Seeder Generator

Generates realistic, relationally consistent test data and database seed scripts for development and testing environments.

ClickHouse Analytics Patterns

Implements high-performance ClickHouse database patterns, query optimizations, and data engineering best practices for analytical workloads.

JPA Design Patterns

Optimizes Spring Boot data layers using best-practice JPA and Hibernate patterns for modeling, performance, and scalability.

Data Engineer Agent

Builds and maintains robust data pipelines, analytics infrastructure, and ETL processes with high data quality standards.

Database Performance & Anti-Patterns

Identifies and remediates common database performance bottlenecks like N+1 queries, unbounded fetches, and connection pool issues.

Row-Level Security Patterns

Implements robust database row-level security policies for multi-tenant and user-scoped data architectures.

Supabase Migrations & Schema Management

Manages Supabase database schemas and migrations through automated CLI commands and best-practice SQL patterns.

Data Management Patterns

Provides standardized patterns for zero-downtime migrations, automated backups, data retention policies, and GDPR compliance workflows.

Database Management

Architects, optimizes, and manages relational and NoSQL databases to ensure high performance, data integrity, and scalability.

Database Anti-Pattern Detection

Identifies and resolves common database performance bottlenecks and inefficient query patterns in modern ORMs.

Data Management Patterns

Implements robust database strategies for zero-downtime migrations, automated backups, and regulatory data compliance.

PostgreSQL Read-Only Explorer

Executes safe, read-only SQL queries and explores schemas across multiple PostgreSQL databases.

Database Design Architect

Architects production-grade SQL and NoSQL databases with automated schema validation and performance optimization patterns.

Laneweaver Database Design

Designs robust PostgreSQL 17 schemas and Supabase migrations tailored for the LaneweaverTMS logistics ecosystem.

PostGIS Geospatial Architecture

Implements advanced geospatial features including geofencing, spatial indexing, and real-time fleet tracking using PostGIS and PGRouting.

Unified Database Management

Manages both MongoDB and PostgreSQL environments, from schema design and query optimization to production administration and migrations.

SQLite Performance & Best Practices

Configures Claude to implement high-performance SQLite patterns including optimized PRAGMA settings, strict typing, and efficient bulk data loading.

Database Architect & Management

Designs, optimizes, and manages relational and NoSQL databases using industry-standard patterns and performance-tuning techniques.

SQL Query & Schema Design

Provides expert SQL patterns for complex database querying, efficient schema design, and performance optimization.

Supabase Integration

Streamlines Supabase backend development by automating database schema design, Row-Level Security (RLS) policies, and Edge Function deployment.

Lutece 8 DAO & Home Patterns

Implements standardized DAO and Home layer patterns for Lutece 8 development using best practices for data persistence.

Notion Database Repair Expert

Diagnoses and fixes corrupted Notion databases by repairing schemas, cleaning orphan properties, and resolving API validation errors.

TimescaleDB Expert

Optimizes time-series data management and PostgreSQL analytics through advanced hypertables, compression, and performance tuning.

Dojo Indexer Management

Configures and manages Torii indexers to provide GraphQL, gRPC, and SQL access for Dojo world states.

Dojo Migration Manager

Manages world migrations, handles breaking schema changes, and facilitates Dojo Engine version upgrades.

PostgreSQL & Drizzle ORM

Architects type-safe database schemas and high-performance PostgreSQL 18 queries using Drizzle ORM best practices.

Spring Data JPA Expert

Simplifies database access by implementing robust repository patterns, custom queries, and performance-tuned data modeling for Spring Boot applications.