Database Management Agent Skills

Supabase Database Manager

Enables direct connection and SQL execution for Supabase PostgreSQL databases within the Claude Code environment.

Supabase Database Migrations

Manages Supabase schema migrations, RLS policies, and PostGIS integration with security-first patterns.

Cube Data Modeling

Architects and optimizes Cube semantic layer models using YAML or JavaScript syntax for high-performance data analytics.

Redis Framework Integrations

Provides standardized Redis integration patterns and configuration templates for FastAPI, Next.js, and Express applications.

Async SQLAlchemy Patterns for FastAPI

Implements production-grade asynchronous SQLAlchemy 2.0+ database patterns and migrations for FastAPI applications.

Data Modeling & Schema Design

Designs optimized database schemas and indexing strategies tailored to specific application access patterns.

Database Selection & Architecture

Guides developers through choosing the optimal database architecture based on access patterns, scalability needs, and consistency requirements.

SQL Optimization Patterns

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

Redis Sentinel Configurations

Deploys production-grade Redis Sentinel high availability templates and configuration patterns for resilient data infrastructure.

Vector Database Configs

Configures and optimizes vector databases like pgvector, Chroma, and Pinecone for production RAG pipelines.

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.

Prisma 7 Expert

Optimizes database workflows using the Rust-free Prisma 7 ORM with high-performance queries and ESM-first architecture.

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.

Laravel Migrations Expert

Streamlines database schema design and migration management for Laravel applications using industry-standard patterns.

Drizzle Cube Joins

Configures and manages complex relational joins between data cubes to enable seamless, secure cross-cube querying in Drizzle Cube.

Supabase Schema Validator

Validates PostgreSQL schemas and migrations for Supabase projects to ensure SQL syntax compliance, naming conventions, and security best practices.

PatriotForge Database Architecture

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

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.

Supabase Integration for Mem0

Configures and optimizes Supabase as a production-ready vector and graph database backend for Mem0 OSS.

Supabase pgvector Setup

Configures pgvector on Supabase to enable high-performance semantic search, RAG systems, and hybrid search capabilities.

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.

SQLite for Go Development

Implements high-performance SQLite patterns in Go applications using best practices for drivers, migrations, and concurrency.

MongoDB Query Builder

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