Database Management Agent Skills

Database Migration Master

Manages complex database schema migrations and data transformations across multiple ORMs with robust rollback and zero-downtime strategies.

PostgreSQL Table Design Specialist

Designs optimized PostgreSQL database schemas using performance-first patterns and industry best practices.

Database Performance & Optimization

Optimizes database schemas, queries, and caching strategies to improve application speed and resource efficiency.

SQL Optimization Patterns

Optimizes SQL queries and database performance through advanced indexing strategies and execution plan analysis.

Database Query Optimizer

Optimizes database performance by implementing EXPLAIN analysis, strategic indexing, and N+1 query prevention patterns.

Redis AI Cache Patterns

Implements cost-efficient embedding and vector caching strategies using Redis to optimize AI application performance and expenses.

Redis Connection Management

Optimizes Redis reliability and performance through standardized connection pooling, client configuration, and resilient reconnection strategies.

Celery Result Backend Patterns

Configures and optimizes Celery result backends for reliable task storage, retrieval, and persistence.

Supabase Clerk Sync

Synchronizes Clerk authentication with Supabase databases using JWT validation, RLS policies, and secure webhook patterns.

Supabase Subscription Schemas

Generates secure, production-grade Supabase database schemas and Row Level Security policies for managing SaaS subscriptions and payment workflows.

Redis Session Management

Implements secure, scalable Redis-based session store configurations across multiple web frameworks.

Redis Cache Strategies

Implements advanced Redis caching patterns and TTL management policies to optimize application performance and data consistency.

AI Database Schema Patterns for Supabase

Generates and manages production-ready PostgreSQL schemas for AI applications, including RAG storage, chat systems, and multi-tenant architectures.

Supabase Integration Expert

Architects secure and scalable Supabase backends using optimized database schemas, RLS policies, and serverless Edge Functions.

CRM Context Retrieval

Retrieves scoped CRM data and context from PostgreSQL to provide AI agents with precise business intelligence.

MongoDB Atlas Specialist

Manages MongoDB Atlas clusters, designs schemas, and optimizes complex aggregation pipelines for high-performance applications.

dbt Development

Enforces standardized dbt coding conventions and validates model structures across staging, integration, and warehouse layers.

pgdbm Core API Reference

Provides comprehensive technical documentation for implementing pgdbm database operations and managing PostgreSQL configurations.

MongoDB CRUD Operations

Master document-based data operations with standardized NoSQL patterns for insertion, querying, updating, and deletion.

Supabase Row Level Security

Streamlines the creation, implementation, and testing of Supabase Row Level Security policies to ensure robust data isolation.

Bazinga DB Orchestration State Manager

Manages persistent state and logs for the BAZINGA orchestration system using a concurrent-safe SQLite database.

SikhAid Data & State Management

Manages data flow, Svelte reactive stores, and Firebase Firestore operations for the SikhAid NGO application.

Database Administrator

Manages database operations, performance tuning, and high availability configurations through expert guidance and structured analysis.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through quantization, HNSW indexing, and advanced caching strategies.

NovaTune Entity Field Manager

Streamlines the addition of new properties to C# entities within the NovaTune API, ensuring consistency across services, endpoints, and RavenDB indexes.

Rails Debugging Expert

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

RDBMS Access Patterns

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

C# Database Access Patterns

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

C# Database Integration Patterns

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

TypeScript Type Safety & Drizzle Architect

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