Databases Agent Skills for Claude Desktop

Automate Airtable tasks via Rube MCP (Composio): records, bases, tables, fields, views.

MUST use when writing BigQuery queries.

Use when reviewing BigQuery spend, query failure patterns, or scan inefficiencies -- identifying which jobs, users, or projects drive…

bmorphism Video Archive Interleave

Bootstrap a brand-new dbt data product from scratch — create dbt_project.yml, the Entropy Data model layout (input_ports, staging…

Patterns for designing database schemas with proper normalization and relationships

Use when integrating Drizzle ORM with Bun's SQLite driver for type-safe schema definitions and migrations.

Design a caching strategy for an application — pattern selection, key design, TTL, and eviction policy.

Database capacity and growth planning. Storage growth estimation, IOPS requirements, memory sizing (buffer pool, shared_buffers)…

Generates complete CRUD module from database table definition.

CatColab Ologs (Ontology Logs) - category-theoretic knowledge representation where objects are concepts and morphisms are functional…

Use when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases…

Build a Clari forecast export pipeline to your data warehouse.

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

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.