Database Management Agent Skills

Database Replication Manager

Automates the configuration and management of database replication, failover, and high availability for robust data consistency.

Database Caching Layer

Implements production-ready multi-tier caching architectures to optimize database performance and reduce latency.

Cache Performance Optimizer

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

Database Schema Designer

Architects normalized database schemas, generates Mermaid ERD diagrams, and produces optimized SQL CREATE statements for robust data modeling.

Database Schema Designer

Designs, normalizes, and visualizes efficient database schemas using industry best practices and automated ERD generation.

Database Sharding Manager

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

Data Quality Validation Patterns

Provides standardized SQL templates and strategies for validating data consistency between dbt models during migrations and refactors.

ORM Code Generator

Automates the creation of ORM models, entity classes, and database schemas with standardized best practices and comprehensive documentation.

Python Database Patterns

Implements modern SQLAlchemy 2.0 patterns and asynchronous database workflows for Python applications.

NoSQL Data Modeler

Designs high-performance NoSQL schemas and data models optimized for scalability and specific query access patterns.

FairDB Backup Manager

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

Database Design Decisions

Guides architectural choices for database systems, schema design, and scaling patterns to optimize performance and consistency.

Database ORM Generator

Generates production-ready ORM models and database schemas across multiple frameworks and programming languages.

Stored Procedure Generator

Automates the creation of optimized, production-ready SQL stored procedures and database functions with built-in best practices.

Database Archival System

Automates the transfer of historical database records to archive tables or cold storage to optimize performance and reduce primary storage costs.

Database Deadlock Detector

Detects, resolves, and prevents database deadlocks across PostgreSQL, MySQL, and MongoDB environments to ensure system stability.

Stored Procedure Generator

Generates production-ready stored procedures, triggers, and functions for PostgreSQL, MySQL, and SQL Server databases.

Database Deadlock Detector

Identifies and resolves database lock contention and transaction deadlocks to improve system stability and performance.

Database Deadlock Detector

Detects, analyzes, and resolves database deadlocks by monitoring lock contention and transaction patterns.

Database Audit Logger

Implements comprehensive audit logging and change tracking to ensure database security and regulatory compliance.

Database Migration & Schema Management

Execute database migrations, schema transformations, and data management tasks across multiple ORMs with zero-downtime strategies.

PostgreSQL Schema Design

Architects production-grade PostgreSQL schemas using performance-tuned patterns, advanced data types, and indexing best practices.

SQL Optimization Patterns

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

Database Designer

Generates production-ready database schemas, SQL scripts, and visual ER diagrams for diverse business systems.

Go Database Management

Streamlines Go database operations using production-ready patterns for SQL, ORMs, transactions, and schema migrations.

Database Index Advisor

Optimizes database performance by analyzing query workloads to recommend missing indexes and identify redundant ones.

Database Backup Automator

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

Data Validation Engine

Ensures database integrity by automatically enforcing data types, ranges, formats, and complex business rules across application schemas.

Database Diff & Migration Tool

Synchronizes and compares PostgreSQL and MySQL database schemas while generating safe migration scripts and rollback procedures.

Database Schema Designer

Architects robust database schemas and automates migrations using industry best practices for SQL and NoSQL systems.