Database Management Agent Skills

Vector Index Tuning

Optimizes vector search performance and resource efficiency through expert guidance on HNSW parameters, quantization strategies, and infrastructure scaling.

SQL Optimization Patterns

Optimizes slow database queries through systematic indexing strategies, EXPLAIN plan analysis, and efficient query patterning.

Event Store Design

Architects and implements robust event persistence layers for event-sourced applications using industry-standard patterns and technologies.

PostgreSQL Table Design

Designs high-performance, production-ready PostgreSQL schemas using optimized data types, advanced indexing strategies, and industry best practices.

Projection Patterns

Build high-performance read models and materialized views from event streams using CQRS architectural patterns.

CQRS Implementation

Implements Command Query Responsibility Segregation patterns to build scalable, high-performance backend architectures with separate read and write models.

ShardingSphere Issue Analyzer

Conducts root-cause-first analysis of Apache ShardingSphere GitHub issues using a standardized, evidence-based workflow.

dbt Transformation Patterns

Streamlines analytics engineering workflows by implementing production-ready dbt model organization, testing, and incremental processing strategies.

Rust Production Code Quality

Enforces strict correctness rules and efficient Rust patterns for building high-integrity production systems.

Turso MVCC Internals Guide

Explains and navigates Turso's experimental Multi-Version Concurrency Control (MVCC) architecture and snapshot isolation features.

V3 Memory Unification

Unifies multiple memory architectures into a high-performance AgentDB backend with HNSW vector indexing for massive search acceleration.

AgentDB Vector Search

Provides high-performance semantic vector search and intelligent document retrieval to power RAG systems and semantic search engines.

AgentDB Advanced Features

Manages high-performance distributed AI database operations with low-latency synchronization, hybrid vector search, and advanced similarity metrics.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through quantization, HNSW indexing, and advanced caching strategies to reduce memory footprint and search latency.

SQL Query Expert

Writes, optimizes, and translates performant SQL queries across major data warehouse dialects like Snowflake, BigQuery, and PostgreSQL.

Database Designer

Optimizes database schemas, index strategies, and migration workflows for scalable and performant data architectures.

Qdrant Vector Search

Manages high-performance vector similarity search and scalable storage for production RAG and semantic search systems.

Supabase Automation

Automates Supabase database management, schema inspection, and project administration through integrated MCP tools.

Airtable Automation

Automates Airtable database operations including record management, schema design, and workflow integration via Rube MCP.

Multigres Local Cluster Manager

Manages local Multigres cluster components, service lifecycles, and S3 backup workflows directly through Claude.

Azure Cosmos DB for Rust

Simplifies building globally distributed applications using the Azure Cosmos DB NoSQL API and the official Rust SDK.

Azure PostgreSQL Manager

Configure and manage Azure Database for PostgreSQL with a focus on passwordless Entra ID authentication and secure access control.

Azure Cosmos DB for Python

Implements production-grade Azure Cosmos DB NoSQL service layers for Python and FastAPI applications using best-practice architecture.

Azure PostgreSQL for TypeScript

Connects Node.js and TypeScript applications to Azure Database for PostgreSQL with support for secure Entra ID authentication and high-performance connection pooling.

Azure Cosmos DB for Python

Simplifies interaction with Azure Cosmos DB NoSQL API using the official Python SDK for document management and querying.

Azure Tables Python SDK

Manages Azure Storage Tables and Cosmos DB Table API using the Python SDK for high-performance NoSQL data storage.

Azure Cosmos DB TypeScript SDK

Streamlines Azure Cosmos DB NoSQL operations using the official TypeScript SDK for document management, SQL queries, and bulk data processing.

Azure Cosmos DB Java SDK

Streamlines Azure Cosmos DB NoSQL operations in Java applications using synchronous and reactive programming patterns.

Azure MySQL Management (.NET)

Manages Azure MySQL Flexible Server deployments, including server creation, database configuration, and high availability settings using the .NET SDK.

SQL Transform Helper

Streamlines the creation and optimization of SQL transformation logic within complex data engineering pipelines.