Database Management Agent Skills

FHIR Data Migration & Integration

Migrates patient and practitioner data to HAPI FHIR storage using a hybrid architecture for healthcare applications.

PostgreSQL Admin

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

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.

SQL Query Optimizer

Analyzes and optimizes SQL queries to improve performance by identifying bottlenecks and suggesting efficient indexing strategies.

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.

PostgreSQL Advanced Query Architect

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

AgentDB Vector Search

Implements ultra-fast semantic vector search and HNSW indexing for RAG systems and intelligent document retrieval.

PostgreSQL Monitoring

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

PostgreSQL & Drizzle ORM

Architects type-safe database schemas and high-performance PostgreSQL 18 queries using Drizzle ORM best practices.

Spring Data JPA Expert

Simplifies database access by implementing robust repository patterns, custom queries, and performance-tuned data modeling for Spring Boot applications.

Supabase Next.js Integration

Integrates Supabase with Next.js App Router projects using secure patterns for authentication, database management, and row-level security.

Database Workflows & Optimization

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

Data Warehouse Architect

Architects robust data warehouses using star schemas, dimensional modeling, and enterprise SQL patterns for scalable analytics.

PostgreSQL Fundamentals

Master production-ready SQL foundations and schema design for PostgreSQL 16+ environments.

Drizzle ORM Development

Enforces database query conventions, type safety, and permission filtering using standardized Drizzle ORM patterns.

Database Design Architect

Architects production-grade SQL and NoSQL databases with automated schema validation and performance optimization patterns.

Redis Persistence & Recovery

Manages Redis data durability through RDB snapshots, AOF logging, and hybrid persistence strategies for high-availability systems.

Redis Strings & Caching

Implements production-grade Redis string operations, atomic counters, and efficient caching patterns for high-performance applications.

Redis Modules Master

Extends Redis capabilities with advanced modules including RedisJSON, RediSearch, RedisTimeSeries, and RedisBloom for complex data modeling.

Redis Installation & Setup

Deploys and configures production-ready Redis instances across multiple platforms with automated verification and troubleshooting.