Database Management Agent Skills

Backend Queries

Optimizes database interactions by implementing secure, performant query patterns and preventing common pitfalls like SQL injection and N+1 overhead.

Backend Migrations

Manages database schema evolutions through versioned migration files that prioritize data integrity, reversible changes, and zero-downtime deployment strategies.

Backend Models

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

Postgres Query Optimization

Optimizes PostgreSQL database performance by analyzing execution plans, identifying bottlenecks, and implementing advanced indexing strategies.

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.

Supabase RLS Policy Generator

Generates secure, production-ready Row-Level Security (RLS) policies for Supabase databases using multi-tenant and role-based access patterns.

Sequelize Model Expert

Standardizes Sequelize ORM model definitions and best practices for high-performance PostgreSQL implementations.

Supabase Prisma Database Management

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

Devops Database

Manages PostgreSQL database operations including Alembic migrations, backups, restorations, and pgvector extension management for development and production environments.

ORM Reviewer

Reviews and optimizes ORM code for efficiency, transaction handling, and N+1 query prevention.

PostgreSQL Table Design

Architects high-performance PostgreSQL schemas using industry best practices for data integrity, indexing, and advanced features.

Data Governance Manager

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

Data Modeling Essentials

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

Pipeline Design

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

Supabase CLI

Manages Supabase local development environments, database migrations, and multi-language type generation via comprehensive CLI command guidance.

Database Designer

Infers and generates database schemas, migrations, and ORM models directly from natural language feature descriptions.

CHGIS Temporal Gazetteer

Queries the China Historical GIS Temporal Gazetteer API to retrieve and analyze historical Chinese placenames and administrative structures from 222 BCE to 1911 CE.

Supabase SQLAlchemy Integration

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

Database Migration Master

Facilitates seamless database schema and data migrations across multiple ORMs with a focus on zero-downtime strategies and safety.

Warehouse Optimization

Optimizes data warehouse performance through efficient partitioning, query tuning, and cost-effective resource management.

dbt Data Modeling Expert

Implements industry-standard dbt patterns for scalable data transformation, automated testing, and comprehensive documentation.

AgentDB Performance Optimization

Optimizes vector database performance and memory efficiency through advanced quantization techniques, HNSW indexing, and intelligent caching strategies.

Mongo TS

Executes native MongoDB query syntax directly from the command line with built-in safety features and flexible output formatting.

Supabase Expert

Implements high-performance database architectures, secure Row Level Security policies, and type-safe data services for Supabase environments.

AgentDB Vector Search

Implements high-performance semantic vector search and document retrieval for RAG systems and intelligent knowledge bases.

pgdbm Database Pattern Selector

Guides developers in selecting the optimal architectural pattern for PostgreSQL database management based on deployment context and reusability.

PostgreSQL Database Development

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

Backend Migrations

Generates robust database migrations following Laravel best practices for reversible schema changes and optimal performance.

Backend Queries

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