Database Management Agent Skills

Database Sharding Manager

Automates the design, implementation, and management of horizontal database sharding strategies across SQL and NoSQL environments.

Supabase Local Development Loop

Configures a high-velocity local development environment for Supabase with integrated hot reloading and automated testing.

Supabase Error Resolver

Diagnoses and resolves common Supabase errors and integration exceptions within your application environment.

Database Schema Comparison & Sync

Automates the process of comparing and synchronizing SQL and NoSQL database schemas with comprehensive safety checks and deployment workflows.

Database Replication Manager

Automates the configuration and management of database replication and sharding to ensure high availability and scalability.

Supabase Migration Deep Dive

Executes complex Supabase re-architectures and migrations using the Strangler Fig pattern to ensure zero-downtime transitions.

Database Seed Data Generator

Generates realistic, relational test data and database seed scripts using Faker libraries to streamline development and testing workflows.

Database Index Advisor

Optimizes database performance by designing, implementing, and validating efficient indexing strategies for SQL and NoSQL systems.

Database Archival System

Automates the process of moving historical database records to cold storage or archive tables to optimize performance and reduce storage costs.

Database Backup Automator

Automates database backup processes with scheduling, compression, and encryption for production-ready disaster recovery.

Supabase Database

Streamlines Supabase database management through optimized CRUD operations, Row Level Security (RLS) implementation, and PostgreSQL function support.

SQL Query Optimizer

Analyzes and improves database query performance through automated assessment, implementation, and monitoring of SQL execution plans.

Supabase Data Privacy & Compliance

Enforces GDPR/CCPA compliance patterns and automated PII detection for Supabase-backed applications.

ORM Code & Database Model Generator

Automates the generation of ORM models, entity classes, and database schemas with comprehensive validation and documentation.

Database Migration Manager

Manages and automates database schema migrations with comprehensive version control and safety validation.

Supabase Architecture Blueprint Designer

Architects and implements optimized Supabase project structures based on scale and growth requirements.

Supabase SDK Design Patterns

Implements production-ready, type-safe Supabase SDK patterns for TypeScript and Python applications.

Postgres Hypothetical Index Helper

Generates Ruby and ActiveRecord commands to create and test PostgreSQL hypothetical indexes using the HypoPG extension.

NoSQL Data Modeler

Automates the design, optimization, and implementation of NoSQL database schemas and document structures for scalable applications.

Database Schema Conflict Resolver

Resolves database schema version conflicts by automatically selecting the most recent migration timestamp.

Supabase Next.js Integration

Streamlines the integration of Supabase backend services into React and Next.js applications using modern App Router patterns and SSR.

ClickHouse Analytics & Data Patterns

Optimizes ClickHouse database performance with expert patterns for schema design, high-volume data ingestion, and complex analytical queries.

Optimizing Performance

Identifies and resolves performance bottlenecks across databases, application logic, and infrastructure using proven optimization patterns.

PostgreSQL Table Design

Architects production-grade PostgreSQL schemas using expert-level best practices for data integrity, performance, and scalability.

JUDO RDBMS Query Debugger

Troubleshoots and traces JUDO DAO SQL generation to resolve performance bottlenecks and query inaccuracies.

JUDO RDBMS Dialect Extension

Extends the JUDO DAO framework to support new database dialects like MySQL, Oracle, and custom RDBMS systems.

JUDO Query Optimization

Optimizes JUDO query performance by analyzing join strategies, caching mechanisms, and expression evaluation patterns.

JUDO Expression Syntax

Facilitates the implementation and debugging of JUDO expression metamodels and transfer object bindings.

JUDO DAO Core Patterns

Guides the implementation of standardized data access patterns, payload processing, and entity lifecycle management within the JUDO framework.

JUDO Query Translation

Translates logical JUDO expressions and models into structured SQL queries for efficient data retrieval.