Database Management Agent Skills

Meilisearch Search Patterns

Implements high-performance full-text search using Meilisearch patterns for indexing, filtering, and multi-tenant search.

PlanetScale Serverless MySQL

Integrates PlanetScale's serverless MySQL platform using edge-compatible drivers and automated branching workflows.

Vercel KV & Upstash Redis

Implements serverless, edge-compatible Redis patterns using Upstash REST API with automatic JSON serialization and optimized batching.

Elasticsearch Patterns & Search DSL

Implements high-performance search and analytics using Elasticsearch with best practices for mappings, bulk operations, and vector search.

Redis Patterns & Optimization

Implements high-performance Redis patterns for caching, session management, rate limiting, and background job processing.

Qdrant Vector Database Integration

Manages Qdrant vector database operations including collection management, high-performance similarity search, and advanced payload filtering.

Mongoose ODM & MongoDB Patterns

Implement robust MongoDB data modeling with Mongoose, featuring schema-driven validation, middleware hooks, and optimized TypeScript type inference.

Sequelize ORM Database Management

Architects and manages SQL databases using the Sequelize ORM with type-safe model definitions and robust transaction handling.

MongoDB & Mongoose Database Patterns

Implements optimized MongoDB database layers using Mongoose ODM with full TypeScript support, schema validation, and high-performance aggregation pipelines.

Pinecone Vector Database Integration

Manages Pinecone serverless vector databases for semantic search, RAG retrieval, and high-performance vector operations.

Weaviate Vector Database Integration

Implements high-performance vector search and RAG patterns using the Weaviate TypeScript v3 client.

MySQL Database (mysql2)

Integrates high-performance MySQL database operations using the mysql2 driver with support for connection pooling, transactions, and typed queries.

Upstash Serverless Redis & QStash

Integrates Upstash serverless Redis and QStash for high-performance edge computing, rate limiting, and background jobs.

Gel (EdgeDB) Database Management

Manages graph-relational database schemas, migrations, and type-safe queries using the Gel (formerly EdgeDB) ecosystem.

Vercel Postgres Integration

Facilitates secure and efficient Serverless PostgreSQL operations on Vercel using the edge-compatible SDK.

Dremio Access Auditor

Audits and traces dataset permissions, role inheritance, and effective user access levels within Dremio environments.

Dremio Cloud Setup

Configures and verifies the Dremio developer CLI to enable seamless data querying and catalog management within Claude Code.

Dremio Query Optimizer

Diagnoses and optimizes slow Dremio queries using job profiles, reflection analysis, and execution plan inspection.

Dremio dbt Integration

Automates the setup and management of dbt-dremio for data transformations on Dremio Cloud.

Dremio Cloud SQL & Management

Streamlines Dremio Cloud operations by providing specialized SQL references, system table insights, and REST API implementation patterns.

Dremio Data Quality Investigator

Performs automated data quality audits including null analysis, duplicate detection, and anomaly screening for Dremio Cloud datasets.

Onboard New Dremio Source

Streamlines the discovery, documentation, performance optimization, and security configuration of new data sources in Dremio.

PostgreSQL Database Integration

Implements high-performance, secure PostgreSQL database interactions using node-postgres (pg) with a focus on connection pooling and transaction safety.

PostgreSQL Schema Expert

Accesses and analyzes PostgreSQL database structures using efficient grep lookups to inform precise code implementation.

PostGIS Spatial Database

Enforces PostGIS 3.6.1 best practices for managing complex geographic data, spatial queries, and advanced geometry operations.

Kysely SQL Converter

Converts raw SQL queries into type-safe Kysely TypeScript code to streamline database layer development.

Database Design Patterns

Optimizes database architectures through expert schema design, query tuning, and scalable persistence patterns for SQL and NoSQL environments.

AI Data Modeler

Generates comprehensive entity model documentation featuring Mermaid.js ER diagrams and standardized attribute tables.

Supabase Realtime

Enable real-time data synchronization and event listening for Supabase applications directly within your development environment.

Supabase Local Development

Streamlines the setup and management of local Supabase environments for faster, offline-ready full-stack development.