Database Management Claudeスキル

Backend Queries

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

AgentDB Advanced Features

Implements high-performance vector search, distributed QUIC synchronization, and multi-database management for advanced AI systems.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through quantization, HNSW indexing, and advanced caching strategies to maximize search speed and minimize memory usage.

Rust Parquet Optimization

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

DataFusion Query Advisor

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

SQL Performance Optimizer

Optimizes SQL query performance by applying proven patterns for indexing, JOIN structures, and execution plan analysis.

Data Lake Architect

Designs scalable data lake and lakehouse architectures using optimized partitioning, storage tiers, and high-performance formats like Iceberg and Parquet.

Database Tenant & Org Manager

Queries and manages tenant, organization, and factory information within the v3_user database using structured SQL execution.

Blacklake OpenAPI Database Query

Queries and manages integrated connectors and API configurations within the v3_openapi database using structured SQL templates.

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.

Backend Migrations

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

SQL Development

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

AgentDB Performance Optimization

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

AgentDB Advanced Features

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

Waggle Environment & Provider Detection

Automatically detects the execution environment and configures the active data provider for the Waggle ecosystem.

Turso Provider Setup

Configures Turso as the primary data provider for the Waggle project environment.

SQLite Setup for Waggle

Configures SQLite as the primary data provider for the Waggle framework.

Database Migration Manager

Manages database schema migrations with automated generation, validation, and zero-downtime execution patterns.

Atomic Transaction Manager for Supabase

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

Supabase RLS Policy Setup

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

Market Data Sync Strategies

Manages complex market data synchronization workflows, including initial loads, incremental updates, and intraday minute ingestion for trading platforms.

PostgreSQL Table Design

Architects high-performance, production-ready PostgreSQL schemas using modern best practices and advanced indexing patterns.

SQL Optimization Patterns

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

Database Schema Designer

Designs, normalizes, and visualizes robust relational database schemas using industry best practices and Mermaid ERD diagrams.

Database Audit Logger

Implements comprehensive database audit logging to track data changes, maintain compliance, and enhance system observability.

Database Connection Optimizer

Enhances application performance by configuring and optimizing database connection pools across various programming languages.

Database Connection Pooler

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

SQL Query Optimizer

Analyzes and optimizes SQL queries to enhance database performance through index recommendations and structural rewrites.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers for PostgreSQL, MySQL, and SQL Server to optimize database logic.