Drizzle

This is a strict Drizzle ORM style guide for a Postgres project, specifically LobeHub's conventions. It enforces the query builder API over the relational API because those `with:` joins generate fragile lateral queries that are hard to debug. You get concrete patterns for schema authoring: how to name tables and columns, spread timestamps, set up foreign keys with cascade deletes, and build junction tables. The guide is opinionated about splitting one-to-many fetches into two separate queries instead of using `db.query.findMany` with nested relations. If you're on a team that's had production issues with auto-generated joins or needs everyone writing queries the same way, this codifies those decisions.

Install to Claude Code

npx -y skills add lobehub/lobe-chat --skill drizzle --agent claude-code