Database Management Agent Skills

Supabase Expert

Provides comprehensive guidance for building secure and scalable applications using Supabase database, auth, storage, and edge functions.

PostgreSQL Nanoid Identifiers

Implements a hybrid ID strategy using Nanoids for public-facing identifiers and UUIDs for internal PostgreSQL references.

Rails ActiveRecord Optimization Patterns

Optimizes Ruby on Rails database interactions with production-grade ActiveRecord patterns and performance best practices.

Data SQL & Schema Design

Optimizes SQL queries, designs scalable database schemas, and implements high-performance data modeling patterns.

PostgreSQL Query Assistant

Executes SQL queries and translates natural language into database commands for local PostgreSQL instances.

Database Smoke Testing

Automates comprehensive database health checks to validate connectivity, performance, and integrity during release cycles.

DuckDB SQL

Generates and refines DuckDB SQL queries for data analysis using local database, CSV, and Parquet files.

GraphRAG for PostgreSQL

Automates the design and implementation of GraphRAG systems using PostgreSQL, pgvector, and PGroonga.

Event Store Design & Implementation

Design and implement high-performance event stores with robust patterns for event-sourced architectures.

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.

Prisma Database Expert

Optimizes Prisma ORM workflows including schema design, migration management, and high-performance query modeling.

SQL Optimization Patterns

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

Database Schema & Migration Implementation

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

Drizzle ORM Expert

Provides comprehensive documentation and implementation patterns for Drizzle ORM, covering type-safe queries, schema management, and multi-database integrations.

Database Implementation & Migrations

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

Prisma Database Expert

Optimizes Prisma ORM workflows including schema design, migrations, query performance, and database connection management.

PostgreSQL Table Design

Designs optimized, production-grade PostgreSQL schemas following industry best practices and performance patterns.

JGI Lakehouse Query

Facilitates querying and exploring the Joint Genome Institute (JGI) Dremio Lakehouse, including GOLD and IMG genomics databases.

Neon Postgres Integration

Optimizes Postgres database management using Neon serverless patterns, connection pooling, and ORM integrations for Prisma and Drizzle.

Prisma ORM Expert

Optimizes Prisma schema design, database migrations, and query performance for robust backend development.

Postgres Optimization & Best Practices

Optimizes Postgres database performance and schema design using Supabase-vetted best practices and implementation patterns.

Neon Postgres Integration

Optimizes serverless PostgreSQL workflows using Neon-specific patterns for branching, connection pooling, and ORM integration.

Firebase Development Suite

Implements robust, scalable Firebase architectures including authentication, real-time databases, and secure cloud functions.

Neon Postgres Expert

Optimizes serverless PostgreSQL workflows using Neon's branching, connection pooling, and specialized ORM integrations for Prisma and Drizzle.

Postgres Optimization & Best Practices

Optimizes Postgres database performance and security using Supabase-vetted schema designs, query patterns, and connection management strategies.

Postgres Best Practices

Optimizes PostgreSQL performance, schema design, and security using industry-standard patterns and Supabase-verified guidelines.

Database Archival System

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

Database Audit Trail Implementation

Automates the implementation of comprehensive database audit logging to track data changes for security, compliance, and monitoring.

Juicebox Data Migration Pro

Orchestrates complex data migrations from recruiting platforms and ATS systems into Juicebox with enterprise-grade reliability.