Database Management Agent Skills

ORM Code Generator

Generates production-grade ORM models and entity classes while providing comprehensive architectural guidance and automation for database schema management.

PostgreSQL Optimization

Optimizes PostgreSQL database performance through advanced indexing, query plan analysis, partitioning, and connection pooling strategies.

Database Optimization

Optimizes database performance through query analysis, advanced indexing strategies, and architectural best practices for PostgreSQL and MySQL.

Data Engineering Patterns

Implements robust ETL pipelines, data warehousing schemas, and Apache Spark processing for scalable data infrastructure.

Redis Patterns & Optimization

Implements high-performance Redis patterns including advanced caching strategies, rate limiting, and distributed locking.

SQL Research for dbplyr

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

Local Environment Manager

Manages local database operations, test data setup, and Docker-based environment configurations for the daily-api service.

Supabase Platform Specialist

Accelerates full-stack development with expert guidance on PostgreSQL 16, pgvector similarity search, and secure multi-tenant Row-Level Security.

Database Domain Specialist

Optimizes and implements advanced database patterns across PostgreSQL, MongoDB, and Redis for scalable modern applications.

Database Performance Patterns

Optimizes .NET data access layers using high-performance patterns like CQRS, batching, and efficient EF Core/Dapper configurations.

EF Core Best Practices & Patterns

Implements high-performance Entity Framework Core patterns, migration workflows, and database resiliency strategies for .NET applications.

Rails Model TDD Generator

Automates Ruby on Rails model creation following a strict Test-Driven Development (TDD) workflow for Rails 8.1 applications.

Qdrant Vector Search

Implements high-performance vector similarity search and metadata filtering for production-grade RAG and semantic search systems.

Chroma Vector DB

Manages local and server-based vector embeddings for RAG and semantic search applications.

Database Schema Designer

Designs production-ready SQL and NoSQL database schemas using industry-standard normalization, indexing, and performance optimization patterns.

WordPress SQL Query Manager

Executes SQL queries against WordPress development databases to inspect audit logs, debug table structures, and manage activity data.

Data Model Creation

Designs complex relational database schemas using Mermaid diagrams for enterprise-level documentation and automated relationship management.

Bkend Database Manager

Manages bkend.ai database schemas, CRUD operations, and complex data queries via MCP and REST APIs.

Senior Data Engineer

Builds scalable data pipelines, ETL/ELT systems, and production-grade data infrastructure using modern tools like Spark, Airflow, and dbt.

Django Performance Review

Analyzes and validates Django code to identify high-impact performance bottlenecks like N+1 queries, unbounded querysets, and missing database indexes.

MongoDB Management & Optimization

Provides expert guidance on MongoDB schema design, indexing strategies, and aggregation pipeline optimization for high-performance database management.

MongoDB Setup & Troubleshooting

Streamlines the configuration and troubleshooting of MongoDB MCP integrations for Claude Code.

Supabase MCP Setup

Streamlines the configuration and troubleshooting of Supabase MCP integrations within the Claude Code environment.

Supabase Database Explorer

Enables seamless exploration and querying of Supabase databases directly through Claude's interface.

Firebase Firestore Database

Builds and manages scalable NoSQL databases with real-time synchronization, offline support, and advanced querying capabilities.

Axiom Database Migration

Ensures safe database schema evolution and prevents data loss in iOS and macOS applications using SQLite, GRDB, or SwiftData.

Datasette Plugin Development

Provides comprehensive guidance and implementation patterns for building, testing, and deploying custom plugins for the Datasette data exploration tool.

Backend Migration Standards

Creates and manages database migrations with reversible changes, proper naming conventions, and zero-downtime deployment strategies.

Backend Models Standards

Defines robust and maintainable database models with clear naming, appropriate data types, constraints, and relationships.

Database Performance Patterns

Optimizes .NET data access layers using high-performance patterns like CQRS, batching, and efficient querying with EF Core and Dapper.