Database Management Claudeスキル

Conversation State Management

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

Database Management

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

Postgres Best Practices

Optimizes PostgreSQL performance, schema design, and security using Supabase-vetted standards and implementation patterns.

PostgreSQL Best Practices for Supabase

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

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.

Database Schema

Enforces strict database schema conventions for Drizzle ORM and PostgreSQL to ensure consistent table structures, constraints, and indexing patterns.

Supabase Typed Query

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

Spring Boot JPA & Hibernate Patterns

Provides optimized JPA and Hibernate patterns for building high-performance, scalable Spring Boot data layers.

JPA Patterns for Spring Boot

Implements high-performance JPA and Hibernate data modeling patterns for Spring Boot applications.

Data Design & Architecture

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

PostgreSQL Patterns

Optimizes PostgreSQL schema design, indexing strategies, and query performance using industry-standard best practices.

Postgres Patterns

Optimizes PostgreSQL database schemas, queries, and security configurations using industry-proven patterns and Supabase best practices.

PostgreSQL Patterns & Optimization

Optimizes PostgreSQL database performance and security through standardized schema design, indexing strategies, and performance tuning patterns.

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.

Postgres Performance & Best Practices

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

Data Engineering & Analytics

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

Redis Lists & Sets Master

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

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.

Supabase Next.js Integration

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

Redis Cluster Manager

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

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 Hashes and Sorted Sets

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

PostgreSQL Monitoring

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