Database Management Agent Skills

PostgreSQL Schema Validator

Validates PostgreSQL database schemas by comparing live database states, pg_dump outputs, and system catalog queries.

Backend Migration Standards

Manages database schema evolutions and data migrations using zero-downtime strategies and reversible standards.

CloudBase Web SDK Database Guide

Streamlines implementation of the CloudBase document database Web SDK for advanced data management and querying.

Backend Migration Standards

Enforces safe, reversible, and zero-downtime database schema evolutions following industry best practices.

Convex Real-Time Sync

Implements reactive queries and real-time data synchronization using the Convex platform to create live-updating user interfaces.

PostgreSQL Migration & Schema Expert

Provides comprehensive guidance and implementation patterns for robust, idempotent PostgreSQL database migrations and schema design.

PostgreSQL Table Designer

Architects high-performance, production-grade PostgreSQL schemas using modern best practices and idiomatic data patterns.

PostgreSQL Syntax Reference

Consults PostgreSQL's internal parser and grammar rules to ensure precise SQL syntax implementation and DDL generation.

Convex Real-time Development

Implements reactive data synchronization and live updates using Convex's automatic query subscriptions.

pg_dump Reference

Consults the official PostgreSQL pg_dump implementation to provide canonical guidance on system catalog queries and schema extraction.

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.

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.

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.

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.

MySQL Database Skill

Executes safe SELECT queries against MySQL and MariaDB databases with built-in connection pooling and SQL injection prevention.

Event Store Design Patterns

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