Database Management Agent Skills

Redis Data & Caching

Optimizes application performance through Redis caching, real-time pub/sub messaging, and distributed data structures.

Backend Migrations

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

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.

Database Tenant & Org Manager

Queries and manages tenant, organization, and factory information within the v3_user database using structured SQL execution.

SQL Optimization Patterns

Optimizes database performance by implementing efficient indexing, query refactoring, and execution plan analysis.

SQL Optimization Patterns

Optimizes SQL database performance through query plan analysis, advanced indexing strategies, and systematic query refactoring.

Data Lake Architect

Designs scalable data lake and lakehouse architectures using optimized partitioning, storage tiers, and high-performance formats like Iceberg and Parquet.

SQL Optimization Patterns

Optimizes database performance through advanced query tuning, indexing strategies, and detailed execution plan analysis.

Database Migration Mastery

Executes complex database migrations and schema transformations across multiple ORMs with a focus on zero-downtime and data integrity.

ActiveRecord for Rails

Manages and optimizes Ruby on Rails database interactions through expert ActiveRecord guidance and implementation patterns.

Rails Migrations

Streamlines database schema management and ActiveRecord migration workflows for Ruby on Rails applications.

Snowflake Query Execution

Executes SQL queries against Snowflake data warehouses with support for multiple authentication methods and flexible output formats.

V3 Memory Unification & AgentDB Integration

Unifies disparate AI memory systems into a high-performance AgentDB backend with HNSW vector search for massive retrieval speedups.

Bulk Static Data Sync

Optimizes high-volume data synchronization from external APIs to databases using multi-row insert patterns and foreign key pre-filtering.

AgentDB Advanced Features

Optimizes AgentDB implementations with advanced capabilities like QUIC synchronization, hybrid search, and distributed database management.

AgentDB Advanced Features

Optimizes distributed AI systems with low-latency QUIC synchronization, hybrid vector search, and advanced multi-database management.

Database Design Patterns

Implements industry-standard database design patterns, indexing strategies, and migration best practices for optimized data persistence.

SQL Performance Optimizer

Optimizes SQL query performance by applying proven patterns for indexing, JOIN structures, and execution plan analysis.

DataFusion Query Advisor

Optimizes Apache DataFusion SQL queries and DataFrame operations through advanced performance analysis and best practices.

Supabase CRUD Operations

Generates production-ready CRUD operations for Supabase tables with built-in error handling, type safety, and RLS awareness.

SQL Optimization Patterns

Optimizes database performance through advanced indexing strategies, query plan analysis, and efficient data retrieval patterns.

Supabase Schema Designer

Designs production-ready, normalized database schemas with relationships, constraints, and Row Level Security specifically for Supabase.

Rust Parquet Optimization

Optimizes Parquet file operations in Rust to improve query performance, reduce storage costs, and prevent memory issues.

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 Advanced Features

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

Database Migration

Executes database schema and data migrations across multiple ORMs with zero-downtime strategies and rollback procedures.

Backend Queries

Constructs optimized and secure database queries using parameterized statements, eager loading, and efficient indexing strategies.

T-SQL Pro & Database Optimization

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