Database Management Claudeスキル

Backend Migrations

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

SQL Code Formatter

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

Database Schema Management

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

Database Migration Master

Facilitates seamless database schema and data migrations across multiple ORMs with a focus on zero-downtime strategies and safety.

dbt Data Modeling Expert

Implements industry-standard dbt patterns for scalable data transformation, automated testing, and comprehensive documentation.

PostgreSQL Guide

Retrieves real-time, official PostgreSQL documentation for accurate SQL syntax, database configuration, and performance optimization.

CHGIS Temporal Gazetteer

Queries the China Historical GIS Temporal Gazetteer API to retrieve and analyze historical Chinese placenames and administrative structures from 222 BCE to 1911 CE.

PowerSync Local-First Sync

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

Data Engineering

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

PostgreSQL Explorer & Debugger

Explores, debugs, and manages PostgreSQL databases using AI-optimized JSON outputs and comprehensive schema discovery tools.

Data Structure Selection Framework

Guides the selection of optimal data structures through a systematic analysis of performance requirements, operation frequencies, and memory constraints.

Database & Data Schema Lead

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

Database Implementer

Generates robust database schemas, versioned migrations, and optimized data access layers for efficient application development.

Supabase Infrastructure Manager

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

Database Migration Strategies

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

Node.js Database Query Optimization

Optimizes database performance in Node.js applications by implementing indexing, pagination, and N+1 query prevention strategies.

Snowflake AI & App Platform

Builds and deploys applications on Snowflake's AI Data Cloud using snow CLI, Cortex AI functions, and Native App patterns.

Drizzle ORM Setup & Patterns

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

PostgreSQL Table Design

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

BigQuery CLI Integration

Facilitates seamless interaction with Google BigQuery via the bq command-line tool for data exploration and analysis.

Neon CLI Expert

Manages serverless PostgreSQL projects and branching workflows using the Neon CLI directly within your development environment.

Database Code Reviewer

Reviews database migrations, query performance, and transaction logic to ensure data integrity and prevent production downtime.

AgentDB Performance Optimization

Optimizes vector database performance and memory efficiency through advanced quantization techniques, HNSW indexing, and intelligent caching strategies.

AgentDB Vector Search

Implements high-performance semantic vector search and document retrieval for RAG systems and intelligent knowledge bases.

AgentDB Vector Search

Implements high-performance semantic vector search and intelligent document retrieval using HNSW indexing and quantization for sub-millisecond querying.

AgentDB Advanced Features

Implements advanced vector database capabilities including QUIC synchronization, hybrid search, and distributed multi-agent coordination.

PostgreSQL Schema Design

Architects high-performance PostgreSQL database schemas using industry-standard best practices for data integrity and scalability.

PostgreSQL Schema Validator

Connects to live PostgreSQL databases to validate schema assumptions, perform system catalog queries, and cross-validate DDL outputs.

PostgreSQL Migrations & Schema Management

Provides expert guidance on PostgreSQL migrations, including idempotent patterns, index optimization, and resolving complex database errors.

PostgreSQL pg_dump Reference Guide

Consults PostgreSQL's pg_dump source code to provide authoritative guidance on system catalog queries and schema extraction patterns.