Database Management Agent Skills

Neon Postgres

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

dbt Model Builder

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

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.

Backend Queries

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

Objectstar Legacy Migration

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

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.

Validate with Database

Validates PostgreSQL schema assumptions and cross-references DDL outputs using live database connections.

SQL Optimization Patterns

Optimizes SQL query performance through advanced indexing strategies, execution plan analysis, and efficient database design patterns.

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.

Holochain DNA Development (Nondominium)

Develops ValueFlows-compliant Holochain DNA with a focus on integrity/coordinator architecture and WASM optimization.

PostgreSQL Table Design

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

Database Cache Layer

Implements high-performance multi-tier caching architectures to reduce database load and minimize query latency.

ER Diagram and Data Modeling

Generates entity-relationship diagrams and provides expert data modeling guidance for robust database schema design.

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.