Database Management Agent Skills

Database Code Reviewer

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

Database Replication Manager

Automates the setup and management of database replication, failover, and high availability for PostgreSQL and MySQL.

Backend Models

Defines and optimizes database models and ORM entities with robust relationships, data validation, and integrity constraints.

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.

Backend Models

Defines robust database schemas and ORM entities with precise data types, relationships, and validation constraints.

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.

NoSQL Data Modeler

Designs and optimizes high-performance NoSQL schemas for MongoDB, DynamoDB, and other document-based databases using industry best practices.

Database Migration (SQLModel + Alembic)

Automates database migration workflows for SQLModel projects using Alembic with strict enforcement of model-first principles and safety checks.

Understanding Data

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

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 Index Advisor

Analyzes query workloads and provides actionable recommendations to optimize database indexing strategies for improved performance.

Event Store Design Patterns

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

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.

Alembic Migration Manager

Manages database schema and data migrations using Alembic through standardized workflows and production-ready best practices.

Database Schema Design

Designs robust, scalable relational database schemas through structured workflows, entity-relationship modeling, and SQL generation.

DBF Data Analysis

Analyzes and converts legacy Thai accounting DBF databases into efficient Parquet format for high-performance SQL querying with DuckDB.

Splunk KV Store Manager

Manages Splunk App Key Value Store collections and records for persistent metadata and application state storage.