Database Management Agent Skills

Database Archival System

Automates database archival by migrating historical records to cold storage or archive tables to optimize performance and storage costs.

Database Data Seeder Generator

Generates realistic, schema-aware test data and database seed scripts to accelerate development and testing workflows.

Database Schema Designer

Designs, normalizes, and visualizes relational database schemas with automated ERD and SQL generation.

Database Sharding Manager

Designs and implements horizontal database sharding strategies to scale high-traffic applications beyond single-server capacity.

FairDB Backup Manager

Automates PostgreSQL backup management and disaster recovery using pgBackRest and Wasabi S3 storage.

SQL Query Optimizer

Analyzes and optimizes SQL queries to improve database performance through indexing suggestions and structural rewrites.

Data Validation Engine

Automates database integrity checks by enforcing strict data types, ranges, and custom business rules across multi-database environments.

Database Schema Diff & Migration

Compares database schemas and generates transaction-safe migration scripts with rollback procedures for PostgreSQL and MySQL.

Database Schema Diff Tool

Compares database schemas, generates transaction-safe migration scripts, and creates rollback procedures for PostgreSQL and MySQL environments.

Database Backup Automator

Automates database backup scheduling, script generation, and restore procedures for popular SQL and NoSQL engines.

Database Data Validation Engine

Automates the enforcement of data integrity, business rules, and schema constraints across multi-database environments.

Database Audit Logger

Implements comprehensive database audit trails and change tracking to ensure data integrity and regulatory compliance.

Database Sharding Manager

Designs and implements horizontal database sharding strategies to scale applications beyond single-server limitations.

Database Recovery Manager

Automates database disaster recovery, point-in-time recovery, and failover strategies for production environments.

Cache Performance Optimizer

Optimizes application caching strategies by analyzing hit rates, TTL configurations, and key designs to maximize system performance.

Database Archival System

Automates the migration of historical database records to cold storage or archive tables to optimize performance and ensure data compliance.

Database Testing & Data Manager

Automates database testing workflows by generating realistic test data, managing transactional rollbacks, and validating schema integrity.

Database Index Advisor

Analyzes database workloads and query patterns to provide actionable recommendations for optimizing and managing indexes.

Database Recovery Manager

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

Cache Performance Optimizer

Optimizes application caching strategies by analyzing hit rates, TTL configurations, and key structures to enhance system performance.

Database Connection Pooler

Optimizes database connection pooling to enhance application performance and resource management.

Database Testing Manager

Automates database testing workflows by generating realistic test data, managing transactional integrity, and validating schema structures.

Database Schema Diff & Migration Tool

Automates database schema comparisons and generates transaction-safe migration scripts for PostgreSQL and MySQL environments.

Database Archival System

Automates database archival and record migration to cold storage for optimized performance and cost-effective data lifecycle management.

Database Caching Adapter

Implements multi-tier caching architectures using Redis and in-memory layers to optimize database performance and reduce latency.

Data Seeder Generator

Generates realistic test data and database seed scripts to populate development and testing environments efficiently.

Database Backup Automator

Automates the creation of scheduled, encrypted, and compressed database backups with integrated recovery procedures.

Database Index Advisor

Analyzes database query patterns and workloads to provide actionable recommendations for index optimization and storage efficiency.

Firestore Operations Manager

Manages Firebase Firestore operations, A2A agent communication patterns, and MCP server integrations for advanced database workflows.

Database Partition Manager

Automates the design and implementation of database partitioning strategies to optimize query performance and manage large-scale datasets.