Database Management Claude 스킬

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through quantization, HNSW indexing, and advanced caching strategies.

DuckDB SQL

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

AgentDB Vector Search

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

SQL Batching

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

MySQL Database Skill

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

Database Schema Design

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

Database Connection Pooling

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

DBF Data Analysis

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

Backend Queries

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

SQL Performance Optimizer

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

Blacklake User & Organization DB Query

Queries tenant and organizational data from the v3_user database using standardized SQL templates and structured reporting.

Database Tenant & Org Manager

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

Universal Database Query Tool

Executes and manages SQL queries while providing structured schema insights and formatted data results via MCP tools.

Black Lake DB Metadata Helper

Accesses and queries Black Lake v3_metadata database tables for object codes, events, custom fields, and system configurations.

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.

Blacklake E-Report DB Assistant

Provides SQL query templates and automated reporting for the v3_e-report database to manage and analyze alert configurations.

Common Database Queries

Provides a standardized workflow and SQL templates for efficient database querying and structured result analysis using the exec_sql tool.

OP Database Metadata Manager

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

Backend Migrations

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

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.

AgentDB Performance Optimization

Optimizes vector database performance and memory efficiency through advanced quantization techniques, HNSW indexing, and intelligent caching strategies.

DataFusion Query Advisor

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

Database Design Patterns

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

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.