Database Management Agent Skills

Firebase Next.js Integration Strategies

Implements robust Firebase integration patterns for Next.js 14+ App Router environments using dual SDK architectures.

Firestore Data Modeling Patterns

Provides expert guidance on structuring Firestore NoSQL databases for optimal performance, scalability, and cost-efficiency.

Database Schema Evaluator

Performs comprehensive multi-perspective audits of database architectures to optimize performance, integrity, and long-term scalability.

Firebase Next.js Integration Strategies

Streamlines Next.js 14+ App Router integration with Firebase using optimized dual-SDK architecture and server-side data fetching patterns.

Firestore Data Modeling Patterns

Optimizes NoSQL database structures using Firestore best practices for subcollections, data denormalization, and atomic operations.

Database Schema Evaluator

Analyzes database schemas using a multi-perspective expert panel to identify performance bottlenecks, normalization issues, and maintenance risks.

Firestore Security Rules Generator

Generates secure, production-ready Firestore security rules for user-scoped access and role-based control.

InsForge Database Schema Patterns

Provides optimized PostgreSQL schema templates and Row Level Security (RLS) policies for InsForge and PostgREST backends.

Oxy Semantic Layer Builder

Builds and maintains structured Oxy semantic layer files to enable natural language data querying from database schemas.

ETL Pipeline Builder

Builds and extends robust, maintainable ETL pipelines using DLT for API connectors and spreadsheet ingestion.

Database Backup Automator

Automates database backup scheduling, encryption, and recovery procedures across multiple SQL and NoSQL engines.

SQL Optimization Patterns

Optimizes database performance through systematic query analysis, advanced indexing strategies, and efficient execution patterns.

DataFusion & DeltaLake Integration

Provides comprehensive operational guidance for integrating Apache DataFusion with DeltaLake for high-performance data processing and query optimization.

Convex Component Authoring

Develops and packages self-contained, reusable Convex backend components with isolated database tables and type-safe exports.

Database Recovery Manager

Automates database disaster recovery, point-in-time recovery, and failover strategies to ensure high availability and data resilience.

Convex Component Authoring

Builds and publishes reusable, self-contained Convex backend components with isolated database tables and functions.

Database Documentation Generator

Generates comprehensive database documentation, ERD diagrams, and data dictionaries directly from existing schemas.

Python Data Engineering

Builds production-grade data pipelines and dimensional models using SQLAlchemy 2.0 and modern warehouse architectures.

Data Validation Engine

Automates the implementation of database integrity constraints, data type validation, and business rules across multiple database environments.

SQL Optimization Patterns

Optimizes SQL queries and database performance through indexing strategies, EXPLAIN plan analysis, and efficient query patterns.

Database Sharding Manager

Designs and implements horizontal database sharding strategies to scale data architecture across multiple server instances.

Database Migration Manager

Manages database schema evolution through automated, version-controlled migrations for SQL and NoSQL databases.

Metadata Manager

Streamlines the creation and management of BigQuery table schemas, metadata configurations, and Airflow DAG schedules following Mozilla ETL conventions.

SQL Optimization Patterns

Optimizes SQL query performance through systematic execution plan analysis, advanced indexing strategies, and proven query restructuring patterns.

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.

Data SQL Optimization & Modeling

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

Data Cleanup & Migration

Automates data enrichment, cleanup, and migration pipelines with built-in validation for Supabase databases.

SAP SQLScript Development

Streamlines SAP HANA database programming with expert guidance on SQLScript procedures, functions, and performance optimization.