Database Management Agent Skills

Database Connection Optimizer

Enhances application performance by configuring and optimizing database connection pools across various programming languages.

Database Audit Logger

Implements comprehensive database audit logging to track data changes, maintain compliance, and enhance system observability.

Supabase CLI

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

Database Schema Designer

Designs, normalizes, and visualizes robust relational database schemas using industry best practices and Mermaid ERD diagrams.

Supabase Prisma Database Management

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

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.

Backend Models

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

Backend Migrations

Manages database schema evolutions through reversible migrations, zero-downtime deployment strategies, and standardized version control practices.

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 Migrations

Manages database schema transitions with a focus on reversibility, data integrity, and zero-downtime deployment strategies.

SQL Code Formatter

Formats and polishes SQL queries according to Oracle Database 19 best practices for improved readability and consistency.

Database Schema Management

Manages PostgreSQL database schemas and Prisma ORM migrations within the ClaudeCode Sentiment Monitor project.

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.

Warehouse Optimization

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

SQL Optimization Patterns

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

PostgreSQL Table Design

Architects high-performance, production-ready PostgreSQL schemas using modern best practices and advanced indexing patterns.

Supabase RLS Policy Setup

Configures production-ready Row Level Security policies for Supabase tables to ensure secure, role-based data access.

Atomic Transaction Manager for Supabase

Implements secure, atomic PostgreSQL transactions in Supabase using PL/pgSQL RPC functions to ensure data consistency.

Data Engineer

Architects and maintains robust data pipelines, analytics infrastructure, and integration workflows.

AgentDB Performance Optimization

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

AgentDB Vector Search

Implements high-performance semantic vector search and intelligent document retrieval using HNSW indexing and quantization for sub-millisecond querying.

AgentDB Vector Search

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

AgentDB Advanced Features

Implements advanced vector database capabilities including QUIC synchronization, hybrid search, and distributed multi-agent coordination.

AgentDB Advanced Features

Implement high-performance distributed vector databases with sub-millisecond synchronization, hybrid search, and advanced distance metrics.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance using quantization, HNSW indexing, and advanced caching strategies to reduce memory footprint and accelerate search speeds.

Sequelize Migration Expert

Provides battle-tested Sequelize migration patterns and best practices for safe PostgreSQL schema changes.

SQL Development

Writes, reviews, and optimizes performant SQL queries while applying PostgreSQL-specific best practices for schema design and performance tuning.

OP Database Metadata Manager

Provides specialized SQL query templates for managing and exploring v3_metadata database structures, including business objects and custom fields.