Database Management Claudeスキル

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database schemas and analytical queries for high-performance OLAP workloads and data engineering.

AgentDB Advanced Features

Implements high-performance distributed vector database operations and advanced search algorithms for multi-agent AI systems.

Convex Component Authoring

Guides the development and publishing of reusable, self-contained Convex backend components with isolated database schemas.

JPA Persistence & Optimization

Provides expert guidance on JPA/Hibernate entity modeling, query optimization, and transaction management for Spring Boot applications.

PostgreSQL Table Design

Architects optimized PostgreSQL schemas using industry best practices for performance, scalability, and data integrity.

Memory Management

Manages persistent AgentDB storage with HNSW vector search for high-speed semantic pattern retrieval and cross-agent knowledge sharing.

NoSQL Expert & Distributed Systems Architect

Provides expert guidance and architectural patterns for high-scale distributed NoSQL databases like Cassandra and DynamoDB.

Drizzle ORM Setup & Patterns

Configures Drizzle ORM for Node.js applications with type-safe schemas and SQL-first query patterns.

Database Designer

Architects, optimizes, and migrates complex database schemas using advanced normalization principles and performance analysis.

Database Migration Strategies

Implements safe, zero-downtime database schema changes and data migrations using industry-standard patterns and ORM best practices.

PowerSync Local-First Sync

Builds offline-capable, local-first TypeScript applications with real-time SQLite-to-backend synchronization.

pg_dump Reference

Consults the official PostgreSQL pg_dump implementation to provide canonical guidance on system catalog queries and schema extraction.

Data Engineering

Standardizes data pipeline design, ETL processes, and schema evolution using data-as-a-product principles.

Supabase Infrastructure Manager

Manages Supabase projects including database migrations, Edge Functions deployment, and local development environments via the Supabase CLI.

SQLModel ORM Helper

Design and implement production-grade database layers using SQLModel with SQLAlchemy 2.0 patterns for FastAPI projects.

Elasticsearch Best Practices

Optimizes Elasticsearch index design and query performance through standardized best practices and implementation patterns.

PostgreSQL Best Practices

Optimizes PostgreSQL performance and security using expert-level guidelines for schema design, indexing, and query execution.

PostgreSQL Syntax Reference

Consults PostgreSQL's internal parser and grammar rules to ensure precise SQL syntax implementation and DDL generation.

Persistence Layer Auditor

Audits and optimizes SQLite persistence layers by identifying unused tables, broken method calls, and schema inconsistencies.

Turso Task Provider for Waggle

Enables high-performance task management and persistence using Turso edge databases for autonomous project workflows.

Waggle SQLite Provider

Manages local task tracking and project data using SQLite for the Waggle ecosystem within Claude Code.

Turso Database Setup

Configures Turso as the primary data provider for waggle applications to enable distributed SQLite storage.

Turso Database Setup

Configures Turso as the primary data provider for Waggle projects to enable edge-compatible database storage.

Database & Data Schema Lead

Standardizes and documents project data formats, frontmatter schemas, and validation rules based on observable codebase evidence.

Backend Migration Standards

Establishes best practices for creating reversible, zero-downtime database migrations with consistent naming and structure.

Database Domain Specialist

Architects and manages complex database systems using PostgreSQL, MongoDB, and Redis patterns for modern applications.

Database Schema Management

Manages PostgreSQL database schemas and Prisma ORM migrations within the ClaudeCode Sentiment Monitor project.

SQL Code Formatter

Formats and polishes SQL queries according to Oracle Database 19 best practices for improved readability and consistency.

Backend Migrations

Manages database schema transitions with a focus on reversibility, data integrity, and zero-downtime deployment strategies.

Backend Migrations

Manages database schema evolutions through versioned migration files that prioritize data integrity, reversible changes, and zero-downtime deployment strategies.