Database Management Agent Skills

Database Deadlock Detector

Detects, analyzes, and prevents database deadlocks by monitoring transaction patterns and lock contention in real-time.

Rails Performance Optimization

Optimizes Ruby on Rails applications by identifying and resolving N+1 queries, implementing efficient caching, and managing background processing.

Rails Active Record Patterns

Optimizes Ruby on Rails data models using industry-standard ActiveRecord patterns for associations, validations, and high-performance queries.

SQLDelight KMP Database Integration

Generates type-safe Kotlin APIs from SQL schemas for robust cross-platform data persistence in Kotlin Multiplatform projects.

Database Deadlock Detector

Detects, analyzes, and resolves database deadlocks by monitoring transaction patterns and lock contention in real-time.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers for PostgreSQL, MySQL, and SQL Server to optimize database logic.

SQL Query Optimizer

Analyzes and optimizes SQL queries to enhance database performance through index recommendations and structural rewrites.

Database Connection Pooler

Optimizes database connection pooling and lifecycle management to enhance application performance and resource efficiency.

Database Connection Optimizer

Enhances application performance by configuring and optimizing database connection pools across various programming languages.

Database Audit Logger

Implements comprehensive database audit logging to track data changes, maintain compliance, and enhance system observability.

Database Schema Designer

Designs, normalizes, and visualizes robust relational database schemas using industry best practices and Mermaid ERD diagrams.

Warehouse Optimization

Optimizes data warehouse performance through efficient partitioning, query tuning, and cost-effective resource management.

SQL Optimization Patterns

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

PostgreSQL Table Design

Architects high-performance, production-ready PostgreSQL schemas using modern best practices and advanced indexing patterns.

Supabase RLS Policy Setup

Configures production-ready Row Level Security policies for Supabase tables to ensure secure, role-based data access.

Atomic Transaction Manager for Supabase

Implements secure, atomic PostgreSQL transactions in Supabase using PL/pgSQL RPC functions to ensure data consistency.

Firestore Platform Specialist

Architects and optimizes Firebase Firestore implementations with advanced NoSQL patterns, real-time synchronization, and robust security rules.

AgentDB Advanced Features

Implement high-performance distributed vector databases with sub-millisecond synchronization, hybrid search, and advanced distance metrics.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance using quantization, HNSW indexing, and advanced caching strategies to reduce memory footprint and accelerate search speeds.

Database Schema Designer

Designs robust, production-ready SQL and NoSQL database schemas with built-in best practices for normalization, indexing, and scalability.

SQL Development

Writes, reviews, and optimizes performant SQL queries while applying PostgreSQL-specific best practices for schema design and performance tuning.

Backend Migrations

Manages database schema changes through reversible, version-controlled migration files while ensuring zero-downtime deployment compatibility.

Aurora Tools Database Manager

Manages PostgreSQL migrations, stored procedures, and triggers using standardized Aurora framework patterns.

Serverless Postgres for Edge

Configures and manages serverless Postgres databases for edge environments like Cloudflare Workers and Vercel.

RavenDB ASP.NET Identity Store

Implements custom ASP.NET Identity user and refresh token stores backed by RavenDB for secure authentication.

Kratos Repository Implementation

Generates Clean Architecture repository implementations for Go-Kratos microservices using GORM for robust data persistence.

Firebase Firestore Integration

Builds and manages scalable NoSQL databases with Firestore, featuring real-time synchronization, offline support, and robust security rules.

Data Structure Selection Framework

Guides the selection of optimal data structures through a systematic analysis of performance requirements, operation frequencies, and memory constraints.

Cloudflare KV Storage

Manages high-performance, globally distributed key-value data on Cloudflare's edge network for serverless applications.

Vercel KV Integration

Integrates Redis-compatible Vercel KV for high-performance caching, session management, and rate limiting in Next.js applications.