Database Management Claude 技能

Airtable PM Data Model

Provides a standardized data model reference for orchestrating Product Management workflows and requirements within Airtable.

PostgreSQL Database Setup

Initializes PostgreSQL databases with standardized SQL schemas, Python setup scripts, and best-practice environment configurations.

AgentDB Vector Search

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

AgentDB Performance Optimization

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

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, EXPLAIN plan analysis, and efficient query pattern implementation.

jOOQ Database Patterns

Implements type-safe SQL queries and repository patterns using jOOQ for robust Kotlin and Java database interactions.

Flyway Database Migrations

Manages database schema changes and versioning through standardized Flyway migration patterns and PostgreSQL best practices.

Database Migration & Schema Evolution

Manages complex database migrations across multiple ORMs with zero-downtime strategies and automated rollback procedures.

Enterprise ERP Consultant

Architects and implements complex business logic for enterprise resource planning systems including finance, inventory, and supply chain modules.

LoRAIro SQLAlchemy Repository Pattern

Implements type-safe SQLAlchemy repository patterns for consistent database operations and session management.

Data Architecture Patterns

Implements a type-safe, single-source-of-truth data architecture using TypeScript and Zod for centralized project and personal information.

TikTok Supabase Data Sync

Synchronizes TikTok engagement data and readings from ClickHouse to Supabase to keep web content updated.

Slow Query Analysis & DB Tuning

Analyzes database slow query logs to identify performance bottlenecks and provide actionable indexing and optimization strategies.

Data Warehouse Architect

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

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through advanced quantization, HNSW indexing, and efficient batch operations.

Supabase Migrations

Manages Supabase database schema changes, table creation, and Row Level Security policies using the Supabase CLI.

Database Function Lint Manager

Lints PostgreSQL functions, analyzes codebase usage, and generates actionable maintenance reports to ensure database integrity.

RLS Security Patterns

Implements robust Row-Level Security (RLS) policies for multi-tenant and user-scoped database architectures.

Database Performance Patterns

Optimizes database query performance and prevents connection pool exhaustion using proven Postgres and Supabase patterns.

Supabase RLS Policy Generator

Generates secure, production-ready Row Level Security policies for Supabase tables with support for complex account architectures and admin bypass.

Supabase Realtime Specialist

Implements live data synchronization, presence tracking, and real-time notifications using Supabase Realtime.

Database Migration Manager

Generates production-ready Supabase migrations with idempotent SQL, strict naming conventions, and advanced RLS security patterns.

F# Data Persistence Patterns

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

AgentDB Advanced Features

Powers distributed AI systems with low-latency QUIC synchronization, hybrid vector search, and multi-database management.

Data Engineering & Analytics

Architects robust data pipelines, optimizes SQL queries, and manages large-scale ETL/ELT workflows across modern data warehouses.

ClickHouse Query & Schema Optimizer

Optimizes ClickHouse database performance through expert schema design, primary key ordering, and query tuning.

Database Documentation Generator

Automatically generates comprehensive database schema documentation, architecture guides, and operational runbooks using SQL and NoSQL CLI tools.

Database Connection Pooler

Optimizes database connection pooling to enhance application performance and resource management efficiency.

SQL Query Optimizer

Analyzes and optimizes database queries to improve performance, reduce latency, and minimize resource consumption across SQL and NoSQL systems.

Stored Procedure Generator

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