Skill

role-backend:database-implementation

Implements database layers using Prisma, Drizzle ORM, TypeORM, SQLAlchemy 2.0, GORM, Diesel, Entity Framework Core 8, Hibernate/Panache, ActiveRecord, Ecto, Sequelize, Kysely, and Knex. Covers migrations, connection pooling, read replicas, query optimization, transaction management, and database testing with Testcontainers and factories. Use when setting up database access, writing migrations, optimizing queries, or configuring connection pools.

Install

npx claudepluginhub rnavarych/alpha-engineer --plugin role-backend

Tool Access

This skill is limited to using the following tools:

ReadGrepGlobBash

Preview

- Setting up a new data access layer and choosing an ORM or query builder

Supporting Assets

references/migrations-pooling-replicas.mdreferences/orm-selection.mdreferences/polyglot-orm-patterns.mdreferences/prisma-drizzle-patterns.mdreferences/testing-seeding.md

SKILL.md

Similar Skills

skill-lookup

Searches, retrieves, and installs Agent Skills from prompts.chat registry using MCP tools like search_skills and get_skill. Activates for finding skills, browsing catalogs, or extending Claude.

prompts.chat

157.6k

prompt-lookup

Searches prompts.chat for AI prompt templates by keyword or category, retrieves by ID with variable handling, and improves prompts via AI. Use for discovering or enhancing prompts.

prompts.chat

157.6k

accessibility

Designs, implements, and audits WCAG 2.2 AA accessible UIs for Web (ARIA/HTML5), iOS (SwiftUI traits), and Android (Compose semantics). Audits code for compliance gaps.

everything-claude-code

156.2k

Stats

Parent Repo Stars9

Parent Repo Forks0

Last CommitMar 3, 2026

Actions

View Source View Plugin View on GitHub View README

role-backend:database-implementation

When to use

Setting up a new data access layer and choosing an ORM or query builder

Writing migrations for schema changes

Implementing transactions across multiple tables or services

Configuring connection pooling for production

Adding read replica routing for query scaling

Optimizing slow queries (N+1, missing indexes, full scans)

Writing database integration tests with Testcontainers

Setting up factories or seed data

Core principles

ORM is a tool, SQL is the truth — know what queries your ORM generates; use EXPLAIN ANALYZE

Migrations are immutable contracts — never modify a migration applied to any shared environment

Pooling is not optional — one connection per request = death in production

Transactions stay short — locks held across network calls cause cascading timeouts

Test against the real database — in-memory SQLite mocks hide Postgres-specific bugs

Reference Files

references/orm-selection.md — comparison tables for all ORMs and query builders across Node.js, Python, Go, Rust, JVM, Ruby, Elixir, and .NET; pick before writing any data layer code

references/prisma-drizzle-patterns.md — Prisma schema definition, interactive transactions, raw queries, client extensions, Accelerate caching, Pulse change streams; Drizzle schema, relations, queries, and Kit migrations

references/polyglot-orm-patterns.md — production patterns for SQLAlchemy 2.0 async, GORM with hooks and Gen, Diesel compile-time queries, EF Core 8 with interceptors, Ecto changesets and Multi, and Exposed DSL

references/migrations-pooling-replicas.md — migration rules (zero-downtime patterns, idempotency), connection pool sizing per stack, read replica routing, query optimization checklist, and transaction isolation guidelines

references/testing-seeding.md — Testcontainers setup for Node.js/Python/Go, pg_tmp for fast local tests, fishery/factory_boy database factories, and seed script best practices

Database Implementation

When to use

Setting up a new data access layer and choosing an ORM or query builder
Writing migrations for schema changes
Implementing transactions across multiple tables or services
Configuring connection pooling for production
Adding read replica routing for query scaling
Optimizing slow queries (N+1, missing indexes, full scans)
Writing database integration tests with Testcontainers
Setting up factories or seed data

Core principles

ORM is a tool, SQL is the truth — know what queries your ORM generates; use EXPLAIN ANALYZE
Migrations are immutable contracts — never modify a migration applied to any shared environment
Pooling is not optional — one connection per request = death in production
Transactions stay short — locks held across network calls cause cascading timeouts
Test against the real database — in-memory SQLite mocks hide Postgres-specific bugs

Reference Files

references/orm-selection.md — comparison tables for all ORMs and query builders across Node.js, Python, Go, Rust, JVM, Ruby, Elixir, and .NET; pick before writing any data layer code
references/prisma-drizzle-patterns.md — Prisma schema definition, interactive transactions, raw queries, client extensions, Accelerate caching, Pulse change streams; Drizzle schema, relations, queries, and Kit migrations
references/polyglot-orm-patterns.md — production patterns for SQLAlchemy 2.0 async, GORM with hooks and Gen, Diesel compile-time queries, EF Core 8 with interceptors, Ecto changesets and Multi, and Exposed DSL
references/migrations-pooling-replicas.md — migration rules (zero-downtime patterns, idempotency), connection pool sizing per stack, read replica routing, query optimization checklist, and transaction isolation guidelines
references/testing-seeding.md — Testcontainers setup for Node.js/Python/Go, pg_tmp for fast local tests, fishery/factory_boy database factories, and seed script best practices