Database Management Agent Skills

Database Design & Architecture

Architects scalable, performant database schemas and selects optimal data persistence tools based on specific project requirements.

NoSQL Design Expert

Architects high-scale distributed database systems using query-first modeling and single-table design patterns for Cassandra and DynamoDB.

NoSQL Expert & Distributed Systems Architect

Provides expert guidance and architectural patterns for high-scale distributed NoSQL databases like Cassandra and DynamoDB.

Alembic Migration Manager

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

Neon Postgres Patterns

Implements expert patterns for Neon serverless Postgres, including database branching, connection pooling, and ORM integrations.

Neon Postgres

Implements expert patterns for Neon serverless Postgres, including database branching, connection pooling, and Prisma or Drizzle ORM integrations.

Database Connection Pooling

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

Prisma ORM Expert

Streamlines database development by providing expert guidance on Prisma schema design, migration management, and query performance optimization.

Prisma ORM Expert

Streamlines database workflows by optimizing Prisma schema design, resolving migration conflicts, and implementing high-performance query patterns.

Supabase Database Integration

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

dbt Model Builder

Constructs standardized dbt models following Kimball dimensional patterns and modern testing configurations.

PostgreSQL Syntax & Grammar Reference

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

Neon Serverless Postgres

Facilitates professional-grade database management using Neon serverless Postgres with optimal connection patterns for Prisma and Drizzle ORMs.

ClickHouse Analytics Patterns

Implements high-performance ClickHouse database schemas, optimized analytical queries, and efficient data engineering patterns for OLAP workloads.

Postgres Best Practices

Optimizes PostgreSQL performance and schema design using Supabase-vetted patterns and best practices.

Supabase Postgres Best Practices

Optimizes PostgreSQL performance and schema design using Supabase-verified best practices and implementation patterns.

Postgres Performance & Best Practices

Optimizes PostgreSQL database performance and schema design using expert-refined guidelines and industry best practices.

ClickHouse Database & Analytics Patterns

Optimizes ClickHouse database performance with expert patterns for schema design, high-speed analytical queries, and efficient data engineering workflows.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance through high-performance schema design, query optimization, and advanced analytical patterns.

Event Store Design

Design and implement robust event stores for event-sourced systems using industry-standard persistence patterns.

Database Migration Specialist

Executes complex database schema changes, data transformations, and zero-downtime deployment strategies across multiple ORMs.

PostgreSQL Table Design

Architects high-performance PostgreSQL schemas using industry best practices for data types, indexing, and normalization.

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.

BigQuery Script Writer for Windmill

Streamlines the creation, parameterization, and deployment of Google BigQuery SQL scripts for the Windmill orchestration platform.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database performance with specialized patterns for high-speed analytical queries and data engineering.

dbt Transformation Patterns

Implements production-ready dbt patterns for scalable analytics engineering, model layering, and automated testing.

ClickHouse Analytics & Data Engineering

Implements high-performance ClickHouse database patterns, query optimizations, and efficient data engineering workflows for analytical workloads.

ClickHouse Analytics & Data Patterns

Provides optimized ClickHouse database patterns, high-performance query strategies, and data engineering best practices for large-scale analytical workloads.

Backend Queries

Implements structured database queries and repository patterns using Prisma ORM to maintain a robust layered architecture.