Database Management Agent Skills

Database Seed Data Generator

Generates realistic test data and database seed scripts to populate development and testing environments efficiently.

Mermaid ER Diagram Creator

Generates and validates Mermaid.js entity-relationship diagrams to visualize database schemas and data structures.

Supabase Data Compliance & PII Handling

Implements robust PII detection, data retention policies, and GDPR/CCPA compliance patterns within Supabase environments.

Memcached Configuration Helper

Optimizes and automates the configuration of Memcached instances for high-performance backend caching.

Data Partitioner

Optimizes data pipeline performance by automating the creation and management of efficient data partitioning strategies.

Database Schema Designer

Architects and optimizes production-grade database schemas for SQL and NoSQL environments.

Database Schema Visualizer

Generates professional database ER diagrams and visual documentation to simplify the understanding of complex data structures.

Prisma Schema Helper

Simplifies database modeling and schema management using the Prisma ORM for backend applications.

Database Backup Automator

Automates database backup workflows with scheduling, encryption, and multi-database support for robust disaster recovery.

Schema Optimization Orchestrator

Automates multi-phase database schema optimization workflows through structured validation and comprehensive reporting.

BigQuery Table Creator

Automates the creation and configuration of Google BigQuery tables using gcloud commands and schema best practices.

Database Schema Diff & Sync

Compares and synchronizes database schemas across environments using automated diffing tools for SQL and NoSQL systems.

Database Archival System

Automates the migration of historical database records to archive tables or cloud cold storage to optimize database performance.

Database Index Advisor

Optimizes database performance by designing and implementing efficient indexing strategies across SQL and NoSQL systems.

Supabase Rate Limit Manager

Manages Supabase API rate limits, backoff strategies, and idempotency patterns to ensure reliable database interactions.

Complex Join Helper

Simplifies the construction and optimization of intricate SQL joins for advanced data analytics and business intelligence workflows.

Incremental Load Setup

Configures and optimizes incremental data loading patterns for efficient ETL pipelines and data synchronization.

Supabase Architecture Blueprint

Implements validated Supabase architecture blueprints ranging from monoliths to microservices based on project scale.

Supabase Error Troubleshooter

Diagnoses and resolves common Supabase errors, exceptions, and integration issues using automated log analysis and documented fixes.

Redis Cache Manager

Optimizes backend performance by automating Redis caching implementations and data management strategies.

Supabase Migration Deep Dive

Facilitates complex database migrations and architectural shifts to or from Supabase using the proven Strangler Fig pattern.

Supabase Enterprise RBAC

Configures enterprise-grade security controls, including SSO integration and role-based access management for Supabase applications.

Juicebox Data Migration Pro

Orchestrates complex data migrations from legacy recruiting platforms into Juicebox using advanced transformation pipelines and rate-limited bulk imports.

Elasticsearch Index Manager

Automates the lifecycle management, configuration, and optimization of Elasticsearch indices for production environments.

Supabase Policy Guardrails

Enforces best practices and security policies for Supabase integrations through automated linting and CI/CD guardrails.

Schema Validator

Validates and manages data schemas within ETL and data pipeline workflows to ensure structural integrity and reliability.

CTE Query Builder

Constructs modular and maintainable SQL queries using Common Table Expressions to simplify complex data analytics tasks.

Sequelize Model Creator

Automates the generation and configuration of production-ready Sequelize models for Node.js backend applications.

Firestore Index Creator

Automates the creation and management of Google Cloud Firestore indexes using industry-standard patterns and best practices.

Database Replication & Sharding Manager

Automates database scaling, replication, and sharding across PostgreSQL, MySQL, and MongoDB environments.