Database Management Agent Skills

SQL Optimization Patterns

Optimizes database performance by identifying and fixing slow SQL queries through systematic indexing, query plan analysis, and efficient execution patterns.

Database Schema & Migration Implementation

Architects robust database schemas and manages SQL migrations using Flyway and Exposed ORM.

Database Implementation & Migrations

Manages database schema design, Flyway migrations, and query optimization using Exposed ORM and SQL.

Database Archival System

Automates historical data migration from primary databases to cost-effective cold storage or archive tables while maintaining compliance.

Database Data Seeder

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

PostgreSQL Schema Architect

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

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.

Rails ActiveRecord Optimization Patterns

Optimizes Ruby on Rails database interactions with production-grade ActiveRecord patterns and performance best practices.

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.

Database Migration Expert

Execute and manage database migrations across multiple ORMs with zero-downtime strategies and robust rollback procedures.

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.

Enterprise Database Architect

Architects, optimizes, and manages enterprise-grade SQL and NoSQL database systems with expert-level performance tuning and security.

SQL Optimization Patterns

Optimizes SQL database performance through systematic query plan analysis, advanced indexing strategies, and efficient data access patterns.

Database Backup Automator

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

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.

Database Operations

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

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.

DuckDB ETL Pipeline

Automates the ingestion of CSV and Excel files into DuckDB with integrated data validation and markdown reporting.

Database Sharding Manager

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