Database Management Agent Skills

Database Migration & ORM Tools

Executes seamless database migrations across major ORMs with zero-downtime strategies and robust rollback procedures.

SQL Optimization Patterns

Optimizes database performance through advanced SQL query tuning, indexing strategies, and execution plan analysis.

Database Migration Expert

Execute and manage database migrations across multiple ORMs with zero-downtime strategies and robust rollback procedures.

Database Recovery Manager

Automates comprehensive database recovery operations, including disaster recovery setups, point-in-time restores, and failover orchestration.

Database Archival System

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

Data Validation Engine

Ensures database integrity by automatically enforcing data types, constraints, and complex business rules across multi-database environments.

PostgreSQL Schema Architect

Architects optimized PostgreSQL schemas using industry best practices for data integrity, performance, and scalability.

Enterprise Database Architect

Architects, optimizes, and manages enterprise-grade SQL and NoSQL database systems with expert-level performance tuning and security.

PostgreSQL Schema Architect

Designs high-performance, production-grade PostgreSQL schemas optimized for durability, scalability, and modern data standards.

Schema Optimization Orchestrator

Orchestrates a multi-phase database schema optimization workflow with automated validation and impact assessment.

Database Schema Designer

Designs and visualizes normalized database schemas while generating production-ready SQL scripts.

Database Partition Manager

Automates the design, implementation, and management of table partitioning strategies to optimize performance for large-scale databases.

Redis Architect

Optimizes application performance by designing robust Redis implementations for caching, rate limiting, and distributed locks.

Data Governance Manager

Manages data lineage, metadata cataloging, access control, and compliance standards for modern data platforms.

Data Modeling Essentials

Designs optimized database schemas, dimensional models, and normalized structures for efficient data analytics and storage.

Pipeline Design

Architects robust ETL/ELT data pipelines with standardized patterns for reliability and scalability.

Flyway Migration Generator

Generates standardized Flyway SQL migrations optimized for DDD scaffolds without foreign key constraints.

Database Replication Manager

Automates the setup and management of database replication, failover, and high availability for PostgreSQL and MySQL.

Backend Models

Defines and optimizes database models and ORM entities with robust relationships, data validation, and integrity constraints.

Backend Models

Defines robust database schemas and ORM entities with precise data types, relationships, and validation constraints.

NoSQL Data Modeler

Designs and optimizes high-performance NoSQL schemas for MongoDB, DynamoDB, and other document-based databases using industry best practices.

Database Migration (SQLModel + Alembic)

Automates database migration workflows for SQLModel projects using Alembic with strict enforcement of model-first principles and safety checks.

Database Index Advisor

Analyzes query workloads and provides actionable recommendations to optimize database indexing strategies for improved performance.

Query Performance Analyzer

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

Drizzle Cube Definition

Defines type-safe semantic layer cubes using Drizzle ORM for multi-tenant analytics and business logic abstraction.

Database Designer

Infers and generates database schemas, migrations, and ORM models directly from natural language feature descriptions.

Supabase Migration Toolkit

Manages Supabase database migrations using standardized naming conventions, automated linting, and security-first SQL templates.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers across major SQL databases using natural language.

DynamoDB Single-Table Designer

Architects high-performance, production-ready AWS DynamoDB schemas using single-table design principles to optimize scalability and cost.

AGI Memory System

Manages persistent AI memory through semantic, episodic, and working storage to enhance long-term context and knowledge recall.