Database Management Claudeスキル

Supabase Project Bootstrapper

Streamlines the initialization of Supabase projects by configuring SQL formatting, task automation, and schema access via MCP.

AgentDB Vector Search

Implement high-performance semantic vector search and intelligent document retrieval for RAG-based AI applications.

MongoDB Database Migrations

Manages MongoDB schema changes and repository implementations using Doctrine ODM and Hexagonal Architecture principles.

SQL to OSC Converter

Converts Flyway SQL migration scripts into Online Schema Change (OSC) format for seamless, zero-downtime database updates.

C# Multi-Database Integration

Provides standardized C# access patterns and best practices for interacting with DuckDB, PostgreSQL, MySQL, SQL Server, and DBISAM.

C# Database Access Patterns

Standardizes RDBMS integration in C# for DuckDB, PostgreSQL, MySQL, and legacy systems using optimized drivers and patterns.

Backend Database Queries

Writes secure, performant database queries using parameterization, indexing, and advanced optimization techniques.

GCP BigQuery Table Management

Manages Google Cloud BigQuery table lifecycles, including creation, partitioning, clustering, and security configurations.

Supabase Database Manager

Manages Supabase database schemas, migrations, and Row-Level Security (RLS) policies to streamline data operations for the CookMode V2 platform.

Supabase Database Architect

Implements robust Supabase database patterns, RLS policies, and type-safe TypeScript queries optimized for the PhotoVault ecosystem.

Data Import and History Management

Streamlines complex data ingestion from CSV and XLSX files while implementing a robust three-tier history management framework for audit trails.

Supabase Storage Manager

Manages file uploads, storage buckets, signed URLs, and asset policies within the Supabase ecosystem.

Repository & Finder Architect

Generates standardized Repository and Finder interfaces to implement clean, CQRS-compliant data persistence layers.

MongoDB Application Development

Streamlines MongoDB integration across Node.js, Python, and Java with optimized patterns for transactions, connection pooling, and error handling.

CSV Database Normalizer

Transforms flat CSV files into normalized relational database structures by detecting functional dependencies and generating SQL schemas.

SQLite Best Practices

Optimizes SQLite performance and concurrency in Python applications using WAL checkpointing and stateful batch connections.

Prisma Data Access Guidelines

Manages type-safe database access layers using Prisma, DAO patterns, and PostgreSQL RBAC best practices.

SQL Query Optimizer

Analyzes and optimizes SQL queries to improve database performance, resolve N+1 issues, and ensure efficient index usage.

Database Migration & ORM Master

Streamlines database schema evolution, data transformations, and zero-downtime deployments across major ORMs and SQL platforms.

ORM Code Generator

Generates production-ready ORM models and database schemas from natural language descriptions or existing database structures.

MongoDB Transactions

Implements robust ACID transactions and multi-document operations for MongoDB data consistency.

Database Backup Automator

Automates scheduled backups, encryption, and restoration procedures for PostgreSQL, MySQL, MongoDB, and SQLite databases.

Query Performance Analyzer

Analyzes and optimizes database query performance by interpreting EXPLAIN plans and identifying execution bottlenecks.

Database Documentation Generator

Automates the creation of comprehensive database documentation, ERD diagrams, and data dictionaries from existing schemas.

Database Diff Tool

Automates database schema comparisons and generates transaction-safe migration scripts with rollback procedures for PostgreSQL and MySQL.

Database Caching Layer

Implements multi-tier caching architectures to optimize database performance, reduce latency, and scale backend services.

Database Index Advisor

Analyzes database query workloads to identify missing indexes and recommend optimizations for peak performance.

Database Partition Manager

Automates the design and implementation of database partitioning strategies to optimize query performance and manage large-scale data sets.

Database Migration & ORM Tools

Executes seamless database migrations across major ORMs with zero-downtime strategies and robust rollback procedures.

SQL Optimization Patterns

Optimizes database performance through advanced SQL query tuning, indexing strategies, and execution plan analysis.