database · git:20261031.60324e5 · 2026-10-31 · sha256 d14e0bdbb49e95ec
database git:20261031.60324e5A
Immutable. This exact content never changes and is served at /api/v1/blob/d14e0bdbb49e95ec.
No tool to install first
claude plugin marketplace add https://markdownregistry.com/mp/a/art_2csflbj57x3zpib3/d14e0bdbb49e95eccf077b05febd16ce467b70dc9aa666796c5607eaa1c98924.json
Then /plugin install database@markdownregistry-2csflbj57x3zpib3 in Claude Code. It installs this exact version, the one graded A here, pinned to the commit it was graded at, and leaves it there.
--- name: database description: Use when changing database schemas, migrations, database access, or database package structure. Keeps the Drizzle schema authoritative and migrations generated. --- # Database and migrations Databases default to Drizzle, and the Drizzle schema is the source of truth. Generate migrations from it with `drizzle-kit generate`, and use `drizzle-kit generate --custom` for SQL the schema can't express. Unless a database is private to one app, its schema, migrations, Drizzle config, and scripts live in a dedicated package: `packages/db` for the primary database, and one package per additional database. Effect code accesses PostgreSQL through `@effect/sql-pg`, using the connection helpers from the project's `@<project>/db` package rather than its own `PgClient`. When a process opens more than one pool against the same database, such as an Effect client beside the `pg` pool an auth library uses, their maximum sizes together stay within the role's connection limit in every environment, including pull request previews. Pools can't lend each other idle connections, and a query past a full pool waits while one past the role's limit fails. An integration test saturates every pool at once against a role created with that limit. The canonical justfile owns the local development database (`just dev-db-start`). Don't add a project script or compose file for it. `bun run` doesn't load `.env.local`, so scripts that need `DATABASE_URL` load it explicitly, as in `"db:migrate": "bun --env-file=.env.local drizzle-kit migrate"`.