Database Management Agent Skills

DataFusion Query Advisor

Optimizes Apache DataFusion SQL queries and DataFrame operations through advanced performance analysis and best practices.

InterSystems IRIS DTL Transformations

Guides the development, testing, and implementation of Data Transformation Language (DTL) for InterSystems IRIS interoperability productions.

Supabase Database Migrations

Manages idempotent Supabase database migrations, Row Level Security policies, and SaaS schema patterns via MCP.

Laravel Eloquent Expert

Optimizes Laravel database interactions using Eloquent ORM patterns, advanced relationships, and query performance techniques.

Rust Parquet Optimization

Optimizes Parquet file operations in Rust to improve query performance, reduce storage costs, and prevent memory issues.

SaaS Rapid Feature Implementer

Implements end-to-end SaaS features including database migrations, backend logic, and frontend components in a single streamlined workflow.

Database Design Patterns

Implements industry-standard database design patterns, indexing strategies, and migration best practices for optimized data persistence.

AgentDB Advanced Features

Optimizes distributed AI systems with low-latency QUIC synchronization, hybrid vector search, and advanced multi-database management.

AgentDB Advanced Features

Optimizes AgentDB implementations with advanced capabilities like QUIC synchronization, hybrid search, and distributed database management.

Drizzle ORM Workflow Manager

Manages Drizzle ORM and drizzle-kit workflows including migrations, schema generation, and specialized database reset flows.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through quantization, HNSW indexing, and advanced caching strategies to maximize search speed and minimize memory usage.

Bulk Static Data Sync

Optimizes high-volume data synchronization from external APIs to databases using multi-row insert patterns and foreign key pre-filtering.

V3 Memory Unification & AgentDB Integration

Unifies disparate AI memory systems into a high-performance AgentDB backend with HNSW vector search for massive retrieval speedups.

Windmill PostgreSQL Scripting

Streamlines the creation and deployment of PostgreSQL scripts optimized for the Windmill orchestration platform.

Database Archival & Retention

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

Database Audit Logging

Automates the implementation of database audit trails and change tracking to ensure data integrity and regulatory compliance.

Database Backup Automator

Automates secure database backups and restoration procedures for PostgreSQL, MySQL, MongoDB, and SQLite.

Database Caching Adapter

Implements multi-tier caching architectures to optimize database performance and reduce latency using Redis, in-memory layers, and CDNs.

Database Deadlock Detector

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

Database Migration & Schema Diff Tool

Automates database schema comparisons and generates safe, production-grade migration scripts with built-in rollback procedures.

Database Documentation Generator

Automates the generation of comprehensive database documentation, ERD diagrams, and data dictionaries from existing schemas.

Database Index Advisor

Analyzes database query patterns and workloads to provide actionable recommendations for index optimization and performance tuning.

Database Migration Manager

Automates the creation, application, and rollback of database schema migrations across multiple SQL and NoSQL engines.

Database Partitioning Manager

Automates the design, implementation, and management of database partitioning strategies to optimize query performance and data archival.

Database Recovery & Backup Manager

Automates database disaster recovery, point-in-time recovery (PITR), and failover strategies to ensure production system resilience.

Database Replication Manager

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

Database Schema Designer

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

Database Sharding Manager

Architects and implements horizontal database sharding strategies to scale data storage and performance across multiple servers.

Database Transaction Monitor

Monitors database transactions in real-time to detect long-running queries, lock contention, and transaction anomalies.

Database Seeder & Data Generator

Generates realistic, schema-aware test data and database seed scripts to populate development and testing environments.