Database Management Agent Skills

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.

Honeydew Attribute Creation

Defines and manages calculated dimensions and virtual columns in Honeydew semantic models using SQL and YAML.

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.

ETL Pipeline Specialist

Builds and optimizes robust data pipelines with a focus on data quality, error handling, and operational reliability.

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.

SQL Development

Generates, optimizes, and manages production-grade SQL queries and database schemas with a focus on performance and readability.

Database Backup Automator

Automates secure database backups and restoration procedures for PostgreSQL, MySQL, MongoDB, and SQLite.

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.

Semantic Data Validation

Validates Honeydew semantic objects to ensure data integrity, logical consistency, and correct execution of metrics and entities.

FairDB Backup Manager

Manages automated PostgreSQL backups and point-in-time restorations for FairDB databases using pgBackRest and Wasabi S3 storage.

ORM Code Generator

Generates production-ready ORM models and database schemas across multiple frameworks and languages from natural language descriptions.

Database Migration Manager

Automates the creation, application, and rollback of version-controlled database migrations across SQL and NoSQL environments.

JPA & Hibernate Patterns

Standardizes database entity design and query optimization using proven JPA and Hibernate best practices.

SAP Datasphere Development

Streamlines SAP Datasphere development by providing expert guidance on data modeling, integration flows, and cloud-native warehouse administration.

EF Core Async Patterns

Optimizes Entity Framework Core performance by implementing asynchronous best practices and efficient query patterns.

Data SQL Optimization & Modeling

Optimizes SQL queries and database schemas using industry-standard patterns for performance, maintainability, and scalability.

TimescaleDB Hypertable Setup

Guides the design and implementation of optimized TimescaleDB hypertables, compression policies, and continuous aggregates for high-performance time-series data.

Database Migration & Schema Management

Executes seamless database schema and data migrations across multiple ORMs with robust rollback and zero-downtime strategies.

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.

PowerSync Local-First Development

Builds offline-capable, local-first TypeScript applications by synchronizing SQLite with backend databases like Postgres and MongoDB.

Database Audit Logging

Automates the implementation of database audit trails and change tracking to ensure data integrity and regulatory compliance.

Database Archival & Retention

Automates the archival of historical database records to cold storage or archive tables to optimize performance and ensure regulatory compliance.