Databases Agent Skills

| Type-safe ORM for Cloudflare D1 databases using Drizzle.

Drizzle ORM changes since training cutoff (latest: 1.0.0-beta.19) — consolidated validator imports, Effect Schema support, node-sqlite…

Generate a drt sync YAML configuration file.

Run SQL queries against the attached DuckDB database or ad-hoc against files.

Make data actually survive a crash — what fsync guarantees and what it does not, why a successful write() means nothing, the directory…

Orchestrator for the DynamoDB single-table design pipeline.

Designs a DynamoDB single-table structure from a documented set of access patterns.

Creates Ecotone business interfaces (gateways): DBAL query interfaces with #[DbalBusinessMethod], repository abstractions, expression…

Implements event sourcing in Ecotone: #[Projection] with partitioning and streaming, EventStore configuration, event versioning/upcasting…

Guide for Ecto schemas, changesets, queries, migrations, and Multi.

Use when a resource needs multiple changesets (registration vs update), conditional validation, field transforms, or uniqueness validation…

Use when a form or operation manages parent and child records together — cast_assoc/cast_embed, on_replace, Ecto.Multi across tables, FK…

Use when querying data with Ecto.Query DSL including where clauses, joins, aggregates, preloading, and query composition.

Use when defining data structures using Ecto schemas including fields, associations, embedded schemas, and schema metadata.

Edit an output-port ODCS file under models/output_ports/v<N>/, run the contract test against the live data, and classify any failures as…

This skill provides a comprehensive guide to implementing the data persistence layer using Entity Framework Core as an adapter in a…

Use when Elixir Ecto patterns including schemas, changesets, queries, and transactions.

Help museum insect curators bulk upload specimen data to the Emu database.

Guides you through defining a new Honeydew entity from a data warehouse source — covering source type, granularity key, and initial…

Automate Google BigQuery tasks via Rube MCP (Composio): run SQL queries, explore datasets and metadata, execute MBQL queries via Metabase…

Automate Prisma tasks via Rube MCP (Composio).