Database Management Agent Skills

SQL Server & T-SQL Patterns

Provides expert guidance and implementation patterns for T-SQL query optimization, indexing strategies, and database administration.

Convex Component Authoring

Guides the creation of reusable, isolated Convex backend components with standardized schemas, functions, and deployment patterns.

Database Migration Patterns

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

Aegis Tenancy Enforcer

Enforces strict multi-tenant data isolation by ensuring communityId filters are consistently applied across all MongoDB queries and service logic.

ClickHouse Analytics & Data Engineering

Optimizes ClickHouse database schemas and analytical queries for high-performance OLAP workloads and data engineering.

Database Management & Design

Optimizes database performance and manages schema design, migrations, and complex SQL query generation for relational databases.

AgentDB Advanced Features

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

AgentDB Vector Search

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

AgentDB Vector Search

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

AgentDB Performance Optimization

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

TimescaleDB Setup & Hypertable Configuration

Configures high-performance TimescaleDB hypertables with optimized compression, retention policies, and continuous aggregates.

Searchlite Index Lifecycle

Manages and optimizes Searchlite's internal storage pipeline, including indexing, durability, and segment compaction.

Wheels Migration Generator

Generates database-agnostic CFML migrations for the Wheels framework to manage schema changes reliably.

Wheels Migration Generator

Generates database-agnostic CFWheels migrations for schema management while enforcing best practices and fixing common CLI bugs.

Wheels Migration Generator

Generates database-agnostic CFWheels migrations for schema management, table creation, and cross-platform database consistency.

TimescaleDB Hypertable Setup

Guides the design and implementation of optimized TimescaleDB schemas for high-performance time-series data storage and analysis.

Database Migration & Schema Evolution

Executes and manages database schema migrations, data transformations, and zero-downtime deployment strategies across multiple ORMs.

Database Testing

Validates database schemas, ensures data integrity, and verifies migration safety to prevent data loss or corruption.

InsForge Database Schema Patterns

Provides optimized PostgreSQL schema patterns and Row Level Security policies for building secure, scalable InsForge applications.

CRDT State Synchronizer

Implements Conflict-free Replicated Data Types (CRDTs) to enable eventually consistent state synchronization across distributed systems.

Database & Data Schema Lead

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

Backend Migration Standards

Establishes best practices for creating reversible, zero-downtime database migrations with consistent naming and structure.

AgentDB Performance Optimization

Optimizes AgentDB vector databases using quantization, HNSW indexing, and advanced caching to maximize search speed and minimize memory overhead.

PostgreSQL Patterns

Streamlines PostgreSQL database development with optimized schema design, indexing strategies, and security best practices.

AgentDB Performance Optimization

Optimizes AgentDB vector databases using quantization, HNSW indexing, and advanced caching for high-performance AI agent memory.

V3 Memory Specialist

Unifies multiple disparate memory systems into a high-performance AgentDB solution using HNSW vector indexing for massive search performance gains.

Unified AgentDB Memory & Vector Search

Consolidates disparate agent memory systems into a high-performance AgentDB backend with HNSW vector indexing for ultra-fast retrieval.

Database Migration Expert

Implements safe, reversible database schema changes and zero-downtime deployment patterns across major ORMs and SQL dialects.

V3 Memory Unification

Consolidates multiple legacy memory systems into a high-performance AgentDB backend with HNSW vector search.

Swarm Memory Manager

Coordinates distributed memory and state synchronization across multi-agent systems to ensure data consistency and high-performance retrieval.