Database Management Agent Skills

PostgreSQL Table Design

Architects optimized PostgreSQL schemas using industry-standard best practices for data integrity and high-performance indexing.

Neon Postgres Connection & Migrations

Configures reliable PostgreSQL connections and manages schema migrations for Neon's serverless database platform.

LLM Data Layer Architecture

Implements a robust 2-layer architecture to manage LLM extraction logs while protecting human-verified data integrity.

Database Migration & Schema Management

Execute database migrations across multiple ORMs and platforms using zero-downtime strategies and robust rollback procedures.

Supabase Postgres Best Practices

Optimizes Postgres database performance, schema design, and security configurations specifically for Supabase environments.

Supabase Auth & Persistent Memory

Standardizes user authentication and persistent conversation history using Supabase PostgreSQL for AI-driven SaaS applications.

Projection Patterns for Event Sourcing

Build high-performance read models and materialized views from event streams using CQRS principles.

Event Store Design

Designs and implements robust, scalable event stores for event-sourced architectures and microservices.

Django Performance Expert

Audits Django codebases to identify and fix validated database performance bottlenecks like N+1 queries and unbounded querysets.

Supabase Postgres Best Practices

Optimizes PostgreSQL performance and schema design using Supabase-vetted best practices and production-grade query patterns.

Performance Optimization Patterns

Implements high-performance coding patterns, caching strategies, and database query optimizations to reduce latency and improve scalability.

SQL Optimization Patterns

Optimizes database performance through advanced SQL query analysis, strategic indexing, and efficient execution patterns.

Database Migration & Schema Management

Executes seamless database migrations across multiple ORMs and platforms using zero-downtime strategies and robust rollback procedures.

PostgreSQL Table Design

Designs optimized PostgreSQL schemas using industry best practices for performance, data integrity, and scalability.

Supabase Query Optimizer

Optimizes Supabase PostgreSQL database performance by analyzing execution plans and implementing advanced indexing and RLS strategies.

PatriotForge Database Architecture

Standardizes PostgreSQL schema design and SQLAlchemy implementation for robust ERP data management.

Tenant Backup & Recovery

Streamlines multi-tenant data backup and recovery workflows across complex cloud environments.

SQL Optimization Patterns

Optimizes SQL queries and database performance through advanced indexing, EXPLAIN plan analysis, and efficient query patterns.

PostgreSQL Table Design

Architects optimized, production-ready PostgreSQL schemas using industry best practices for data integrity and performance.

SQL & ORM Optimization Helper

Optimizes SQL queries and ORM code in real-time to prevent N+1 issues and improve database performance.

Oracle JPA Entity Generator

Generates production-grade Jakarta Persistence (JPA) entity classes from Oracle SQL CREATE TABLE statements using standardized repository patterns.

MongoDB Schema Analyzer

Analyzes MongoDB collection structures to optimize data modeling, infer schemas, and ensure data consistency.

MongoDB Performance Advisor

Optimizes MongoDB database performance by analyzing query plans, recommending efficient indexing strategies, and identifying execution bottlenecks.

MongoDB Query Builder

Builds, optimizes, and executes MongoDB queries, aggregation pipelines, and complex CRUD operations.

Elasticsearch & OpenSearch

Integrates Elasticsearch and OpenSearch for complex search queries, data aggregations, and comprehensive index management.

PostGIS Geospatial Development

Implements best practices for querying and managing geospatial data in PostgreSQL with PostGIS.

Beanie ODM for MongoDB

Simplifies MongoDB integration in FastAPI applications using Beanie ODM for asynchronous document mapping and advanced query patterns.

Hostinger VPS Database Manager

Manages shared PostgreSQL, Redis, and MongoDB instances on Hostinger VPS infrastructure via Docker commands.

CRDT Distributed State Engine

Implements conflict-free replicated data types and bidirectional lens optics for seamless, distributed state synchronization.

InstantDB

Provides expert guidance and best practices for building, debugging, and querying with the InstantDB real-time database.