Database Management Claude 스킬

ClickHouse Query & Schema Optimizer

Optimizes ClickHouse database performance through expert schema design, primary key ordering, and query tuning.

History & LocalStorage Manager

Manages persistent state and debate history within localStorage while ensuring data integrity and backward compatibility.

PostgreSQL Best Practices for Supabase

Optimizes PostgreSQL performance and schema design using Supabase-maintained best practices and prioritized optimization rules.

Data Engineering & Analytics

Architects robust data pipelines, optimizes SQL queries, and manages large-scale ETL/ELT workflows across modern data warehouses.

Postgres Performance & Best Practices

Optimizes PostgreSQL database performance and schema design using Supabase-vetted best practices and implementation patterns.

Redis Replication & High Availability

Configures and manages Redis master-replica architectures and Sentinel high-availability clusters for resilient data scaling.

Redis Performance Optimizer

Optimizes Redis environments through advanced memory analysis, slow log troubleshooting, and high-concurrency benchmarking.

Supabase Next.js Integration

Integrates Supabase with Next.js App Router projects using secure patterns for authentication, database management, and row-level security.

Redis Lists & Sets Master

Implements high-performance Redis data structures including reliable queues, unique collections, and complex set operations for distributed applications.

Drizzle ORM Development

Enforces database query conventions, type safety, and permission filtering using standardized Drizzle ORM patterns.

AgentDB Advanced Features

Powers distributed AI systems with low-latency QUIC synchronization, hybrid vector search, and multi-database management.

PocketBase API Field Adder

Provides programmatic guidance for adding fields to PocketBase collection schemas using the JavaScript SDK.

Subgraph Migration

Migrates blockchain data indexers from TheGraph subgraphs to Envio HyperIndex for faster performance and modern TypeScript development.

World Weaver Memory Consolidator

Optimizes AI memory structures through automated clustering, pruning, and relationship strengthening to maintain long-term context efficiency.

Redis Transaction Pro

Implements production-grade Redis transaction patterns using MULTI/EXEC, optimistic locking with WATCH, and atomic Lua scripting.

PostgreSQL Expert

Optimizes PostgreSQL performance, designs scalable architectures, and troubleshoots complex database internals with production-grade precision.

Diagnostic Playground

Generates interactive HTML dashboards populated with real Supabase data to visualize application state and debug complex issues.

Postgres SQL Style Guide

Standardizes PostgreSQL development with comprehensive rules for naming conventions, schema design, and query formatting.

Redis Cluster Manager

Manages production-grade Redis Cluster operations including horizontal scaling, hash slot distribution, and automated failover procedures.

Redis Hashes and Sorted Sets

Optimizes Redis data management with advanced patterns for Hashes and Sorted Sets, including leaderboards, object storage, and ranking systems.

Flyway Database Migrations

Manages database schema changes and versioning through standardized Flyway migration patterns and PostgreSQL best practices.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance through high-performance schema design, advanced query patterns, and efficient data engineering practices.

jOOQ Database Patterns

Implements type-safe SQL queries and repository patterns using jOOQ for robust Kotlin and Java database interactions.

Notion Database Repair Expert

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

PostgreSQL Monitoring

Monitors PostgreSQL database performance and health through automated metric collection, observability patterns, and diagnostic alerting.

Convex Backend Development

Streamlines the implementation of Convex backend features using Zod validation, custom function wrappers, and type-safe database interactions.

ClickHouse Cloud Management

Manages ClickHouse Cloud users, permissions, and connections using SQL over the HTTP interface.

Frappe DocType Builder

Constructs complete DocType definitions for the Frappe Framework, including fields, permissions, and configurations.

Data Engineer Agent

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

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, EXPLAIN plan analysis, and efficient query pattern implementation.