Database Management Agent Skills

Firestore Platform Specialist

Architects and optimizes Firebase Firestore implementations with advanced NoSQL patterns, real-time synchronization, and robust security rules.

AgentDB Advanced Features

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

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.

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.

Supabase Database Expert

Architects, queries, and manages production-grade Supabase environments with PostgreSQL, Row Level Security, and Edge Functions.

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.

Data Lake Architect

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

SQLModel Task Data Modeling

Architects robust, type-safe, and asynchronous database schemas for task-based applications using SQLModel and PostgreSQL.

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.

InterSystems IRIS DTL Transformations

Guides the development, testing, and implementation of Data Transformation Language (DTL) for InterSystems IRIS interoperability productions.

Rust Parquet Optimization

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

Drizzle Schema & Migration Manager

Standardizes and automates the Drizzle ORM schema management, migration generation, and database seeding workflow.

Drizzle ORM Workflow Manager

Manages Drizzle ORM and drizzle-kit workflows including migrations, schema generation, and specialized database reset flows.

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.

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.

ClickHouse Analytics & Data Engineering

Implements high-performance ClickHouse database patterns, query optimizations, and data engineering best practices for analytical workloads.

MySQL Database Skill

Executes safe SELECT queries against MySQL and MariaDB databases with built-in connection pooling and SQL injection prevention.

SQL Batching

Prevents D1/SQLite 'too many SQL variables' errors by automatically batching Drizzle ORM queries with dynamic arrays.

AgentDB Vector Search

Implements high-performance semantic vector search and document retrieval with sub-millisecond latency for intelligent RAG systems.

AgentDB Performance Optimization

Optimizes AgentDB vector database performance through quantization, HNSW indexing, and advanced caching strategies.

Backend Queries

Optimizes and secures database interactions by implementing efficient query patterns, preventing security vulnerabilities, and managing data performance.

Supabase RLS Policy Generator

Generates secure, production-ready Row-Level Security (RLS) policies for Supabase databases using multi-tenant and role-based access patterns.

Devops Database

Manages PostgreSQL database operations including Alembic migrations, backups, restorations, and pgvector extension management for development and production environments.