Database Management Agent Skills

Database Designer

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

Database Migration Best Practices

Implements industry-standard database migration strategies including zero-downtime patterns, rollback procedures, and schema safety protocols.

Django Pro Architect

Enforces opinionated, production-ready Django development patterns and project structures.

Frappe DocType Generator

Generates production-ready Frappe Framework v15 DocTypes with service layers, repository patterns, and full test coverage.

Database Migrator

Manages database schema evolution through version-controlled migrations, automated script generation, and safe rollback procedures.

Cool MySQL

Provides comprehensive guidance and implementation patterns for the cool-mysql Go library to optimize database operations, caching, and connection management.

Brokle Migration Workflow

Manages database migration lifecycles for PostgreSQL and ClickHouse through automated CLI commands, schema enforcement, and data seeding.

Docker Database Specialist

Configures production-ready database containers with integrated security, persistence, and health checks.

Qdrant Collection Manager

Manages Qdrant vector collections for optimized semantic search across PDF, code, and markdown documents.

MeiliSearch Index Manager

Manages MeiliSearch indexes for full-text search, including lifecycle tasks, health monitoring, and data migration.

Arc Corpus Manager

Manages dual-indexed corpora to synchronize semantic and full-text search capabilities using Qdrant and MeiliSearch.

Database Diff & Migration Tool

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

Database Backup Automator

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

Event Store Design

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

Data Validation Engine

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

Database Index Advisor

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

Database Schema Designer

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

Automated Database Backups

Automates the creation of scheduled database backup scripts, encryption protocols, and restoration procedures for major database engines.

Database Partition Manager

Optimizes large-scale database performance by automating the design and implementation of table partitioning strategies.

Database Caching Layer

Implements high-performance multi-tier caching architectures to optimize database latency and reduce server load.

Database Query Performance Analyzer

Analyzes and optimizes database query performance by interpreting EXPLAIN plans and identifying execution bottlenecks.

Database Deadlock Detector

Identifies, analyzes, and resolves database deadlock issues to ensure optimal application performance and system stability.

PostgreSQL Table Design

Designs high-performance PostgreSQL schemas using industry-standard best practices for data types, indexing, and performance.

Database Migration Manager

Automates the creation, application, and rollback of version-controlled database schema migrations for SQL and NoSQL databases.

Query Performance Analyzer

Optimizes database query performance using automated analysis and structured implementation workflows for SQL and NoSQL systems.

Database Recovery Manager

Automates database management, optimization, and recovery operations using production-grade safety protocols and automation scripts.

Database Migration Manager

Manages database schema migrations across SQL and NoSQL environments with automated workflows and safety-first validation.

FairDB Backup Manager

Automates PostgreSQL backup orchestration, recovery, and monitoring using pgBackRest and Wasabi S3 storage for FairDB environments.

Database Connection Pooler

Optimizes and manages database connection pooling to enhance system performance and resource efficiency.

Database Cache Layer Implementation

Implements multi-tier caching strategies using Redis, in-memory L1 layers, and CDNs to optimize database performance and reduce load.