Database Management Agent Skills

Backend Migrations

Manages database schema changes and data migrations using industry best practices to ensure data integrity and zero-downtime deployments.

Stripe Database Sync

Syncs Stripe data to a PostgreSQL database for seamless querying, reporting, and backend integration.

Database Operations

Implements high-performance, production-ready database architectures using async patterns and modern ORM best practices.

Backend Queries

Optimizes database performance and security through efficient query construction, transaction management, and eager loading patterns.

Go Model Query Builder

Constructs type-safe database queries using a standardized Options API for Go backend services.

Backend Models

Manages database model configurations, relationships, and validation logic to ensure robust data structures and ORM integrity.

Stripe Sync Database Migrations

Automates the setup and management of PostgreSQL database schemas for synchronizing Stripe data.

Backend Migrations

Manages database schema evolutions and data migrations using industry-standard tools and zero-downtime best practices.

Task Search

Implements robust search capabilities for task management applications, including keyword matching, relevance ranking, and multi-criteria filtering.

MongoDB Aggregation Optimization

Optimizes MongoDB aggregation pipelines through strategic stage ordering, index utilization, and performance-driven query patterns.

Backend Models

Defines and structures database schemas, entities, and relationships while ensuring data integrity and performance through constraints and indexing.

Backend Queries

Writes secure, optimized database queries and data access logic using industry best practices for performance and scalability.

SurrealDB for Dart

Integrates SurrealDB into Dart and Flutter applications with support for embedded databases, ORM features, and AI-powered vector search.

PostgreSQL Database Development

Provides expert guidance on PostgreSQL schema design, Alembic migrations, SQLAlchemy patterns, and query optimization for high-performance database applications.

Splunk KV Store Manager

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

DBF Data Analysis

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

Supabase Expert

Manages Supabase database operations, security policies, and edge functions following project-specific standards and real-time state verification.

SQLAlchemy Conversion

Converts asyncpg database code to SQLAlchemy 2.0+ asynchronous patterns while preserving performance and transaction integrity.

AsyncPG Database Detection

Scans Python and FastAPI projects to identify asyncpg imports, connection patterns, and query logic for migration to SQLAlchemy.

Supabase SQLAlchemy Integration

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

Database Schema Design

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

Alembic Migration Manager

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

Database Connection Pooling

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

Supabase Database Integration

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

PostgreSQL Syntax & Grammar Reference

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

Supabase Prisma Database Management

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

Backend Queries

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

WorldCrafter Database Setup

Generates Prisma models, database migrations, and Row-Level Security policies to establish a secure data foundation for world-building features.

Backend Models

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

Backend Migrations

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