Database Management Agent Skills

Rails Migrations

Streamlines database schema management and ActiveRecord migration workflows for Ruby on Rails applications.

ActiveRecord for Rails

Manages and optimizes Ruby on Rails database interactions through expert ActiveRecord guidance and implementation patterns.

Database Migration Mastery

Executes complex database migrations and schema transformations across multiple ORMs with a focus on zero-downtime and data integrity.

SQL Optimization Patterns

Optimizes database performance through advanced query tuning, indexing strategies, and detailed execution plan analysis.

AgentDB Performance Optimization

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

Prisma Database Expert

Optimizes Prisma ORM workflows including schema design, migration management, and high-performance query modeling.

SQL Optimization Patterns

Optimizes SQL database performance through query plan analysis, advanced indexing strategies, and systematic query refactoring.

SQL Optimization Patterns

Optimizes database performance by implementing efficient indexing, query refactoring, and execution plan analysis.

Drizzle ORM Expert

Provides comprehensive documentation and implementation patterns for Drizzle ORM, covering type-safe queries, schema management, and multi-database integrations.

Redis Data & Caching

Optimizes application performance through Redis caching, real-time pub/sub messaging, and distributed data structures.

Backend Queries

Optimizes and secures database interactions by implementing efficient query patterns, preventing security vulnerabilities, and managing data performance.

Prisma Database Expert

Optimizes Prisma ORM workflows including schema design, migrations, query performance, and database connection management.

PostgreSQL Table Design

Designs optimized, production-grade PostgreSQL schemas following industry best practices and performance patterns.

JGI Lakehouse Query

Facilitates querying and exploring the Joint Genome Institute (JGI) Dremio Lakehouse, including GOLD and IMG genomics databases.

Neon Postgres Integration

Optimizes Postgres database management using Neon serverless patterns, connection pooling, and ORM integrations for Prisma and Drizzle.

Prisma ORM Expert

Optimizes Prisma schema design, database migrations, and query performance for robust backend development.

Postgres Optimization & Best Practices

Optimizes Postgres database performance and schema design using Supabase-vetted best practices and implementation patterns.

Neon Postgres Integration

Optimizes serverless PostgreSQL workflows using Neon-specific patterns for branching, connection pooling, and ORM integration.

Firebase Development Suite

Implements robust, scalable Firebase architectures including authentication, real-time databases, and secure cloud functions.

Neon Postgres Expert

Optimizes serverless PostgreSQL workflows using Neon's branching, connection pooling, and specialized ORM integrations for Prisma and Drizzle.

Postgres Optimization & Best Practices

Optimizes Postgres database performance and security using Supabase-vetted schema designs, query patterns, and connection management strategies.

Postgres Best Practices

Optimizes PostgreSQL performance, schema design, and security using industry-standard patterns and Supabase-verified guidelines.

Database Migration Assistant

Executes and manages database schema migrations, data transformations, and zero-downtime deployment strategies across major ORMs.

Blacklake E-Report DB Assistant

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

Database Audit Trail Implementation

Automates the implementation of comprehensive database audit logging to track data changes for security, compliance, and monitoring.

Juicebox Data Migration Pro

Orchestrates complex data migrations from recruiting platforms and ATS systems into Juicebox with enterprise-grade reliability.

Database Recovery Manager

Provides automated workflows for managing, optimizing, and executing database recovery operations within Claude Code.

Exa Migration Deep Dive

Executes complex Exa re-architecture and migration strategies using the Strangler Fig pattern to ensure zero-downtime transitions.

Supabase Debug & Diagnostic Bundle

Generates comprehensive diagnostic reports and log bundles for troubleshooting Supabase integration issues.

Database Integrity Engine

Enforces database consistency by automating SQL constraints, data format validation, and referential integrity rules.