Database Management Agent Skills

SQL Syntax Research

Conducts deep research into database-specific SQL syntax and behaviors to ensure precise implementation of SQL translations.

MongoDB Database Explorer

Facilitates read-only MongoDB database interactions, including schema exploration, data querying, and collection analysis.

Database Migration & Schema Safety

Executes safe database migrations, schema transformations, and zero-downtime data transfers with built-in rollback strategies.

Databases & Data Modeling

Streamlines database management by providing optimized workflows and best practices for both MongoDB and PostgreSQL systems.

WordPress SQL Database Tools

Executes SQL queries against WordPress development databases using Docker Compose to inspect data and debug database issues.

Hostinger VPS Database Manager

Manages shared PostgreSQL, Redis, and MongoDB instances on Hostinger VPS infrastructure via Docker commands.

SQL Research & Documentation

Researches and documents database-specific SQL syntax and behaviors to ensure accurate R-to-SQL translations for dbplyr.

Data Migration & Schema Evolution

Orchestrates safe database migrations and schema transformations with zero-downtime strategies and automated rollback procedures.

Supabase Storage Manager

Manages file uploads, storage buckets, signed URLs, and asset policies within the Supabase ecosystem.

Repository & Finder Architect

Generates standardized Repository and Finder interfaces to implement clean, CQRS-compliant data persistence layers.

MongoDB Application Development

Streamlines MongoDB integration across Node.js, Python, and Java with optimized patterns for transactions, connection pooling, and error handling.

NoSQL Data Modeler

Designs high-performance NoSQL data models and schema definitions for document and key-value databases.

CSV Database Normalizer

Transforms flat CSV files into normalized relational database structures by detecting functional dependencies and generating SQL schemas.

Database Migration

Executes and manages database schema migrations, data transformations, and zero-downtime deployment strategies across major ORMs.

Database Audit Logger

Implements robust database audit trails and logging strategies to ensure data compliance and change tracking.

Database Migration Specialist

Execute zero-downtime database migrations, schema transformations, and data transfers across multiple ORMs and platforms.

Database Diff & Migration Tool

Generates production-grade database schema comparisons, migration scripts, and rollback procedures for PostgreSQL and MySQL.

MoAI Domain Database Specialist

Optimizes modern data layers through expert-level implementation patterns for PostgreSQL, MongoDB, Redis, and polyglot persistence architectures.

Database Testing & Integrity

Ensures data persistence reliability through schema validation, migration testing, and transaction isolation verification.

SQLite Best Practices

Optimizes SQLite performance and concurrency in Python applications using WAL checkpointing and stateful batch connections.

CloudBase Document Database Web SDK

Provides standardized implementation patterns and guidance for managing CloudBase document databases in web applications.

Database Migration & Schema Management

Executes seamless database schema and data migrations across multiple ORMs with robust rollback and zero-downtime strategies.

TimescaleDB Hypertable Setup

Guides the design and implementation of optimized TimescaleDB hypertables, compression policies, and continuous aggregates for high-performance time-series data.

Data SQL Optimization & Modeling

Optimizes SQL queries and database schemas using industry-standard patterns for performance, maintainability, and scalability.

Database Migration Manager

Automates the creation, application, and rollback of version-controlled database migrations across SQL and NoSQL environments.

MongoDB Aggregation Pipeline Builder

Optimizes and generates complex MongoDB aggregation pipelines for sophisticated data transformation and analysis.

Prisma Data Access Guidelines

Manages type-safe database access layers using Prisma, DAO patterns, and PostgreSQL RBAC best practices.

ORM Code Generator

Generates production-ready ORM models and database schemas across multiple frameworks and languages from natural language descriptions.

FairDB Backup Manager

Manages automated PostgreSQL backups and point-in-time restorations for FairDB databases using pgBackRest and Wasabi S3 storage.

Database Migration Manager

Manages database schema evolution through automated, version-controlled migrations for SQL and NoSQL databases.