Database Management Claude 技能

OpenAPI & Connector Database Manager

Queries and manages integrated connector configurations and API metadata within the v3_openapi database.

E-Report Database Management

Simplifies querying and managing the v3_e-report database for data analysis alert configurations and tenant statistics.

OP Database Metadata Manager

Provides specialized SQL query templates for managing and exploring v3_metadata database structures, including business objects and custom fields.

DataFusion Query Advisor

Optimizes Apache DataFusion SQL queries and DataFrame operations through advanced performance analysis and best practices.

Rust Parquet Optimization

Optimizes Parquet file operations in Rust to improve query performance, reduce storage costs, and prevent memory issues.

Backend Migrations

Manages database schema changes through reversible, version-controlled migration files while ensuring zero-downtime deployment compatibility.

Backend Queries

Constructs optimized and secure database queries using parameterized statements, eager loading, and efficient indexing strategies.

Task Search

Implements robust search capabilities for task management applications, including keyword matching, relevance ranking, and multi-criteria filtering.

SQL Development

Writes, reviews, and optimizes performant SQL queries while applying PostgreSQL-specific best practices for schema design and performance tuning.

AgentDB Advanced Features

Implement high-performance distributed vector databases with sub-millisecond synchronization, hybrid search, and advanced distance metrics.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance using quantization, HNSW indexing, and advanced caching strategies to reduce memory footprint and accelerate search speeds.

DBF Data Analysis

Analyzes and converts legacy Thai accounting DBF databases into efficient Parquet format for high-performance SQL querying with DuckDB.

Database Connection Pooling

Optimizes database performance and reliability by configuring robust connection pools for SQLAlchemy across traditional and serverless architectures.

Database Schema Design

Designs robust, scalable relational database schemas through structured workflows, entity-relationship modeling, and SQL generation.

MySQL Database Skill

Executes safe SELECT queries against MySQL and MariaDB databases with built-in connection pooling and SQL injection prevention.

Database Design Patterns

Implements industry-standard database design patterns, indexing strategies, and migration best practices for optimized data persistence.

SQL Batching

Prevents D1/SQLite 'too many SQL variables' errors by automatically batching Drizzle ORM queries with dynamic arrays.

AgentDB Vector Search

Implements high-performance semantic vector search and document retrieval with sub-millisecond latency for intelligent RAG systems.

DuckDB SQL

Generates and refines DuckDB SQL queries for data analysis using local database, CSV, and Parquet files.

Data Engineer

Architects and maintains robust data pipelines, analytics infrastructure, and integration workflows.

SQL Expert

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

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, query plan analysis, and efficient data retrieval patterns.

Supabase Query Optimizer

Optimizes Supabase PostgreSQL database performance by analyzing execution plans and implementing advanced indexing and RLS strategies.

Atomic Transaction Manager for Supabase

Implements secure, atomic PostgreSQL transactions in Supabase using PL/pgSQL RPC functions to ensure data consistency.

Supabase CRUD Operations

Generates production-ready CRUD operations for Supabase tables with built-in error handling, type safety, and RLS awareness.

Supabase RLS Policy Setup

Configures production-ready Row Level Security policies for Supabase tables to ensure secure, role-based data access.

Supabase Schema Designer

Designs production-ready, normalized database schemas with relationships, constraints, and Row Level Security specifically for Supabase.

Supabase Expert

Manages Supabase database operations, security policies, and edge functions following project-specific standards and real-time state verification.

AsyncPG Database Detection

Scans Python and FastAPI projects to identify asyncpg imports, connection patterns, and query logic for migration to SQLAlchemy.

SQLAlchemy Conversion

Converts asyncpg database code to SQLAlchemy 2.0+ asynchronous patterns while preserving performance and transaction integrity.