Database Management Agent Skills

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.

pg_dump Reference

Consults the official PostgreSQL pg_dump implementation to provide canonical guidance on system catalog queries and schema extraction.

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.

Convex Real-time Development

Implements reactive data synchronization and live updates using Convex's automatic query subscriptions.

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.

PostgreSQL Syntax Reference

Consults PostgreSQL's internal parser and grammar rules to ensure precise SQL syntax implementation and DDL generation.

Convex Component Authoring

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

Python Data Engineering

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

PostgreSQL Table Designer

Architects high-performance, production-grade PostgreSQL schemas using modern best practices and idiomatic data patterns.

PostgreSQL Migration & Schema Expert

Provides comprehensive guidance and implementation patterns for robust, idempotent PostgreSQL database migrations and schema design.

Convex Real-Time Sync

Implements reactive queries and real-time data synchronization using the Convex platform to create live-updating user interfaces.

Backend Migration Standards

Enforces safe, reversible, and zero-downtime database schema evolutions following industry best practices.

CloudBase Web SDK Database Guide

Streamlines implementation of the CloudBase document database Web SDK for advanced data management and querying.