Database Management Agent Skills

Mortgage Servicing US Compliance

Provides regulatory guidance and technical specifications for building compliant U.S. mortgage servicing software.

Canadian Mortgage Servicing Regulatory Guide

Provides expert regulatory guidance and technical patterns for building compliant Canadian mortgage servicing software.

SQL Query Optimizer

Analyzes and optimizes SQL queries to improve database performance, resolve N+1 issues, and ensure efficient index usage.

Database Schema Reviewer

Analyzes and optimizes database schemas for normalization, data integrity, and high-performance indexing.

Migration Checker

Audits database migrations for schema safety, data integrity, and zero-downtime deployment patterns.

SQL to OSC Converter

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

T-SQL Pro & Database Optimization

Writes high-performance, secure T-SQL code and optimizes SQL Server database schemas using industry best practices.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through quantization, HNSW indexing, and advanced caching strategies to maximize search speed and minimize memory usage.

AgentDB Vector Search

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

AgentDB Advanced Features

Implements high-performance vector search, distributed QUIC synchronization, and multi-database management for advanced AI systems.

AgentDB Vector Search

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

AgentDB Advanced Features

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

Postgres Query Optimization

Optimizes PostgreSQL database performance by analyzing execution plans, identifying bottlenecks, and implementing advanced indexing strategies.

Sequelize Model Expert

Standardizes Sequelize ORM model definitions and best practices for high-performance PostgreSQL implementations.

Hostinger VPS Database Manager

Manages shared PostgreSQL, Redis, and MongoDB instances on Hostinger VPS infrastructure via Docker commands.

Mozilla BigQuery Query Writer

Writes cost-optimized, high-performance BigQuery queries for Mozilla telemetry and Firefox metrics.

Database Migration Expert

Executes seamless database schema transitions and data transformations across multiple ORMs with zero-downtime and rollback strategies.