Database Management Claude 技能

Firebase Firestore Specialist

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

Drizzle ORM Expert

Provides comprehensive documentation and implementation patterns for Drizzle ORM, covering type-safe queries, schema management, and multi-database integrations.

PostgreSQL Table Design

Designs optimized, production-grade PostgreSQL schemas following industry best practices and performance patterns.

JGI Lakehouse Query

Facilitates querying and exploring the Joint Genome Institute (JGI) Dremio Lakehouse, including GOLD and IMG genomics databases.

Data Quality Test Generator

Generates comprehensive dbt test suites using modern 1.10+ syntax to ensure data integrity and structural consistency across analytical models.

Supabase Database

Streamlines Supabase database management through optimized CRUD operations, Row Level Security (RLS) implementation, and PostgreSQL function support.

dbt Model Builder

Constructs standardized dbt models following Kimball dimensional patterns and modern testing configurations.

Postgres Hypothetical Index Helper

Generates Ruby and ActiveRecord commands to create and test PostgreSQL hypothetical indexes using the HypoPG extension.

Backend Queries

Implements structured database queries and repository patterns using Prisma ORM to maintain a robust layered architecture.

Database Schema Conflict Resolver

Resolves database schema version conflicts by automatically selecting the most recent migration timestamp.

Supabase Next.js Integration

Streamlines the integration of Supabase backend services into React and Next.js applications using modern App Router patterns and SSR.

ClickHouse Analytics & Data Patterns

Optimizes ClickHouse database performance with expert patterns for schema design, high-volume data ingestion, and complex analytical queries.

Optimizing Performance

Identifies and resolves performance bottlenecks across databases, application logic, and infrastructure using proven optimization patterns.

Objectstar Legacy Migration

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

PostgreSQL Table Design

Architects production-grade PostgreSQL schemas using expert-level best practices for data integrity, performance, and scalability.

Metadata Manager

Streamlines the creation and management of BigQuery table schemas, metadata configurations, and Airflow DAG schedules following Mozilla ETL conventions.

SQL Optimization Patterns

Optimizes SQL query performance through systematic execution plan analysis, advanced indexing strategies, and proven query restructuring patterns.

Writing Queries

Guides the systematic development, verification, and documentation of SQL queries for analytical data processing.

Go Database Migration Manager

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

Backend Models

Defines and structures database schemas with robust naming conventions, data integrity constraints, and optimized relationship mappings.

Codebase & Schema Explorer

Accelerates codebase onboarding by automating the discovery of database schemas, API endpoints, and architectural patterns.

Database Migration & ORM Tools

Executes and manages database schema migrations, data transformations, and rollback procedures across multiple ORMs and platforms.

SQL Optimization Patterns

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

Supabase Storage Manager

Manages file storage, bucket configurations, and secure access policies within the Supabase ecosystem.

Query Writer

Generates and maintains standardized BigQuery SQL and Python ETL scripts following Mozilla's data engineering conventions and partitioning patterns.

Prisma ORM Development

Streamlines database development using Prisma 5+ with type-safe schema design, migration workflows, and optimized query patterns.

Prisma ORM Setup & Patterns

Configures and optimizes Prisma ORM for type-safe database access and streamlined schema management in Node.js applications.

Query Performance Analysis

Analyzes database query performance, detects N+1 issues, identifies missing indexes, and guides safe index migrations.

SQL Query Optimization

Optimizes PostgreSQL database performance through structured analysis, index recommendations, and advanced query refactoring patterns.

Postgres Query Optimization

Optimizes PostgreSQL database performance by analyzing execution plans, identifying bottlenecks, and implementing advanced indexing strategies.