Database Management Agent Skills

AgentDB Advanced Features

Implements advanced vector database features including QUIC synchronization, hybrid search, and multi-node coordination for distributed AI systems.

Database Migration Master

Executes complex database migrations and schema transformations across multiple ORMs with zero-downtime strategies.

Projection Patterns for Event Sourcing

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

SQL Optimization Patterns

Optimizes SQL queries and database performance through systematic indexing strategies, execution plan analysis, and query restructuring.

PostgreSQL Table Design

Designs high-performance, production-ready PostgreSQL schemas using industry best practices and advanced database features.

Event Store Design

Design and implement robust event-sourced storage systems with optimized schemas and persistence patterns.

CRM Orbit Data Migrations

Streamlines the planning and implementation of complex data migrations for CRM Orbit's Automerge and Drizzle persistence layers.

Supabase Migration Toolkit

Streamlines and enforces strict naming conventions and security best practices for Supabase database migrations.

dbt Transformation Patterns

Implements production-grade dbt patterns for scalable data transformation and analytics engineering workflows.

SQL Optimization Patterns

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

Masterdata Explorer

Explores and analyzes project master data through schema discovery and SQL-powered CSV querying.

Supabase Seeding Toolkit

Populates Supabase databases with high-quality seed data, lookup tables, and large datasets using specialized scripts and best practices.

Supabase DB Conventions

Standardizes PostgreSQL database design for Supabase projects using tight-fit principles and consistent naming patterns.

Supabase Project Bootstrapper

Streamlines the initialization of Supabase projects by configuring SQL formatting, task automation, and schema access via MCP.

Salesforce SOQL Query Patterns

Provides standardized SOQL query templates and best practices for efficient Salesforce data retrieval.

Salesforce SOQL Syntax Assistant

Provides comprehensive syntax guidance and implementation patterns for writing, debugging, and optimizing Salesforce Object Query Language (SOQL) queries.

AgentDB Vector Search

Implement high-performance semantic vector search and intelligent document retrieval for RAG-based AI applications.

Salesforce Object Reference

Provides comprehensive Salesforce object schemas and relationship mapping to streamline SOQL query construction.

Salesforce CLI & SOQL Execution

Executes Salesforce CLI commands for SOQL querying, org authentication, and data management.

MongoDB Database Migrations

Manages MongoDB schema changes and repository implementations using Doctrine ODM and Hexagonal Architecture principles.

SQL to OSC Converter

Converts Flyway SQL migration scripts into Online Schema Change (OSC) format for seamless, zero-downtime database updates.

Soul Data Migration

Imports persistent knowledge and memory data from legacy SQLite databases or shared files into the cc-soul environment.

C# Multi-Database Integration

Provides standardized C# access patterns and best practices for interacting with DuckDB, PostgreSQL, MySQL, SQL Server, and DBISAM.

C# Database Access Patterns

Standardizes RDBMS integration in C# for DuckDB, PostgreSQL, MySQL, and legacy systems using optimized drivers and patterns.

Backend Database Queries

Writes secure, performant database queries using parameterization, indexing, and advanced optimization techniques.

GCP BigQuery Table Management

Manages Google Cloud BigQuery table lifecycles, including creation, partitioning, clustering, and security configurations.

Supabase Database Manager

Manages Supabase database schemas, migrations, and Row-Level Security (RLS) policies to streamline data operations for the CookMode V2 platform.

Supabase Database Architect

Implements robust Supabase database patterns, RLS policies, and type-safe TypeScript queries optimized for the PhotoVault ecosystem.

Data Import and History Management

Streamlines complex data ingestion from CSV and XLSX files while implementing a robust three-tier history management framework for audit trails.

Pinecone Vector Database

Integrates Pinecone's high-performance, managed vector database into your AI workflows for scalable RAG and semantic search applications.