Database Management Agent Skills

PostgreSQL Streaming Replication Manager

Automates the configuration, monitoring, and failover management of PostgreSQL streaming replication clusters.

PostgreSQL PL/pgSQL Development

Develops robust PostgreSQL procedural logic including functions, triggers, and procedures with production-ready patterns.

Conversation State Management

Implements robust, database-persisted conversation tracking for stateless AI agents using PostgreSQL.

Redis Lists & Sets Master

Implements high-performance Redis data structures including reliable queues, unique collections, and complex set operations for distributed applications.

Postgres Best Practices

Optimizes PostgreSQL performance, schema design, and security using Supabase-vetted standards and implementation patterns.

PostgreSQL Best Practices for Supabase

Optimizes PostgreSQL performance and schema design using Supabase-maintained best practices and prioritized optimization rules.

Postgres Performance & Best Practices

Optimizes PostgreSQL database performance and schema design using Supabase-vetted best practices and implementation patterns.

Redis Transaction Pro

Implements production-grade Redis transaction patterns using MULTI/EXEC, optimistic locking with WATCH, and atomic Lua scripting.

Supabase Implementation Expert

Provides production-grade Supabase implementation, security auditing, and performance optimization for modern web applications.

Logseq DB Migration Expert

Guides the transition of Logseq knowledge bases from Markdown files to the advanced SQLite database architecture.

Migration Helper

Facilitates safe database and code migrations using zero-downtime strategies and proven implementation patterns.

RLS Security Patterns

Implements robust Row-Level Security (RLS) policies for multi-tenant and user-scoped database architectures.

Database Function Lint Manager

Lints PostgreSQL functions, analyzes codebase usage, and generates actionable maintenance reports to ensure database integrity.

Supabase Migrations

Manages Supabase database schema changes, table creation, and Row Level Security policies using the Supabase CLI.

Lutece 8 DAO & Home Patterns

Implements standardized DAO and Home layer patterns for Lutece 8 development using best practices for data persistence.

Redis Cluster Manager

Manages production-grade Redis Cluster operations including horizontal scaling, hash slot distribution, and automated failover procedures.

Database Architect & Optimizer

Designs, optimizes, and manages SQL and NoSQL databases using industry-standard best practices for performance and scalability.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through advanced quantization, HNSW indexing, and efficient batch operations.

Redis Hashes and Sorted Sets

Optimizes Redis data management with advanced patterns for Hashes and Sorted Sets, including leaderboards, object storage, and ranking systems.

PostgreSQL Database Setup

Standardizes PostgreSQL database initialization with automated schema generation, setup scripts, and high-performance connection drivers.

Rails Delegated Types Pattern

Implements a unified container model for complex Ruby on Rails content systems with 5 or more distinct types.

Vanilla Rails Models

Enforces production-grade Rails model patterns including state-as-records, namespaced concerns, and invocation-based method ordering.

Vanilla Rails Data Modeling

Enforces high-performance, multi-tenant database schema patterns and migrations for Ruby on Rails applications based on 37signals conventions.

PostgreSQL Expert

Optimizes PostgreSQL performance, designs scalable architectures, and troubleshoots complex database internals with production-grade precision.

SQL Query Optimizer

Analyzes and optimizes SQL queries to improve performance by identifying bottlenecks and suggesting efficient indexing strategies.

Supabase RLS Policy Expert

Generates production-ready, optimized PostgreSQL row-level security (RLS) policies for Supabase databases following security best practices.

PostgreSQL Table Design

Designs high-performance, production-ready PostgreSQL schemas following industry best practices and modern database patterns.

Notion Database Repair Expert

Diagnoses and fixes corrupted Notion databases by repairing schemas, cleaning orphan properties, and resolving API validation errors.

ActiveRecord Patterns & Optimization

Optimizes database interactions by providing enterprise-grade ActiveRecord query patterns, association designs, and PostgreSQL-specific performance strategies.

Database Schema

Enforces strict database schema conventions for Drizzle ORM and PostgreSQL to ensure consistent table structures, constraints, and indexing patterns.