Database Management Agent Skills

PostgreSQL pg_dump Reference Guide

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

PostgreSQL Migrations & Schema Management

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

PostgreSQL Schema Validator

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

PostgreSQL Schema Design

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

Database Code Reviewer

Reviews database migrations, query performance, and transaction logic to ensure data integrity and prevent production downtime.

Stored Procedure Generator

Generates production-ready stored procedures, functions, and triggers for PostgreSQL, MySQL, and SQL Server to optimize database logic.

SQL Query Optimizer

Analyzes and optimizes SQL queries to enhance database performance through index recommendations and structural rewrites.

Neon CLI Expert

Manages serverless PostgreSQL projects and branching workflows using the Neon CLI directly within your development environment.

PostgreSQL Table Design

Architects optimized PostgreSQL schemas using industry best practices for performance, scalability, and data integrity.

Drizzle ORM Setup & Patterns

Configures Drizzle ORM for Node.js applications with type-safe schemas and SQL-first query patterns.

Understanding Data

Performs systematic data profiling and exploratory analysis to reveal the structure, quality, and relationships within relational databases.

Node.js Database Query Optimization

Optimizes database performance in Node.js applications by implementing indexing, pagination, and N+1 query prevention strategies.

Database Migration Strategies

Implements safe, zero-downtime database schema changes and data migrations using industry-standard patterns and ORM best practices.

Database Connection Pooler

Optimizes database connection pooling and lifecycle management to enhance application performance and resource efficiency.

Supabase Infrastructure Manager

Manages Supabase projects including database migrations, Edge Functions deployment, and local development environments via the Supabase CLI.

Database Implementer

Generates robust database schemas, versioned migrations, and optimized data access layers for efficient application development.

PostgreSQL Explorer & Debugger

Explores, debugs, and manages PostgreSQL databases using AI-optimized JSON outputs and comprehensive schema discovery tools.

Data Engineering

Standardizes data pipeline design, ETL processes, and schema evolution using data-as-a-product principles.

PowerSync Local-First Sync

Builds offline-capable, local-first TypeScript applications with real-time SQLite-to-backend synchronization.

PostgreSQL Guide

Retrieves real-time, official PostgreSQL documentation for accurate SQL syntax, database configuration, and performance optimization.

East Node I/O

Provides a comprehensive suite of I/O functions for the East programming language, enabling seamless integration with databases, cloud storage, and file formats.

Persistence Layer Auditor

Audits and optimizes SQLite persistence layers by identifying unused tables, broken method calls, and schema inconsistencies.

Database Connection Optimizer

Enhances application performance by configuring and optimizing database connection pools across various programming languages.

Database Audit Logger

Implements comprehensive database audit logging to track data changes, maintain compliance, and enhance system observability.

Event Store Design Patterns

Designs and implements robust event storage solutions for event-sourced architectures and high-performance distributed systems.

Database Schema Designer

Designs, normalizes, and visualizes robust relational database schemas using industry best practices and Mermaid ERD diagrams.

Event-Sourced Projection Patterns

Builds efficient read models and materialized views from event streams to optimize query performance in event-sourced systems.

PostgreSQL Syntax & Grammar Reference

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

Supabase Database Integration

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

Database Connection Pooling

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