Database Management Claude 스킬

Databases & Architecture

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

Database Assistant

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

Supabase Typed Query

Builds type-safe, functional Supabase queries using chainable APIs and entity-based CRUD patterns for robust database interactions.

AgentDB Advanced Features

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

TikTok Supabase Data Sync

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

PostgreSQL Monitoring

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

Caching Conventions

Enforces standardized caching patterns across React, Next.js, Redis, and Cloudinary layers to ensure consistent data performance and invalidation logic.

Conversation State Management

Implements robust, database-persisted conversation tracking for stateless AI agents using PostgreSQL.

Prisma Database Patterns

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

Recce dbt Data Validation

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

Data Design & Architecture

Designs efficient, scalable, and maintainable data structures and schemas using industry-best practices for SQL and NoSQL databases.

Postgres SQL Style Guide

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

PostgreSQL Advanced Query Architect

Master complex PostgreSQL query patterns including CTEs, window functions, and recursive joins for high-performance data operations.

PostgreSQL Scaling & Performance

Implements advanced PostgreSQL scaling strategies including partitioning, connection pooling, and high-availability replication.

Airtable PM Data Model

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

Data Engineering & Analytics

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

PostgreSQL Performance Optimizer

Optimizes PostgreSQL database performance through automated query analysis, advanced indexing strategies, and database configuration tuning.

Notion Database Repair Expert

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

PostgreSQL Backup & Recovery

Implements production-ready PostgreSQL backup strategies including logical, physical, and point-in-time recovery patterns.

PostgreSQL Admin

Manages PostgreSQL database security, role-based access control, and routine maintenance operations.

PostgreSQL Extensions & Optimization

Optimizes PostgreSQL databases by installing, configuring, and implementing essential extensions for performance, search, and data modeling.

PostgreSQL JSONB Mastery

Optimizes JSONB data operations within PostgreSQL by implementing production-ready query patterns, indexing strategies, and complex transformations.

SQL Query & Schema Design

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

Database Diff & Migration Adapter

Compares database schemas and generates transaction-safe migration scripts and rollback procedures for PostgreSQL and MySQL.

Database Architect & Management

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

Migration Helper

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

Database Data Seeder Generator

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

Logseq DB Migration Expert

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

Supabase Implementation Expert

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

Database Migration Manager

Generates production-ready Supabase migrations with idempotent SQL, strict naming conventions, and advanced RLS security patterns.