Database Management Agent Skills

Backend Migrations

Manages database schema evolutions through reversible migrations, zero-downtime deployment strategies, and standardized version control practices.

Backend Models

Standardizes the definition of database models, relationships, and constraints to ensure data integrity and consistent ORM implementation.

Backend Queries

Writes secure, performant database queries and data fetching logic while implementing best practices like eager loading and parameterized inputs.

Supabase Prisma Database Management

Manages database schemas, migrations, and seed data using Prisma ORM integrated with Supabase PostgreSQL infrastructure.

NextSQL DSL Expert

Generates and manages type-safe NextSQL queries, mutations, and migrations with strict DSL compliance for Rust-based projects.

MoAI Domain Database

Provides expert-level database architecture, optimization, and management for PostgreSQL, MongoDB, and Redis environments.

CloudBase Web Database Integration

Streamlines data operations and SDK integration for web applications using the CloudBase document database.

Supabase SQLAlchemy Integration

Configures high-performance SQLAlchemy async patterns for Supabase, including Row Level Security (RLS) authentication and optimized connection pooling.

SQL Server & T-SQL Patterns

Optimizes SQL Server development with industry-standard T-SQL patterns, query performance tuning, and robust database administration strategies.

SQL Server & T-SQL Patterns

Provides expert guidance and implementation patterns for SQL Server 2016+ and Azure SQL Database optimization and administration.

Prisma ORM Expert

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

MongoDB Schema Architect

Generates optimized Mongoose schemas with robust validation, efficient indexing strategies, and performance-tuned data relationships.

Neon Serverless Postgres

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

Neon Postgres

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

Postgres Best Practices

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

Postgres Performance & Best Practices

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

Data Pipelines & ETL Orchestration

Architects reliable ETL/ELT pipelines using idempotent patterns, automated quality checks, and robust orchestration strategies.

ClickHouse Analytics & Data Engineering

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

Atlas Database Concepts

Explains core database migration workflows, schema-as-code principles, and modern DevOps practices using Atlas.

ETL Pipeline Specialist

Builds and optimizes robust data pipelines with a focus on data quality, error handling, and operational reliability.

BigQuery & Dataform SQLX Patterns

Standardizes BigQuery SQL and Dataform SQLX development with optimized patterns for data transformations, incremental modeling, and architectural best practices.

Alembic Migration Patterns

Automates the generation and fixing of SQLAlchemy Alembic migrations to handle complex types and constraints safely.

Dataform & BigQuery Debugging

Troubleshoots Dataform workflows and BigQuery environments to resolve compilation, authentication, and data quality issues.

Atlas ORM Migration Integration

Automates database migration generation and schema management by integrating Atlas with popular ORMs like Prisma, GORM, and SQLAlchemy.

Event Stream Projection Patterns

Builds high-performance read models and materialized views from event streams for event-sourced systems.

Snowflake Query Execution

Executes SQL queries against Snowflake data warehouses with support for multiple authentication methods and flexible output formats.

Ecto Architecture & DDD Thinking

Guides Elixir developers through Ecto data layer design, domain-driven architecture, and database performance optimizations.

SQL Optimization Patterns

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

Waggle Provider Detector

Automatically identifies and configures active data source providers for the Waggle plugin ecosystem.

Database Schema & Migration Implementation

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