Database Management Agent Skills

Understanding Data

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

MongoDB Sharding Strategist

Optimizes MongoDB performance through expert shard key selection, zone configuration, and cluster distribution strategies.

MySQL Migration Patterns

Implements safe, reversible, and production-grade MySQL schema migrations using industry-standard patterns and zero-downtime tools.

Database Migration & Schema Evolution

Automates database schema migrations, data transformations, and zero-downtime deployment strategies across multiple ORMs.

PostgreSQL Performance Tuning

Analyzes and optimizes PostgreSQL query execution and database configuration using a systematic, data-driven approach.

PostgreSQL Conventions

Enforces modern PostgreSQL best practices, naming conventions, and schema design patterns for robust database development.

MongoDB Aggregation Patterns

Optimizes MongoDB aggregation pipelines with proven performance patterns and structural best practices.

SQL Optimization Patterns

Optimizes SQL database performance through systematic query plan analysis, advanced indexing strategies, and efficient data access patterns.

SQLite Development Conventions

Implements standardized best practices for SQLite database design, performance optimization, and schema integrity.

PostgreSQL Migration Patterns

Architects safe, reversible, and production-grade PostgreSQL schema migrations using zero-downtime patterns.

SQLite Embedded Patterns

Implements production-grade SQLite patterns for mobile, desktop, and serverless applications.

MySQL Best Practices & Conventions

Enforces standardized MySQL 8.0+ development patterns for schema design, indexing, and data integrity.

MongoDB Best Practices & Conventions

Enforces professional MongoDB data modeling, BSON type selection, and schema design standards for high-performance database development.

MySQL Performance Tuning

Analyzes and optimizes MySQL database performance through query execution plan inspection and strategic indexing.

Advanced Redis Patterns

Implements production-grade Redis architectures including advanced caching strategies, multi-algorithm rate limiting, and distributed synchronization patterns.

Redis Development Conventions

Standardizes Redis implementation with expert guidance on data structures, hierarchical key naming, and memory-efficient TTL strategies.

AgentDB Performance Optimization

Optimizes AgentDB vector databases using quantization, HNSW indexing, and caching to achieve massive performance gains and memory efficiency.

AgentDB Advanced Features

Powers distributed AI systems with high-performance vector search, QUIC synchronization, and multi-database management.

Database Migration & Schema Evolution

Automates complex database schema changes and data migrations across multiple ORMs with a focus on zero-downtime strategies.

PostgreSQL Table Design

Architects production-grade PostgreSQL schemas utilizing optimized data types, advanced indexing, and performance-first design patterns.

Boardkit File Format

Manages the .boardkit file structure, document serialization, and versioning for board-based applications.

Drizzle Database Operations

Manages Drizzle ORM database schemas, migrations, and seeding tasks for PostgreSQL environments.

Supabase Expert

Architects and implements production-grade Supabase solutions including advanced PostgreSQL RLS, Auth flows, and Edge Functions.

EF Core & ABP Patterns

Optimizes Entity Framework Core implementation for ABP Framework applications using PostgreSQL.

TypeScript Type Safety & Drizzle Architect

Eliminates unsafe TypeScript assertions and fixes Drizzle ORM relation type inference issues.

Supabase RLS Security Setup

Configures comprehensive Row Level Security policies for Supabase tables to ensure robust database-level access control.

C# Database Integration Patterns

Provides standardized RDBMS access patterns and best practices for C# applications across multiple database engines including PostgreSQL, MySQL, and DuckDB.

C# Database Access Patterns

Provides standardized RDBMS access patterns and type-safe mapping for DuckDB, PostgreSQL, MySQL, SQL Server, and DBISAM in C#.

RDBMS Access Patterns

Standardizes C# database integration across DuckDB, PostgreSQL, MySQL, and legacy ODBC systems using optimized implementation patterns.

Rails Debugging Expert

Systematically diagnoses and resolves Ruby on Rails application errors, from database bottlenecks to asset pipeline failures.