Database Management Agent Skills

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.

Data Validation Engine

Automates the implementation of database integrity constraints, data type validation, and business rules across multiple database environments.

SQL Optimization Patterns

Optimizes SQL queries and database performance through indexing strategies, EXPLAIN plan analysis, and efficient query patterns.

Database Sharding Manager

Designs and implements horizontal database sharding strategies to scale data architecture across multiple server instances.

Database Migration Manager

Manages database schema evolution through automated, version-controlled migrations for SQL and NoSQL databases.

FairDB Backup Manager

Manages automated PostgreSQL backups and point-in-time restorations for FairDB databases using pgBackRest and Wasabi S3 storage.

ORM Code Generator

Generates production-ready ORM models and database schemas across multiple frameworks and languages from natural language descriptions.

Database Migration Manager

Automates the creation, application, and rollback of version-controlled database migrations across SQL and NoSQL environments.

Data SQL Optimization & Modeling

Optimizes SQL queries and database schemas using industry-standard patterns for performance, maintainability, and scalability.

TimescaleDB Hypertable Setup

Guides the design and implementation of optimized TimescaleDB hypertables, compression policies, and continuous aggregates for high-performance time-series data.

Database Migration & Schema Management

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

CloudBase Document Database Web SDK

Provides standardized implementation patterns and guidance for managing CloudBase document databases in web applications.

Database Testing & Integrity

Ensures data persistence reliability through schema validation, migration testing, and transaction isolation verification.

MoAI Domain Database Specialist

Optimizes modern data layers through expert-level implementation patterns for PostgreSQL, MongoDB, Redis, and polyglot persistence architectures.

Database Diff & Migration Tool

Generates production-grade database schema comparisons, migration scripts, and rollback procedures for PostgreSQL and MySQL.

Database Migration Specialist

Execute zero-downtime database migrations, schema transformations, and data transfers across multiple ORMs and platforms.

Database Audit Logger

Implements robust database audit trails and logging strategies to ensure data compliance and change tracking.

PostgreSQL Schema Architect

Architects optimized PostgreSQL database schemas following industry best practices for performance, scalability, and data integrity.

Event Store Design

Architects and implements robust event stores for high-performance event-sourced systems.

dbt Transformation Patterns

Implements production-ready dbt patterns for scalable analytics engineering, model organization, and data quality testing.

Database Migrations & Schema Evolution

Manages database schema changes and data transformations across multiple ORMs with robust rollback and zero-downtime strategies.

Event Sourcing Projection Patterns

Builds high-performance read models and materialized views from event streams using CQRS and projection patterns.

Database Migration

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

NoSQL Data Modeler

Designs high-performance NoSQL data models and schema definitions for document and key-value databases.

Data Migration & Schema Evolution

Orchestrates safe database migrations and schema transformations with zero-downtime strategies and automated rollback procedures.

SQL Optimization Patterns

Optimizes SQL query performance through systematic indexing, EXPLAIN plan analysis, and efficient query refactoring patterns.

SQL Research & Documentation

Researches and documents database-specific SQL syntax and behaviors to ensure accurate R-to-SQL translations for dbplyr.

WordPress SQL Database Tools

Executes SQL queries against WordPress development databases using Docker Compose to inspect data and debug database issues.

Databases & Data Modeling

Streamlines database management by providing optimized workflows and best practices for both MongoDB and PostgreSQL systems.