Database Management Agent Skills

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.

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.

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.

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.

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.

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.

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.

AgentDB Advanced Features

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

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 Performance Optimization

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

SQL Development

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

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.

Backend Migrations

Manages database schema changes through reversible, version-controlled migration files while ensuring zero-downtime deployment compatibility.

Soul Data Migration

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

E-Report Database Management

Simplifies querying and managing the v3_e-report database for data analysis alert configurations and tenant statistics.

OpenAPI & Connector Database Manager

Queries and manages integrated connector configurations and API metadata within the v3_openapi database.

Blacklake OpenAPI Database Query

Queries and manages integrated connectors and API configurations within the v3_openapi database using structured SQL templates.