Database Management Agent Skills

Grey Haven Multi-Tenant Data Modeling

Standardize and automate multi-tenant database schema design using SQLModel and Drizzle ORM.

Firebase Firestore Specialist

Architects production-ready Firebase Firestore implementations with expert-level NoSQL modeling, real-time synchronization, and robust security rules.

Data Validation & Schema Quality

Implements robust data validation and schema alignment using Pydantic v2 for PlanetScale and API services.

Database Design & Schema Standards

Enforces standardized database conventions, multi-tenant isolation, and schema best practices for Drizzle ORM and SQLModel.

PostgreSQL Code Review

Reviews PostgreSQL code for optimal indexing, JSONB performance, connection pooling, and transaction safety.

SQLAlchemy Code Review

Reviews SQLAlchemy code to optimize session management, eliminate N+1 queries, and ensure database migration safety.

SQLite Vector Search (sqlite-vec)

Implements high-performance vector similarity search and embedding storage directly within SQLite databases.

dbt Fusion Migration

Migrates dbt Core projects to the dbt Fusion engine by resolving compatibility errors, deprecations, and unsupported configurations.

dbt Semantic Layer Architect

Simplifies the creation and management of dbt Semantic Layer components including semantic models, metrics, and dimensions.

Kafka CLI Tools & Operations

Manages Apache Kafka clusters and data streams using modern CLI tools like kcat, kaf, and kafkactl.

Kafka MCP Integration

Simplifies the integration and configuration of Model Context Protocol (MCP) servers for managing Kafka operations directly within AI coding environments.

Confluent ksqlDB Stream Processing

Master real-time event streaming and data processing using ksqlDB's SQL-like syntax on Kafka topics.

Confluent Kafka Connect

Configures and optimizes Kafka Connect pipelines for seamless data movement between databases, cloud storage, and search indexes.

Database Administrator

Manages database operations, performance tuning, and high availability configurations across multiple DBMS platforms through a structured workflow.

dbt Analytics Engineering

Streamlines data transformation and analytics engineering workflows by applying software engineering best practices to dbt projects.

ETL & ELT Design Patterns

Provides architectural guidance and implementation patterns for designing modern data pipelines and transformation workflows.

ClickHouse Query Optimizer

Optimizes ClickHouse SQL queries for maximum performance, reduced memory usage, and efficient index utilization.

ClickHouse Materialized Views

Implements high-performance ClickHouse Materialized Views for real-time data aggregation, ETL pipelines, and query optimization using proven architectural patterns.

ClickHouse Schema Design Optimizer

Optimizes ClickHouse table structures using performance-driven schema rules for sub-second queries and superior data compression.

Event Sourcing Patterns for HZL

Enforces event-driven architecture and immutable state patterns within the HZL task ledger system.

Data Modeling & Database Design

Designs and documents robust data structures using Entity-Relationship Diagrams, data dictionaries, and multi-level schema models.

Data Architecture & Modern Platforms

Designs modern data platforms and implements scalable data architecture patterns like data lakes, lakehouses, and data mesh.

Data Modeling & Schema Design

Designs optimized database schemas and guides architectural decisions for operational and analytical systems.

Vector Database Systems Design

Architects high-performance vector search systems by providing guidance on database selection, ANN algorithms, and scaling strategies.

Event Sourcing Design

Architects and implements robust event-sourced systems using standardized patterns for event stores, aggregates, and projections.

SurrealDB Query Assistant

Generates production-ready SurrealQL queries and schemas for multi-model database applications including document, graph, and relational patterns.

Performance Doctor

Diagnoses and optimizes backend performance issues including SQL bottlenecks, caching strategies, and N+1 query problems.

Multi-Tenant Architecture Guide

Guides the design and implementation of multi-tenant SaaS architectures using field, schema, and physical isolation patterns.

SAP ABAP CDS Development

Streamlines SAP ABAP Core Data Services development by providing expert guidance on data modeling, view entities, and semantic annotations.

SAP Datasphere Development

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