Database Management Agent Skills

Database Schema Designer

Architects optimized relational database schemas through normalization, ERD visualization, and automated SQL generation.

Cache Performance Optimizer

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

Database Schema Designer

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

ORM Code Generator

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

Database Schema Designer

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

Data Quality Validation Patterns

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

NoSQL Data Modeler

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

Python Database Patterns

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

Database Sharding Manager

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

Database Design Decisions

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

FairDB Backup Manager

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

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 Audit Logger

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

Stored Procedure Generator

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

Database Deadlock Detector

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

Stored Procedure Generator

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

Database Deadlock Detector

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

Database ORM Generator

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

Database Deadlock Detector

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

Database Documentation Generator

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

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.

Event Store Design

Architects and implements robust, scalable event storage systems for event-sourced backend applications.

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.

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.