Database Management Agent Skills

Stored Procedure Generator

Generates production-ready stored procedures, triggers, and functions to handle complex database logic and optimize performance.

Database Replication Manager

Manages database replication, high availability, and failover configurations for PostgreSQL and MySQL.

Database Documentation Generator

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

Database Archival System

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

Database Schema Comparison & Migration

Automates database schema comparisons, migration script generation, and rollback procedures for PostgreSQL and MySQL environments.

Database Schema Designer

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

Database Deadlock Detector

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

ORM Code Generator

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

Stored Procedure & Trigger Generator

Generates production-ready stored procedures, database functions, and triggers for PostgreSQL, MySQL, and SQL Server to optimize performance and data integrity.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers across multiple database systems to streamline complex backend logic.

Database Sharding Manager

Architects and implements horizontal database sharding strategies to scale data infrastructure beyond single-server limitations.

Database Schema Designer

Designs, visualizes, and normalizes robust database schemas while generating SQL and Mermaid ERD diagrams.

Database Caching Layer

Optimizes application performance by implementing multi-tier caching strategies including Redis, in-memory L1 layers, and CDN integration.

NoSQL Data Modeler

Designs optimized NoSQL data structures and schema definitions for document and key-value databases like MongoDB and DynamoDB.

Query Performance Analyzer

Analyzes database EXPLAIN plans to pinpoint performance bottlenecks and provide actionable optimization strategies.

Database Deadlock Detector

Identifies, analyzes, and resolves database lock contention and transaction deadlocks to maintain system stability.

Database Recovery Manager

Orchestrates comprehensive database disaster recovery, point-in-time recovery, and automated failover strategies for production systems.

NoSQL Data Modeler

Designs high-performance NoSQL schemas and data models optimized for MongoDB, DynamoDB, and other document-based databases.

Database ORM Generator

Generates optimized ORM models and database schemas across multiple frameworks to streamline backend data persistence.

FairDB Backup Manager

Automates PostgreSQL backup, restoration, and monitoring workflows using pgBackRest and Wasabi S3 storage.

Query Performance Analyzer

Analyzes database EXPLAIN plans to identify performance bottlenecks and provides actionable optimization recommendations.

Database Connection Pooler

Optimizes database performance and resource management by implementing and fine-tuning connection pooling configurations across multiple programming languages.

Cache Performance Optimizer

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

Database Replication Manager

Automates the configuration and management of database replication, failover, and high availability for distributed SQL environments.

NoSQL Data Modeler

Designs optimized NoSQL database schemas and data models for high-performance applications using MongoDB, DynamoDB, and more.

Database Audit Logger

Automates the implementation of robust database audit trails and change tracking to ensure data compliance and security.

Database Partition Manager

Automates the design, implementation, and management of database partitioning strategies to optimize performance for datasets exceeding 100GB.

Database Integrity & Validation

Automates the enforcement of database integrity through rigorous data type, range, and format validation rules.

Database Partition Manager

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

Database Documentation Generator

Automates the creation of comprehensive database schema documentation and architecture guides for SQL and NoSQL systems.