Database Management Claudeスキル

Redis Cache Manager

Optimizes backend performance by automating Redis caching implementations and management strategies.

Data Pipeline Schema Validator

Validates data structures and ensures schema integrity within complex ETL and data processing pipelines.

Memcached Config Helper

Optimizes and automates Memcached configuration for high-performance backend caching environments.

Data Engineering Patterns

Implements professional data engineering patterns for ETL pipelines, Spark processing, and robust data warehouse modeling.

Migration Architect

Plans and executes zero-downtime system migrations with robust validation and automated rollback strategies.

Database Archival System

Automates the archival of historical database records to secondary tables or cloud storage to optimize performance and reduce costs.

Supabase Rate Limiting & Retry

Implements resilient rate limiting, exponential backoff, and idempotency patterns for Supabase API interactions.

Database Designer

Optimizes and manages complex database architectures through expert schema analysis, indexing strategies, and zero-downtime migration planning.

Supabase Local Development Loop

Streamlines Supabase development by configuring local environments with hot reloading and integrated testing suites.

PostgreSQL Optimization

Optimizes PostgreSQL database performance through advanced indexing, query plan analysis, partitioning, and connection pooling.

Elasticsearch Index Manager

Automates the creation, optimization, and lifecycle management of Elasticsearch indices using industry best practices.

Database Recovery Manager

Automates database backup, optimization, and point-in-time recovery procedures for PostgreSQL and MySQL.

Database Audit Logging System

Implements comprehensive database audit trails for PostgreSQL and MySQL to track data modifications and ensure regulatory compliance.

Database Migrations

Implements safe, zero-downtime database schema and data migrations across multiple ORMs and SQL dialects.

Data Partitioner

Optimizes data pipeline performance by implementing efficient partitioning strategies for ETL, Spark, and streaming workflows.

CTE Query Builder

Simplifies complex SQL query construction using Common Table Expressions for more readable and maintainable data analysis workflows.

Supabase Performance & Scaling

Optimizes Supabase performance through comprehensive load testing, horizontal auto-scaling, and proactive capacity planning.

Complex Join Helper

Simplifies the creation of intricate SQL join logic and data analytics queries through automated patterns and best practices.

Juicebox Data Migration Deep Dive

Facilitates complex data transfers and transformation pipelines for migrating recruiting data into the Juicebox platform.

ClickHouse Analytics & Data Engineering

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

ClickHouse Analytics & Data Engineering

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

PostgreSQL Expert

Streamlines PostgreSQL development, administration, and performance tuning through comprehensive documentation and best practices.

WorldCrafter Database Setup

Generates Prisma models, database migrations, and Row-Level Security policies to establish a secure data foundation for world-building features.

Database Query Safety

Prevents silent failures and data loss in Supabase and PostgREST queries by identifying eight critical implementation pitfalls.

Data Integrity & Financial Accuracy

Enforces strict accuracy and traceability standards for data display, transformation, and storage within financial applications.

Migration Safety & Reliability

Safeguards database schema changes with idempotent patterns and PostgreSQL best practices to prevent migration failures and data loss.

Neon Database Manager

Manages Neon serverless Postgres databases, branching workflows, and connection strings directly through the CLI.

Supabase pgvector Setup

Configures pgvector on Supabase to enable high-performance semantic search, RAG systems, and hybrid search capabilities.

Rails Performance Optimization

Optimizes Ruby on Rails applications by identifying and resolving N+1 queries, implementing efficient caching, and managing background processing.

Snowflake Automation

Automates Snowflake data warehouse operations including schema discovery, metadata inspection, and SQL execution via Composio MCP.