Database Management Agent Skills

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.

PostgreSQL Syntax & Grammar Reference

Consults PostgreSQL's internal parser and grammar rules to provide precise guidance on SQL syntax and DDL structure.

Event-Sourced Projection Patterns

Builds efficient read models and materialized views from event streams to optimize query performance in event-sourced systems.

Event Store Design Patterns

Designs and implements robust event storage solutions for event-sourced architectures and high-performance distributed systems.

Persistence Layer Auditor

Audits and optimizes SQLite persistence layers by identifying unused tables, broken method calls, and schema inconsistencies.

Database & Data Schema Lead

Standardizes and documents project data formats, frontmatter schemas, and validation rules based on observable codebase evidence.

East Node I/O

Provides a comprehensive suite of I/O functions for the East programming language, enabling seamless integration with databases, cloud storage, and file formats.

PostgreSQL Guide

Retrieves real-time, official PostgreSQL documentation for accurate SQL syntax, database configuration, and performance optimization.

PowerSync Local-First Sync

Builds offline-capable, local-first TypeScript applications with real-time SQLite-to-backend synchronization.

Data Engineering

Standardizes data pipeline design, ETL processes, and schema evolution using data-as-a-product principles.

PostgreSQL Explorer & Debugger

Explores, debugs, and manages PostgreSQL databases using AI-optimized JSON outputs and comprehensive schema discovery tools.

Backend Migrations

Manages database schema changes through reversible migrations, clear naming conventions, and safe deployment practices for backend services.

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.

Database Implementer

Generates robust database schemas, versioned migrations, and optimized data access layers for efficient application development.

Supabase Infrastructure Manager

Manages Supabase projects including database migrations, Edge Functions deployment, and local development environments via the Supabase CLI.

Database Migration Strategies

Implements safe, zero-downtime database schema changes and data migrations using industry-standard patterns and ORM best practices.

Database Management

Configures and manages TinyDB document databases for efficient JSON-based data persistence in Python applications.

Sequelize Migration Expert

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

Node.js Database Query Optimization

Optimizes database performance in Node.js applications by implementing indexing, pagination, and N+1 query prevention strategies.

OP Database Metadata Manager

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

Universal Database Query Tool

Executes and manages SQL queries while providing structured schema insights and formatted data results via MCP tools.

Common Database Queries

Provides a standardized workflow and SQL templates for efficient database querying and structured result analysis using the exec_sql tool.

Black Lake DB Metadata Helper

Accesses and queries Black Lake v3_metadata database tables for object codes, events, custom fields, and system configurations.