Database Management Agent Skills

Backend Migration Standards

Establishes best practices for creating reversible, zero-downtime database migrations with consistent naming and structure.

SQLModel ORM Database Helper

Designs and implements production-grade database layers using SQLModel and SQLAlchemy 2.0 patterns for Python projects.

Database Domain Specialist

Architects and manages complex database systems using PostgreSQL, MongoDB, and Redis patterns for modern applications.

SQLModel ORM Helper

Designs and implements production-grade database layers for Python applications using SQLModel and SQLAlchemy 2.0 patterns.

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.

SQL Optimization Patterns

Optimizes database performance using advanced indexing, EXPLAIN plan analysis, and efficient query design patterns.

SQL Optimization Patterns

Optimizes SQL queries and database schemas through advanced indexing strategies, query plan analysis, and performance pattern implementation.

InsForge Schema Patterns

Provides expert PostgreSQL schema designs and Row-Level Security (RLS) patterns optimized for the InsForge and PostgREST ecosystem.

SQLModel ORM Helper

Designs and implements production-grade database layers using SQLModel and SQLAlchemy 2.0 patterns for Python projects.

SQLModel ORM Helper

Design and implement production-grade database layers using SQLModel with SQLAlchemy 2.0 patterns for FastAPI projects.

InsForge Database Schema Patterns

Provides expert PostgreSQL schema patterns and RLS policies optimized for InsForge and PostgREST applications.

CloudBase Web SDK Database Tools

Facilitates seamless data management in web applications using the Tencent CloudBase Document Database Web SDK.

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.

Data Governance Manager

Manages data lineage, metadata cataloging, access control, and compliance standards for modern data platforms.

PostgreSQL Migration & Schema Expert

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

Data Modeling Essentials

Designs optimized database schemas, dimensional models, and normalized structures for efficient data analytics and storage.

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.

Pipeline Design

Architects robust ETL/ELT data pipelines with standardized patterns for reliability and scalability.

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.