Database Management Agent Skills

SQL Batching

Prevents D1/SQLite 'too many SQL variables' errors by automatically batching Drizzle ORM queries with dynamic arrays.

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.

AgentDB Vector Search

Implements high-performance semantic vector search and document retrieval with sub-millisecond latency for intelligent RAG systems.

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.

Database Operations

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

Backend Migrations

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

Model Requirements Gatherer

Guides the structured gathering of requirements for new and existing BigQuery data models to ensure robust ETL pipeline planning.

Backend Migrations

Manages PostgreSQL schema changes and Prisma database migrations following a split-architecture pattern and strict coding standards.

Stripe Database Sync

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

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.

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.