Database Management Agent Skills

Coder Convex Development

Streamlines self-hosted Convex backend development within Coder workspaces, handling queries, mutations, and authentication configuration.

Cross-Env PostgreSQL Extensions

Generates environment-agnostic PostgreSQL extension migrations using resilient DO block patterns for Nhost and CNPG.

Supabase pgvector Setup

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

SQL Optimization Patterns

Optimizes SQL query performance through systematic indexing strategies, execution plan analysis, and efficient query patterns.

SQLite for Go Development

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

Mozilla BigQuery Query Writer

Writes cost-optimized, high-performance BigQuery queries for Mozilla telemetry and Firefox metrics.

Event Store Designer

Designs and implements robust event stores for high-performance event-sourced systems and microservices architectures.

Supabase Realtime

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

Supabase API & Client Guide

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

Supabase API & Client

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

pgdbm Database Pattern Selector

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

Sequelize Model Expert

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

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.

Database Implementation

Streamlines database schema design, automated Flyway migrations, and SQL query optimization within the Claude Code environment.

PostgreSQL Table Design Expert

Architects high-performance PostgreSQL schemas using industry-standard best practices for indexing, data types, and normalization.

Drizzle Cube Definition

Simplifies the creation of secure, type-safe semantic layer cube definitions for Drizzle ORM-based applications.

Modern Neo4j Cypher Guide

Generates optimized, modern Neo4j Cypher queries while ensuring compatibility with the latest syntax standards and performance patterns.

SQL Optimization Patterns

Optimizes SQL queries and database schemas using advanced indexing, execution plan analysis, and performance patterns.

Database Migration & Schema Management

Automates and guides complex database migrations across multiple ORMs with a focus on zero-downtime and data integrity.

Database Migration Patterns

Manages database schema evolution using Supabase, Prisma, and Drizzle with production-safe patterns.

MOVA Episode Ingest & Store

Persists ingested episode data into the MOVA lab's genetic file store for automated workflow cycles.

Supabase CLI Toolkit

Streamlines Supabase project management, local development, and database migrations within Claude.

Supabase Implementation Standards

Enforces standardized Supabase integration patterns using a unified service layer and secure Service Role management.

AC Knowledge Graph

Builds and queries relational knowledge graphs to provide Claude with a structural and semantic understanding of complex codebases.

PostgreSQL Table Design

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

Supabase Realtime

Enables real-time data synchronization, live broadcasts, and user presence tracking using Supabase's Realtime engine.

AgentDB Vector Search

Implements high-performance semantic vector search and RAG capabilities for intelligent document retrieval.

Supabase Troubleshooting

Diagnoses and resolves complex Supabase issues including authentication errors, RLS policy failures, and database performance bottlenecks.

Beanie ODM for MongoDB

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