Database Management Agent Skills

Redis Hashes and Sorted Sets

Optimizes Redis data management with advanced patterns for Hashes and Sorted Sets, including leaderboards, object storage, and ranking systems.

Shopify Database Best Practices

Optimizes Shopify app database operations using Prisma ORM with a focus on multi-tenant data isolation and high-performance query patterns.

PostgreSQL Expert

Optimizes PostgreSQL performance, designs scalable architectures, and troubleshoots complex database internals with production-grade precision.

PostgreSQL Streaming Replication Manager

Automates the configuration, monitoring, and failover management of PostgreSQL streaming replication clusters.

PostgreSQL PL/pgSQL Development

Develops robust PostgreSQL procedural logic including functions, triggers, and procedures with production-ready patterns.

Semantic RDF Modeling

Models software feature specifications and domain architectures using RDF ontologies and Turtle syntax.

Supabase RLS Policy Expert

Generates and optimizes production-ready PostgreSQL row-level security (RLS) policies following Supabase best practices.

Database Optimization & Design Patterns

Optimizes database performance and scalability using advanced SQL, NoSQL, and Redis caching strategies.

MCP Integration Core

Guides the integration of external databases and services into Claude Code using the Model Context Protocol (MCP).

SQL Optimization Patterns

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

Spring Data JPA Developer

Implements robust persistence layers using Spring Data JPA, including repository patterns, entity relationships, and query optimization.

Database Migration Mastery

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

Event Store Design & Implementation

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

Projection Patterns

Design and implement efficient read models and materialized views from event streams for event-sourced architectures.

Data Quality Frameworks

Implements robust data validation and quality assurance using Great Expectations, dbt tests, and formal data contracts.

dbt Transformation Patterns

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

PostgreSQL Schema Design

Guides the creation of performant, scalable, and normalized PostgreSQL database schemas using industry best practices.

Spring Data Neo4j Integration

Streamlines graph database development by implementing Spring Data Neo4j patterns for node entities, relationships, and Cypher queries.

AWS DynamoDB for Java SDK 2.x

Simplifies Amazon DynamoDB integration in Java applications using the AWS SDK 2.x and Enhanced Client.

Drizzle ORM Patterns

Implements type-safe PostgreSQL database schemas and query patterns using Drizzle ORM.

Upstash Redis Patterns

Implements efficient caching, rate limiting, and session management patterns using Upstash Redis.

Schema Migration Governor

Manages database schema migrations autonomously while preventing data loss through automated safety checks and reversible planning.

Database Design & Architecture

Architects scalable database schemas and optimizes query performance using context-aware design principles.

Prisma ORM Expert

Optimizes Prisma ORM workflows through expert schema design, migration management, and high-performance query tuning.

Database Design & Architecture

Guides architectural decision-making for database selection, schema modeling, and performance optimization.

Prisma Database Expert

Optimizes database schemas, migrations, and query performance using Prisma ORM best practices.

NoSQL Design Expert

Architects highly scalable distributed NoSQL databases using query-first modeling and advanced single-table design patterns.

NoSQL Expert Architect

Provides expert guidance for designing and optimizing distributed NoSQL databases like Cassandra and DynamoDB using query-first modeling.

NoSQL Architecture Expert

Provides expert architectural guidance and design patterns for high-scale distributed databases like DynamoDB and Cassandra.

Database Design Architect

Architects efficient, scalable database schemas and selects optimal data stacks based on specific project requirements.