Databases Agent Skills for Claude Code

- Designing an Elasticsearch index mapping from scratch - Writing Query DSL for full-text search, filtering, or faceted navigation…

MongoDB patterns: schema design, aggregation pipeline, indexes, transactions, Atlas Search, Mongoose vs native driver

Optimizes ClickHouse database schemas, query performance, and high-volume analytical workloads using proven data engineering patterns.

Diagnose and fix the top 15 ClickHouse errors — query failures, insert problems, memory limits, and merge issues.

Run ClickHouse locally with Docker, configure test fixtures, and iterate fast.

Execute ClickHouse schema migrations — ALTER TABLE operations, data migration between engines, versioned migration runners, and…

Run ClickHouse queries for analytics, metrics analysis, and event data exploration.

Design ClickHouse schemas with MergeTree engines, ORDER BY keys, and partitioning.

Production-ready patterns for @clickhouse/client — streaming inserts, typed queries, error handling, and connection management.

Clinical data modeling covering healthcare terminology systems (ICD-10, SNOMED CT, LOINC, RxNorm, CPT, NDC), clinical document…

Provides comprehensive guidance for Huawei Cloud RDS including database creation, configuration, backups, and RDS management.

D1 is Cloudflare's serverless SQLite database — runs at the edge alongside Workers.

Cloudflare Vectorize vector database for semantic search and RAG.

General Correctness rules, Rust patterns, comments, avoiding over-engineering.

Diagnose excessive Codex local SQLite diagnostic log writes with read-only evidence by default.

Cross-product infrastructure for HealthSim — persistence (cohort save/load), identity correlation (SSN-based cross-product linking), and…

Kafka Connect integration expert. Covers source and sink connectors, JDBC, Elasticsearch, S3, Debezium CDC, SMT (Single Message…

Connection pooling and management across all engines.

Pool sizing, connection lifetime, health checks, and resource exhaustion prevention.

Guide to using Convex components for feature encapsulation.

Install Snowflake CLI and Cortex Code CLI.