Database Management Agent Skills

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.

PostgreSQL Schema Design

Architects high-performance PostgreSQL database schemas using industry-standard best practices for data integrity and scalability.

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.

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.

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.

PostgreSQL Schema Validator

Connects to live PostgreSQL databases to validate schema assumptions, perform system catalog queries, and cross-validate DDL outputs.

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.

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.

PostgreSQL Migrations & Schema Management

Provides expert guidance on PostgreSQL migrations, including idempotent patterns, index optimization, and resolving complex database errors.

PostgreSQL pg_dump Reference Guide

Consults PostgreSQL's pg_dump source code to provide authoritative guidance on system catalog queries and schema extraction patterns.

Zod Firestore Type Safety

Implements end-to-end type safety for Firestore databases using Zod schemas and the withConverter API.

Firebase Admin SDK for Next.js

Implements secure server-side Firebase Admin SDK patterns for Next.js 14+ to manage privileged operations and authentication.

Zod Firestore Type Safety

Ensures end-to-end type safety and runtime validation for Firestore databases using Zod schemas and the withConverter API.

Firebase Next.js Integration Strategies

Implements robust Firebase integration patterns for Next.js 14+ App Router environments using dual SDK architectures.

Firestore Data Modeling Patterns

Provides expert guidance on structuring Firestore NoSQL databases for optimal performance, scalability, and cost-efficiency.