Database Management Agent Skills

ClickHouse Analytics Patterns

Optimizes ClickHouse database schemas, query performance, and data engineering workflows for high-performance analytical workloads.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database schemas and analytical queries for high-performance OLAP workloads.

JPA & Hibernate Patterns

Implements optimized JPA and Hibernate patterns for high-performance Spring Boot data persistence and entity management.

JPA & Hibernate Patterns

Provides standardized patterns for JPA and Hibernate entity design, relationship mapping, and performance optimization in Spring Boot applications.

PostgreSQL Patterns & Optimization

Optimizes PostgreSQL database schemas, queries, and security using Supabase-inspired best practices and efficient indexing strategies.

ClickHouse Analytics & Optimization

Implements high-performance ClickHouse database patterns, query optimizations, and data engineering best practices for large-scale analytical workloads.

Database Migrations

Implements safe, zero-downtime database schema changes and data migrations across multiple SQL engines and ORMs.

PostgreSQL Design Patterns

Optimizes PostgreSQL databases through expert schema design, indexing strategies, and performance patterns based on Supabase best practices.

AgentDB Advanced Features

Implements high-performance vector search, distributed QUIC synchronization, and multi-database management for advanced AI systems.

Event Stream Projection Patterns

Builds high-performance read models and materialized views from event streams for event-sourced systems.

Ecto Architecture & DDD Thinking

Guides Elixir developers through Ecto data layer design, domain-driven architecture, and database performance optimizations.

SQL Optimization Patterns

Optimizes database performance by identifying and fixing slow SQL queries through systematic indexing, query plan analysis, and efficient execution patterns.

Database Designer

Architects, optimizes, and migrates complex database schemas using expert-level analysis and performance-driven best practices.

Database Schema & Migration Implementation

Architects robust database schemas and manages SQL migrations using Flyway and Exposed ORM.

Migration Architect

Architects and validates zero-downtime system migrations with comprehensive rollback strategies and compatibility analysis.

Database Designer

Architects and optimizes high-performance database schemas with expert-level normalization, indexing, and migration strategies.

Senior Data Engineer

Builds and optimizes scalable data pipelines, ETL/ELT systems, and robust data infrastructure.

Database Implementation & Migrations

Manages database schema design, Flyway migrations, and query optimization using Exposed ORM and SQL.

Backend Queries

Constructs optimized and secure database queries using parameterized statements, eager loading, and efficient indexing strategies.

Database Archival System

Automates historical data migration from primary databases to cost-effective cold storage or archive tables while maintaining compliance.

Senior Data Engineer

Architects and builds production-grade data pipelines, ETL/ELT systems, and scalable data infrastructure using modern tech stacks.

Database Data Seeder

Generates realistic test data and database seed scripts to populate development and testing environments while maintaining relational integrity.

Database Schema Designer

Architects robust relational database schemas complete with migrations, type-safe models, and advanced security policies.

Database Optimizer

Optimizes database performance through advanced query tuning, strategic indexing, and scalable architecture design for modern data stacks.

Data Cleanup & Migration

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

Database Sharding Manager

Implements horizontal database sharding strategies to scale applications beyond single-server performance and storage limitations.

Database Replication Manager

Automates the configuration and management of database replication, failover, and high availability for PostgreSQL and MySQL.

Database Schema Designer

Architects relational database schemas and generates migrations, TypeScript/Python types, and RLS policies for robust backend development.

SAP SQLScript Development

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

T-SQL Pro & Database Optimization

Writes high-performance, secure T-SQL code and optimizes SQL Server database schemas using industry best practices.