Database Management Claude 技能

Supabase Next.js Integration

Integrates Supabase with Next.js App Router projects using secure patterns for authentication, database management, and row-level security.

Database Migration Manager

Manages database schema evolution by generating and applying version-controlled migration scripts for major SQL and NoSQL databases.

Semantic RDF Modeling

Models software feature specifications and domain architectures using RDF ontologies and Turtle syntax.

Vanilla Rails Data Modeling

Enforces high-performance, multi-tenant database schema patterns and migrations for Ruby on Rails applications based on 37signals conventions.

F# Data Persistence Patterns

Implements robust data storage solutions using SQLite with Dapper, JSON files, or event sourcing patterns in F# projects.

Supabase RLS Policy Expert

Generates and optimizes production-ready PostgreSQL row-level security (RLS) policies following Supabase best practices.

Database Diff & Migration Adapter

Compares database schemas and generates transaction-safe migration scripts and rollback procedures for PostgreSQL and MySQL.

AgentDB Performance Optimization

Optimizes AgentDB vector databases using quantization, HNSW indexing, and batch operations to achieve massive performance gains and memory reduction.

Database Management

Architects, optimizes, and manages relational and NoSQL databases to ensure high performance, data integrity, and scalability.

AgentDB Vector Search

Implements ultra-fast semantic vector search and HNSW indexing for RAG systems and intelligent document retrieval.

Caching Conventions

Enforces standardized caching patterns across React, Next.js, Redis, and Cloudinary layers to ensure consistent data performance and invalidation logic.

Data Warehouse Architect

Architects robust data warehouses using star schemas, dimensional modeling, and enterprise SQL patterns for scalable analytics.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers across multiple database systems to automate complex backend logic.

Database Assistant

Expertly designs database schemas, optimizes complex SQL queries, and manages data migrations with industry-leading best practices.

Database Management & Optimization

Simplifies database schema design, query optimization, and administration for MongoDB and PostgreSQL environments.

dbt Development

Validates dbt models against standardized coding conventions to ensure consistent naming, SQL structure, testing coverage, and documentation.

Data Design & Architecture

Designs efficient, scalable, and maintainable data structures and schemas using industry-best practices for SQL and NoSQL databases.

Logseq Datalog Expert

Builds and optimizes complex Datalog queries for Logseq's database-driven graphs.

Lutece 8 DAO & Home Patterns

Implements standardized DAO and Home layer patterns for Lutece 8 development using best practices for data persistence.

ActiveRecord Patterns & Optimization

Optimizes database interactions by providing enterprise-grade ActiveRecord query patterns, association designs, and PostgreSQL-specific performance strategies.

Cloudflare D1 Migrations & Production Seeding

Manages Cloudflare D1 database schemas, migrations, and environment-specific data seeding using Wrangler and SQL best practices.

Database Optimization & Design Patterns

Optimizes database performance and scalability using advanced SQL, NoSQL, and Redis caching strategies.

SQL Performance Optimization Patterns

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

Backend Queries

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

Objectstar Legacy Migration

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

Postgres Hypothetical Index Helper

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

PostgreSQL Table Design

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

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.