Database Management Agent Skills

Redis Development Conventions

Standardizes Redis implementation with expert guidance on data structures, hierarchical key naming, and memory-efficient TTL strategies.

Query Writer

Generates and maintains standardized BigQuery SQL and Python ETL scripts following Mozilla's data engineering conventions and partitioning patterns.

CRM Orbit Data Migrations

Streamlines the planning and implementation of complex data migrations for CRM Orbit's Automerge and Drizzle persistence layers.

Redis Cache Management

Manages Redis cache operations including key-value manipulation, production-safe pattern searching, and TTL inspection.

Event Store Design

Design and implement robust event-sourced storage systems with optimized schemas and persistence patterns.

SQL Performance Optimizer

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

PostgreSQL Table Design

Designs high-performance, production-ready PostgreSQL schemas using industry best practices and advanced database features.

Supabase Development CLI

Manages Supabase projects locally and remotely through comprehensive CLI command automation and best practices.

DataFusion Query Advisor

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

Projection Patterns for Event Sourcing

Builds efficient read models and materialized views from event streams to optimize query performance in CQRS and event-sourced architectures.

MongoDB Transactions

Implements robust ACID transactions and multi-document operations for MongoDB data consistency.

Supabase Troubleshooting

Diagnoses and resolves complex Supabase issues including authentication errors, RLS policy failures, and database performance bottlenecks.

InterSystems IRIS DTL Transformations

Guides the development, testing, and implementation of Data Transformation Language (DTL) for InterSystems IRIS interoperability productions.

Rust Parquet Optimization

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

AgentDB Vector Search

Implements high-performance semantic vector search and RAG capabilities for intelligent document retrieval.

Supabase Realtime

Enables real-time data synchronization, live broadcasts, and user presence tracking using Supabase's Realtime engine.

AC Knowledge Graph

Builds and queries relational knowledge graphs to provide Claude with a structural and semantic understanding of complex codebases.

Supabase Implementation Standards

Enforces standardized Supabase integration patterns using a unified service layer and secure Service Role management.

Supabase CLI Toolkit

Streamlines Supabase project management, local development, and database migrations within Claude.

Drizzle ORM Workflow Manager

Manages Drizzle ORM and drizzle-kit workflows including migrations, schema generation, and specialized database reset flows.

MOVA Episode Ingest & Store

Persists ingested episode data into the MOVA lab's genetic file store for automated workflow cycles.

AgentDB Performance Optimization

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

AgentDB Advanced Features

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

Modern Neo4j Cypher Guide

Generates optimized, modern Neo4j Cypher queries while ensuring compatibility with the latest syntax standards and performance patterns.

Backend Queries

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

Drizzle Cube Definition

Simplifies the creation of secure, type-safe semantic layer cube definitions for Drizzle ORM-based applications.

T-SQL Pro & Database Optimization

Writes high-performance, secure T-SQL code and optimizes SQL Server database schemas using industry best practices.

NestJS TypeORM Integration

Streamlines the setup, configuration, and refactoring of TypeORM within NestJS TypeScript projects for scalable database management.

MySQL Database Skill

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

SQL Batching

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