Database Management Agent Skills

Supabase API & Client

Integrates Supabase backend services using the JavaScript client and direct REST API endpoints.

Supabase API & Client Guide

Streamlines Supabase integration by providing comprehensive patterns for the JavaScript client and direct REST API interactions.

SQL Optimization Patterns

Optimizes database performance by implementing efficient indexing, query refactoring, and execution plan analysis.

SQL Optimization Patterns

Optimizes SQL database performance through query plan analysis, advanced indexing strategies, and systematic query refactoring.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through quantization, HNSW indexing, and advanced caching strategies to maximize search speed and minimize memory usage.

SQL Optimization Patterns

Optimizes database performance through advanced query tuning, indexing strategies, and detailed execution plan analysis.

Supabase Realtime

Implements real-time database subscriptions, client-to-client broadcasts, and user presence tracking using Supabase.

AgentDB Advanced Features

Implements high-performance vector search, distributed QUIC synchronization, and multi-database management for advanced AI systems.

Database Migration Mastery

Executes complex database migrations and schema transformations across multiple ORMs with a focus on zero-downtime and data integrity.

Supabase Database

Streamlines Supabase database management through optimized CRUD operations, Row Level Security (RLS) implementation, and PostgreSQL function support.

dbt Model Builder

Constructs standardized dbt models following Kimball dimensional patterns and modern testing configurations.

ActiveRecord for Rails

Manages and optimizes Ruby on Rails database interactions through expert ActiveRecord guidance and implementation patterns.

Supabase Row Level Security

Streamlines the creation, implementation, and testing of Supabase Row Level Security policies to ensure robust data isolation.

MongoDB CRUD Operations

Master document-based data operations with standardized NoSQL patterns for insertion, querying, updating, and deletion.

pgdbm Core API Reference

Provides comprehensive technical documentation for implementing pgdbm database operations and managing PostgreSQL configurations.

Postgres Hypothetical Index Helper

Generates Ruby and ActiveRecord commands to create and test PostgreSQL hypothetical indexes using the HypoPG extension.

Backend Queries

Implements structured database queries and repository patterns using Prisma ORM to maintain a robust layered architecture.

Rails Migrations

Streamlines database schema management and ActiveRecord migration workflows for Ruby on Rails applications.

Snowflake Query Execution

Executes SQL queries against Snowflake data warehouses with support for multiple authentication methods and flexible output formats.

V3 Memory Unification & AgentDB Integration

Unifies disparate AI memory systems into a high-performance AgentDB backend with HNSW vector search for massive retrieval speedups.

Database Schema Conflict Resolver

Resolves database schema version conflicts by automatically selecting the most recent migration timestamp.

Bulk Static Data Sync

Optimizes high-volume data synchronization from external APIs to databases using multi-row insert patterns and foreign key pre-filtering.

AgentDB Advanced Features

Optimizes AgentDB implementations with advanced capabilities like QUIC synchronization, hybrid search, and distributed database management.

AgentDB Advanced Features

Optimizes distributed AI systems with low-latency QUIC synchronization, hybrid vector search, and advanced multi-database management.

Supabase Next.js Integration

Streamlines the integration of Supabase backend services into React and Next.js applications using modern App Router patterns and SSR.

PostgreSQL Table Design

Architects high-performance, production-ready PostgreSQL schemas using industry-standard best practices and data modeling patterns.

Backend Models

Architects robust database models following Eloquent best practices, including relationship definitions, data typing, and multi-layer validation.

Redis Connection Management

Optimizes Redis reliability and performance through standardized connection pooling, client configuration, and resilient reconnection strategies.

Redis AI Cache Patterns

Implements cost-efficient embedding and vector caching strategies using Redis to optimize AI application performance and expenses.

Database Migrations for Claude

Manages database schema changes using Alembic patterns, ensuring safe upgrades, downgrades, and data integrity.