Database Management Agent Skills

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.

Database Integrity & Validation Engine

Ensures database reliability by automatically implementing data types, ranges, and referential integrity constraints using a specialized validation engine.

NoSQL Data Modeler

Designs high-performance NoSQL schemas and data models optimized for scalability in databases like MongoDB and DynamoDB.

ORM & Database Schema Generator

Generates production-ready ORM models and database schemas for frameworks like TypeORM, Prisma, and SQLAlchemy using natural language.

Database Query Performance Optimizer

Optimizes database query execution by analyzing EXPLAIN plans and identifying performance bottlenecks.

SQL Query Optimizer

Analyzes and refines SQL queries to enhance database performance through index recommendations and structural rewrites.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers for major SQL databases to optimize performance and enforce business logic.

Firebase Firestore Specialist

Implement and optimize Firebase Firestore databases with real-time synchronization, offline-first architecture, and robust security rules.

Data Quality Test Generator

Generates comprehensive dbt test suites using modern 1.10+ syntax to ensure data integrity and structural consistency across analytical models.

Unified SQL Data Analyst

Queries and joins data across PostgreSQL, MySQL, and SQLite databases using a unified SQL engine for advanced data exploration.

Supabase Expert

Provides comprehensive guidance for building secure and scalable applications using Supabase database, auth, storage, and edge functions.

PostgreSQL Nanoid Identifiers

Implements a hybrid ID strategy using Nanoids for public-facing identifiers and UUIDs for internal PostgreSQL references.

Understanding Data

Performs systematic data profiling and exploratory analysis to reveal the structure, quality, and relationships within relational databases.

BigQuery ETL Core

Establishes foundational project structures, naming conventions, and privacy standards for managing large-scale BigQuery ETL workflows.

Query Writer

Generates and maintains standardized BigQuery SQL and Python ETL scripts following Mozilla's data engineering conventions and partitioning patterns.

Query Performance Analysis

Analyzes database query performance, detects N+1 issues, identifies missing indexes, and guides safe index migrations.

dbt Model Builder

Constructs standardized dbt models following Kimball dimensional patterns and modern testing configurations.

Drizzle ORM Expert

Provides comprehensive documentation and implementation patterns for Drizzle ORM, covering type-safe queries, schema management, and multi-database integrations.

PostgreSQL Table Design

Designs optimized, production-grade PostgreSQL schemas following industry best practices and performance patterns.

JGI Lakehouse Query

Facilitates querying and exploring the Joint Genome Institute (JGI) Dremio Lakehouse, including GOLD and IMG genomics databases.

Supabase Database

Streamlines Supabase database management through optimized CRUD operations, Row Level Security (RLS) implementation, and PostgreSQL function support.