Database Management Agent Skills

SQL Query Optimizer

Optimizes SQL query performance by applying proven patterns like index strategies, JOIN restructuring, and window function implementations.

SQL Query Optimization

Optimizes PostgreSQL database performance through structured analysis, index recommendations, and advanced query refactoring patterns.

Database Data Seeder

Generates realistic test data and database seed scripts to populate development and testing environments while maintaining relational integrity.

dbt Analytics Engineering Patterns

Implements production-grade dbt patterns for organized, scalable, and well-tested analytics engineering pipelines.

Database Query Performance Analyzer

Optimizes database performance by analyzing queries, identifying bottlenecks, and automating structural improvements across SQL and NoSQL environments.

Multi-tenant Design & Context Architect

Establishes critical project context and architectural requirements by analyzing multi-tenant PRDs and coding standards before code implementation.

PostgreSQL Schema Architect

Designs high-performance, industry-standard PostgreSQL schemas following expert-level normalization and optimization patterns.

SQL Optimization Patterns

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

Database Migration & Schema Management

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

Projection Patterns for Event Sourcing

Builds optimized read models and materialized views by projecting event streams into query-efficient databases and search indexes.

Data Quality Frameworks

Implements automated data validation and quality assurance workflows using Great Expectations, dbt tests, and data contracts.

Lutece DAO & Home Patterns

Standardizes the creation and modification of DAO and Home layer classes for Lutece 8 applications.

Lutece ElasticData Integration

Implements high-performance Elasticsearch DataSources for the Lutece 8 platform using standard patterns and CDI auto-discovery.

Database Sharding Manager

Implements horizontal database sharding strategies to scale applications beyond single-server performance and storage limitations.

Database Replication Manager

Automates the configuration and management of database replication, failover, and high availability for PostgreSQL and MySQL.

Database Data Seeder

Generates realistic, relationally-consistent test data and database seed scripts for development and testing environments.

SQL Query Optimizer

Optimizes SQL database performance by analyzing query structures, identifying bottlenecks, and recommending efficient indexing strategies.

FairDB Backup Manager

Automates PostgreSQL backup and recovery operations using pgBackRest and Wasabi S3 storage for FairDB databases.

FairDB Backup Manager

Manages automated PostgreSQL backups using pgBackRest and Wasabi S3 storage to ensure high availability and disaster recovery for FairDB databases.

CloudBase Relational DB Manager (MCP)

Manages CloudBase Relational Databases using MCP tools for secure SQL execution and security rule configuration.

Validate with Database

Validates PostgreSQL schema assumptions and cross-references DDL outputs using live database connections.

SQL Optimization Patterns

Optimizes SQL query performance through advanced indexing strategies, execution plan analysis, and efficient database design patterns.

Holochain DNA Development (Nondominium)

Develops ValueFlows-compliant Holochain DNA with a focus on integrity/coordinator architecture and WASM optimization.

Database Cache Layer

Implements high-performance multi-tier caching architectures to reduce database load and minimize query latency.

InsForge Database Schema Patterns

Provides optimized PostgreSQL schema templates and Row Level Security (RLS) policies for InsForge and PostgREST backends.

Database Backup Automator

Automates database backup scheduling, encryption, and recovery procedures across multiple SQL and NoSQL engines.

SQL Query Formatter

Standardizes SQL queries using a professional, vertically-aligned, and lowercase formatting style for improved readability.

Database Operations

Streamlines database interactions by providing standardized patterns for CRUD operations, session management, and performance optimization.

Database Recovery Manager

Automates database disaster recovery, point-in-time recovery, and failover strategies to ensure high availability and data resilience.

Database Documentation Generator

Generates comprehensive database documentation, ERD diagrams, and data dictionaries directly from existing schemas.