Database Management Agent Skills

Model Requirements Gatherer

Guides the structured gathering of requirements for new and existing BigQuery data models to ensure robust ETL pipeline planning.

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.

Backend Migrations

Manages database schema changes and data migrations using industry best practices to ensure data integrity and zero-downtime deployments.

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 Operations

Implements high-performance, production-ready database architectures using async patterns and modern ORM best practices.

Convex Component Authoring

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

Objectstar Legacy Migration

Analyzes, refactors, and migrates TIBCO Objectstar legacy mainframe applications to modern architectures and programming languages.

PostgreSQL Table Design

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

MongoDB Aggregation Pipeline Builder

Optimizes and generates complex MongoDB aggregation pipelines for sophisticated data transformation and analysis.

Splunk KV Store Manager

Manages Splunk App Key Value Store collections and records for persistent metadata and application state storage.

Python Data Engineering

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

Query Performance Analysis

Analyzes database query performance, detects N+1 issues, identifies missing indexes, and guides safe index migrations.

Metadata Manager

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

DBF Data Analysis

Analyzes and converts legacy Thai accounting DBF databases into efficient Parquet format for high-performance SQL querying with DuckDB.

Database Schema Design

Designs robust, scalable relational database schemas through structured workflows, entity-relationship modeling, and SQL generation.

Alembic Migration Manager

Manages database schema and data migrations using Alembic through standardized workflows and production-ready best practices.

Database Connection Pooling

Optimizes database performance and reliability by configuring robust connection pools for SQLAlchemy across traditional and serverless architectures.

Supabase Database Integration

Query and interact with Supabase databases using real-time subscriptions and PostgreSQL-compatible syntax while respecting Row Level Security policies.

PostgreSQL Syntax & Grammar Reference

Consults PostgreSQL's internal parser and grammar rules to provide precise guidance on SQL syntax and DDL structure.

Event-Sourced Projection Patterns

Builds efficient read models and materialized views from event streams to optimize query performance in event-sourced systems.

Event Store Design Patterns

Designs and implements robust event storage solutions for event-sourced architectures and high-performance distributed systems.

SQL Optimization Patterns

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

Persistence Layer Auditor

Audits and optimizes SQLite persistence layers by identifying unused tables, broken method calls, and schema inconsistencies.

East Node I/O

Provides a comprehensive suite of I/O functions for the East programming language, enabling seamless integration with databases, cloud storage, and file formats.

Writing Queries

Guides the systematic development, verification, and documentation of SQL queries for analytical data processing.

Data Cleanup & Migration

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

PostgreSQL Guide

Retrieves real-time, official PostgreSQL documentation for accurate SQL syntax, database configuration, and performance optimization.