Database Management Agent Skills

Database Migration & Schema Evolution

Manages complex database schema transitions and data transformations across multiple ORMs with a focus on zero-downtime and safety.

Wheels Migration Generator

Generates database-agnostic CFWheels migrations for schema management, table modification, and data versioning.

MongoDB Database Explorer

Enables read-only exploration and querying of MongoDB databases using Model Context Protocol tools.

MongoDB Database Explorer

Explores and queries MongoDB databases to retrieve data, inspect schemas, and analyze collections through secure, read-only access.

SQL Research Specialist

Conducts systematic research on SQL syntax and database behaviors to ensure accurate implementation and translation.

MongoDB Query & Explorer

Enables read-only exploration and querying of MongoDB databases through an integrated MCP server.

Database Schema & Query Expert

Manages and optimizes MongoDB and PostgreSQL databases through expert schema design, query generation, and administration patterns.

Database Schema Architect

Analyzes database schemas and migration files to visualize data models, map table relationships, and accelerate developer onboarding.

Pinecone Vector Database Integration

Streamlines the implementation and optimization of Pinecone vector databases for production-grade RAG and semantic search applications.

Database Management & Design

Manages, designs, and optimizes MongoDB and PostgreSQL databases through schema modeling, query generation, and performance tuning.

WordPress SQL Database Manager

Executes SQL queries against WordPress development databases running in Docker MariaDB environments.

Unified Database Management

Streamlines schema design, query optimization, and administrative workflows for MongoDB and PostgreSQL database systems.

WordPress Database SQL Manager

Executes SQL queries against WordPress development databases via Docker containers to inspect data and debug issues.

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, EXPLAIN plan analysis, and query restructuring patterns.

Database Architect & Manager

Streamlines the design, management, and optimization of MongoDB and PostgreSQL databases through schema modeling, complex querying, and performance tuning.

DBT Transformation Patterns

Implements production-ready dbt patterns for scalable data transformation, model organization, and analytics engineering best practices.

Data Quality Frameworks

Implements comprehensive data validation using Great Expectations, dbt tests, and data contracts to ensure reliable data pipelines.

Projection Patterns for Event Sourcing

Build efficient read models and materialized views from event streams to optimize query performance and implement CQRS architectures.

RepoQL SQL Reference

Queries repository metadata and code structures using DuckDB SQL to gain deep insights into codebase architecture and health.

Rails Delegated Roles

Implements clean role delegation in Ruby on Rails applications using the delegated_type pattern to separate role-specific logic and data.

RepoQL Search Patterns

Enables advanced semantic search, SQL querying, and result ranking for efficient repository exploration.

Database Migration

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

Event Store Design & Implementation

Designs and implements robust event store architectures for event-sourced systems and microservices.

Entity-Yajña Knowledge Linker

Synchronizes triplet entities with content nodes to build searchable, high-performance knowledge graphs within the Soul ecosystem.

PostgreSQL Table Design

Architects optimized PostgreSQL database schemas following production-grade best practices for performance, scalability, and data integrity.

Supabase Patterns & Best Practices

Standardizes Supabase implementations by providing patterns for authentication, row-level security, and database schema design.

PostgreSQL Rails Analyzer

Audits Ruby on Rails applications for PostgreSQL performance bottlenecks, N+1 queries, and missing database indexes.

PostgreSQL & Supabase Migration Assistant

Manages PostgreSQL database migrations and Row-Level Security (RLS) policies for Supabase projects with safe, reversible schema changes.

Master Data Release Key Reporter

Automates the extraction, analysis, and reporting of project-specific master data based on unique release keys.

Master Data CSV Validator

Validates master data CSV files against database schemas and templates to ensure data integrity and deployment readiness.