Database Management Claude 스킬

Slow Query Analysis & DB Tuning

Analyzes database slow query logs to identify performance bottlenecks and provide actionable indexing and optimization strategies.

TikTok Supabase Data Sync

Synchronizes TikTok engagement data and readings from ClickHouse to Supabase to keep web content updated.

Supabase Database Integrator

Configures a PostgreSQL database for ChatGPT Apps using Supabase for persistent data storage and secure user isolation.

Data Architecture Patterns

Implements a type-safe, single-source-of-truth data architecture using TypeScript and Zod for centralized project and personal information.

History & LocalStorage Manager

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

Diagnostic Playground

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

LoRAIro SQLAlchemy Repository Pattern

Implements type-safe SQLAlchemy repository patterns for consistent database operations and session management.

JOOQ Database Patterns

Implements type-safe SQL patterns and repository structures for robust database management using JOOQ and Kotlin.

Enterprise ERP Consultant

Architects and implements complex business logic for enterprise resource planning systems including finance, inventory, and supply chain modules.

Database Migration & Schema Evolution

Manages complex database migrations across multiple ORMs with zero-downtime strategies and automated rollback procedures.

Flyway Database Migrations

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

jOOQ Database Patterns

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

Convex Backend Development

Streamlines Convex backend development with standardized function syntax, schema definitions, and type-safe data modeling.

PostgreSQL Patterns & Best Practices

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

SQL Optimization Patterns

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

AgentDB Performance Optimization

Optimizes AgentDB vector databases using quantization, HNSW indexing, and batch operations to achieve massive performance gains and memory reduction.

SQL & Relational Databases Mastery

Master production-grade SQL optimization, schema design, and database performance tuning for data engineering workflows.

Database CLI Assistant

Manages and queries MySQL, PostgreSQL, SQLite, and Redis databases through Claude Code with mandatory schema discovery and safety guardrails.

AgentDB Vector Search

Implements ultra-fast semantic vector search and HNSW indexing for RAG systems and intelligent document retrieval.

SQLite Best Practices

Optimizes SQLite database performance and reliability through expert-level configuration and high-performance implementation patterns.

PostgreSQL Database Setup

Initializes PostgreSQL databases with standardized SQL schemas, Python setup scripts, and best-practice environment configurations.

Airtable PM Data Model

Provides a standardized data model reference for orchestrating Product Management workflows and requirements within Airtable.

Module Health Assessor

Analyzes and optimizes modular architecture health for Logseq Template Graphs by evaluating balance, cohesion, and dependencies.

Supabase Implementation Expert

Provides production-grade Supabase implementation, security auditing, and performance optimization for modern web applications.

Logseq DB Migration Expert

Guides the transition of Logseq knowledge bases from Markdown files to the advanced SQLite database architecture.

Migration Helper

Facilitates safe database and code migrations using zero-downtime strategies and proven implementation patterns.

Database Architect & Optimizer

Designs, optimizes, and manages SQL and NoSQL databases using industry-standard best practices for performance and scalability.

PostgreSQL Database Setup

Standardizes PostgreSQL database initialization with automated schema generation, setup scripts, and high-performance connection drivers.

ClickHouse Optimization & Analytics

Optimizes ClickHouse database performance with advanced table design, query patterns, and real-time analytical workflows.

ClickHouse Analytics & Data Engineering

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