Database Management Agent Skills

Backend Models

Architects robust database models following Eloquent best practices, including relationship definitions, data typing, and multi-layer validation.

Database Migration Expert

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

Redis Cache Management

Manages Redis cache operations including key-value manipulation, production-safe pattern searching, and TTL inspection.

PostgreSQL Database Manager

Manages PostgreSQL database connections and executes secure SQL queries with automated schema introspection and result formatting.

Elasticsearch & OpenSearch

Integrates Elasticsearch and OpenSearch for complex search queries, data aggregations, and comprehensive index management.

PostGIS Geospatial Development

Implements best practices for querying and managing geospatial data in PostgreSQL with PostGIS.

Beanie ODM for MongoDB

Simplifies MongoDB integration in FastAPI applications using Beanie ODM for asynchronous document mapping and advanced query patterns.

Hostinger VPS Database Manager

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

MongoDB Transactions

Implements robust ACID transactions and multi-document operations for MongoDB data consistency.

ORM Code Generator

Generates production-ready ORM models and database schemas from natural language descriptions or existing database structures.

Database Migration & ORM Master

Streamlines database schema evolution, data transformations, and zero-downtime deployments across major ORMs and SQL platforms.

SQL Query Optimizer

Analyzes and optimizes SQL queries to improve database performance, resolve N+1 issues, and ensure efficient index usage.

Prisma Data Access Guidelines

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

MongoDB Aggregation Pipeline Builder

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

SQLite Best Practices

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

CSV Database Normalizer

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

MongoDB Application Development

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

Repository & Finder Architect

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

Supabase Storage Manager

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

Database Backup Automator

Automates scheduled backups, encryption, and restoration procedures for PostgreSQL, MySQL, MongoDB, and SQLite databases.

Data Import and History Management

Streamlines complex data ingestion from CSV and XLSX files while implementing a robust three-tier history management framework for audit trails.