Database Management Agent Skills

Ghost Database Migration

Automates the generation, implementation, and testing of database migrations for the Ghost publishing platform.

ClickHouse Build Automator

Compiles ClickHouse source code with automated configuration detection and intelligent AI-powered error analysis.

PostgreSQL Best Practices & Patterns

Optimizes PostgreSQL performance and schema design through battle-tested indexing, security, and query patterns.

ClickHouse Performance & Analytics

Provides expert guidance on ClickHouse database design, query optimization, and high-performance analytical patterns.

PostgreSQL Optimization Patterns

Optimizes PostgreSQL database schemas, queries, and security using battle-tested industry patterns and Supabase best practices.

JPA Patterns & Hibernate Optimization

Implements industry-standard JPA and Hibernate patterns for high-performance Spring Boot data layers.

Sentry Django Migrations

Automates the generation and management of Django database migrations for Sentry's specialized architecture.

ClickHouse Performance & Analytics

Provides high-performance ClickHouse patterns for analytical workloads, query optimization, and efficient data engineering.

CockroachDB SQL Query Reducer

Automates the reduction of complex CockroachDB SQL test failure logs into minimal, reproducible test cases.

PostgreSQL Table Design

Architects high-performance PostgreSQL schemas using industry best practices for data integrity and scalability.

Projection Patterns

Builds high-performance read models and materialized views from event streams for event-sourced architectures.

Event Store Design

Designs and implements robust event stores for event-sourced systems using various database backends and architectural patterns.

SQL Optimization Patterns

Optimizes SQL queries and database schemas through advanced indexing strategies and systematic execution plan analysis.

dbt Transformation Patterns

Implements production-ready dbt patterns for scalable data modeling, automated testing, and analytics engineering workflows.

Database Migration Mastery

Automates database schema and data migrations across multiple ORMs while ensuring zero-downtime and robust rollback procedures.

CQRS Implementation

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

Event Store Design

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

Projection Patterns

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

PostgreSQL Table Design

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

Database Migration

Executes complex database migrations across multiple ORMs and platforms using zero-downtime strategies, data transformation scripts, and reliable rollback procedures.

SQL Optimization Patterns

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

Vector Index Tuning

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

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 Performance Optimization

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

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.