Database Management Agent Skills

SQL Query Expert

Writes, optimizes, and translates performant SQL queries across major data warehouse dialects like Snowflake, BigQuery, and PostgreSQL.

Database Designer

Optimizes database schemas, index strategies, and migration workflows for scalable and performant data architectures.

Qdrant Vector Search

Manages high-performance vector similarity search and scalable storage for production RAG and semantic search systems.

Airtable Automation

Automates Airtable database operations including record management, schema design, and workflow integration via Rube MCP.

Supabase Automation

Automates Supabase database management, schema inspection, and project administration through integrated MCP tools.

Multigres Local Cluster Manager

Manages local Multigres cluster components, service lifecycles, and S3 backup workflows directly through Claude.

Azure Cosmos DB for Rust

Simplifies building globally distributed applications using the Azure Cosmos DB NoSQL API and the official Rust SDK.

Azure Cosmos DB Java SDK

Streamlines Azure Cosmos DB NoSQL operations in Java applications using synchronous and reactive programming patterns.

Azure Cosmos DB for Python

Simplifies interaction with Azure Cosmos DB NoSQL API using the official Python SDK for document management and querying.

Azure Cosmos DB for Python

Implements production-grade Azure Cosmos DB NoSQL service layers for Python and FastAPI applications using best-practice architecture.

Azure Cosmos DB TypeScript SDK

Streamlines Azure Cosmos DB NoSQL operations using the official TypeScript SDK for document management, SQL queries, and bulk data processing.

Azure PostgreSQL Manager

Configure and manage Azure Database for PostgreSQL with a focus on passwordless Entra ID authentication and secure access control.

Azure PostgreSQL for TypeScript

Connects Node.js and TypeScript applications to Azure Database for PostgreSQL with support for secure Entra ID authentication and high-performance connection pooling.

Azure MySQL Management (.NET)

Manages Azure MySQL Flexible Server deployments, including server creation, database configuration, and high availability settings using the .NET SDK.

Azure Tables Python SDK

Manages Azure Storage Tables and Cosmos DB Table API using the Python SDK for high-performance NoSQL data storage.

CDC Pipeline Creator

Automates the design and implementation of Change Data Capture (CDC) pipelines for real-time data synchronization and ETL workflows.

Data Catalog Updater

Automates the synchronization and maintenance of metadata across data pipelines, ETL workflows, and storage systems.

pgvector Semantic Search

Implements and optimizes high-performance vector similarity search in PostgreSQL using pgvector for AI and RAG applications.

PostgreSQL Hybrid Text Search

Implements advanced search strategies by combining BM25 keyword matching with semantic vector search using Reciprocal Rank Fusion.

OpenEvidence Migration & EHR Integration

Streamlines migrations from legacy clinical systems to OpenEvidence AI with robust EHR integration patterns.

Unified Database Management

Master document-oriented and relational databases by designing schemas, writing optimized queries, and managing migrations for MongoDB and PostgreSQL.

Supabase Postgres Best Practices

Optimizes PostgreSQL database performance and schema design using Supabase-vetted patterns and expert implementation rules.

Database Design & Optimization

Architects high-performance database schemas, indexing strategies, and zero-downtime migration patterns for SQL and NoSQL systems.

Guidewire Migration Deep Dive

Provides comprehensive guidance and implementation patterns for migrating Guidewire InsuranceSuite systems to the cloud or from legacy platforms.

Guidewire Data Handling

Streamlines complex data operations and migrations across Guidewire InsuranceSuite using optimized Gosu and API patterns.

MaintainX Data Handling & ETL

Automates data synchronization, ETL pipelines, and management between MaintainX and external enterprise systems.

Databricks Data Compliance & Lifecycle

Automates Delta Lake data management patterns for GDPR compliance, PII masking, and retention policy enforcement.

Databricks Migration Deep Dive

Orchestrates comprehensive platform migrations from legacy data systems like Hadoop and Snowflake into Databricks using automated assessment and Delta Lake conversion patterns.

Database Migration Manager

Manages database schema migrations with automated guidance for versioning, deployment, and validation across SQL and NoSQL environments.

Convex Backend Development

Streamlines the creation of type-safe Convex backends with optimized schemas, queries, and serverless functions.