Database Management Agent Skills

PostgreSQL Admin

Manages PostgreSQL database security, role-based access control, and routine maintenance operations.

Postgres SQL Style Guide

Standardizes PostgreSQL development with comprehensive rules for naming conventions, schema design, and query formatting.

Event Store Design & Implementation

Designs and implements robust, immutable event stores for event-sourced architectures and high-concurrency backend systems.

Data Management Patterns

Provides standardized patterns for zero-downtime migrations, automated backups, data retention policies, and GDPR compliance workflows.

JOOQ Database Patterns

Implements type-safe SQL patterns and repository structures for robust database management using JOOQ and Kotlin.

ClickHouse Cloud Management

Manages ClickHouse Cloud users, permissions, and connections using SQL over the HTTP interface.

Supabase Migrations & Schema Management

Manages Supabase database schemas and migrations through automated CLI commands and best-practice SQL patterns.

Row-Level Security Patterns

Implements robust database row-level security policies for multi-tenant and user-scoped data architectures.

PostgreSQL Backup & Recovery

Implements production-ready PostgreSQL backup strategies including logical, physical, and point-in-time recovery patterns.

PostgreSQL Performance Optimizer

Optimizes PostgreSQL database performance through automated query analysis, advanced indexing strategies, and database configuration tuning.

Caching Conventions

Enforces standardized caching patterns across React, Next.js, Redis, and Cloudinary layers to ensure consistent data performance and invalidation logic.

Hono D1 Integration

Integrates Cloudflare D1 database functionality into Hono and TypeScript applications running on Cloudflare Workers or Pages.

Database Workflows & Optimization

Streamlines database schema design, migration management, and query performance optimization across major ORMs and SQL dialects.

Database Architect & Administrator

Simplifies database management by providing expert guidance for MongoDB and PostgreSQL schema design, query optimization, and production administration.

PostgreSQL Advanced Query Architect

Master complex PostgreSQL query patterns including CTEs, window functions, and recursive joins for high-performance data operations.

Database Optimization & Design Patterns

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

PostgreSQL Monitoring

Monitors PostgreSQL database performance and health through automated metric collection, observability patterns, and diagnostic alerting.

MCP Integration Core

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

NestJS TypeORM Integration

Integrates TypeORM into NestJS projects by configuring data sources, defining entities, managing migrations, and implementing scalable repository patterns.

SQL Optimization Patterns

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

PocketBase Development

Provides comprehensive guidance and implementation patterns for building real-time backend services using the PocketBase open-source framework.

PostgreSQL JSONB Mastery

Optimizes JSONB data operations within PostgreSQL by implementing production-ready query patterns, indexing strategies, and complex transformations.

Bazinga Database Operations

Manages concurrent-safe database operations for the BAZINGA multi-agent development system.

Database Performance & Anti-Patterns

Identifies and remediates common database performance bottlenecks like N+1 queries, unbounded fetches, and connection pool issues.

Prisma Expert

Optimizes database workflows with expert Prisma schema design, migration management, and query performance tuning.

Spring Data JPA Developer

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

NoSQL Design Expert

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

Supabase Integration

Streamlines Supabase backend development by automating database schema design, Row-Level Security (RLS) policies, and Edge Function deployment.

JPA Design Patterns

Optimizes Spring Boot data layers using best-practice JPA and Hibernate patterns for modeling, performance, and scalability.

PostgreSQL Extensions & Optimization

Optimizes PostgreSQL databases by installing, configuring, and implementing essential extensions for performance, search, and data modeling.