Database Management Claude 技能

Firestore Index Creator

Automates the generation and management of Google Cloud Firestore indexes to optimize database query performance.

Backend Database Design & Selection

Provides expert guidance for choosing database technologies and architecting high-performance schemas across SQL and NoSQL ecosystems.

SQL Query Optimizer

Optimizes database performance by analyzing execution plans and rewriting SQL queries to eliminate anti-patterns and improve speed.

Database Index Advisor

Optimizes database performance by designing, implementing, and validating efficient indexing strategies for SQL and NoSQL systems.

Convex Component Authoring

Builds and structures reusable, isolated Convex components for efficient backend development and logic sharing.

Database Archival System

Automates the process of moving historical database records to cold storage or archive tables to optimize performance and reduce storage costs.

DBT Model Generator

Automates the creation and configuration of dbt models to streamline data transformation and pipeline development.

Database Migration Patterns

Manages database schema evolution using Supabase, Prisma, and Drizzle with production-safe patterns.

Database Seed Data Generator

Generates realistic, relational test data and database seed scripts using Faker libraries to streamline development and testing workflows.

Supabase Architecture Blueprints

Implements validated Supabase architecture blueprints and project structures tailored to specific scaling requirements.

Domain Repository Port Generator

Generates pure domain repository interfaces to define persistence contracts without infrastructure or framework dependencies.

Postgres DB Integration Test Generator

Generates automated Postgres integration tests for Java infrastructure layers using Testcontainers and Flyway migrations.

SQL Query Optimizer

Analyzes and improves database query performance through automated assessment, implementation, and monitoring of SQL execution plans.

SQL Expert

Simplifies complex SQL query writing, database schema design, and performance optimization across major relational database systems.

Supabase SDK Design Patterns

Implements production-ready, type-safe Supabase SDK patterns for TypeScript and Python applications.

Supabase Migration Workflow

Automates the end-to-end Supabase database migration process, including schema diffing, local synchronization, and TypeScript type generation.

Schema Migrator

Automates JSON schema version upgrades with built-in data validation and automated rollback protection.

Firebase Firestore Specialist

Architects and implements scalable NoSQL database solutions using Firebase Firestore with real-time sync and offline-first capabilities.

SQLite Database Viewer

Opens SQLite databases in a graphical user interface for easy viewing and debugging of journal data.

Database Operations

Streamlines database schema design, Alembic migrations, and PostgreSQL query optimization for coffee roasting management systems.

SQL Server Toolkit

Optimizes SQL Server workflows by routing tasks to specialized agents for performance tuning, schema discovery, and expert T-SQL development.

SQL Server MCP Setup

Automates the installation and configuration of the SQL Server MCP server for seamless Claude Code connectivity.

Objectstar Legacy Migration

Analyzes, refactors, and migrates TIBCO Objectstar legacy mainframe applications to modern architectures and programming languages.

Go Database Migration Manager

Generates standardized golang-migrate SQL files with timestamp-based naming and strict schema conventions.

Firebase Firestore Specialist

Implement and optimize Firebase Firestore databases with real-time synchronization, offline-first architecture, and robust security rules.

Laravel Eloquent Expert

Optimizes Laravel database interactions using Eloquent ORM patterns, advanced relationships, and query performance techniques.

Event Store Designer

Designs and implements robust event stores for high-performance event-sourced systems and microservices architectures.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance through high-efficiency table design, advanced query patterns, and real-time analytics best practices.

JUDO RDBMS Dialect Extension

Extends the JUDO DAO framework to support new database dialects like MySQL, Oracle, and custom RDBMS systems.

DuckDB ETL Pipeline

Automates the ingestion of CSV and Excel files into DuckDB with integrated data validation and markdown reporting.