neon-database-architect — Claude Code subagent for Neon and Drizzle

What neon-database-architect does

The subagent starts by scanning your project: it looks for drizzle.config.*, schema and migration files, and greps for DATABASE_URL, drizzle and neon. From there it proposes concrete changes — table structure, migrations, cold-start optimizations.

Its technical standards cover the neon-http Drizzle adapter, DATABASE_URL from environment variables, normalized schemas with Postgres types like JSONB, arrays and enums, plus indexes and constraints. Repeated queries become prepared statements, inserts become batch operations. Transaction examples and a connection-error wrapper are included too.

It runs with Read, Write, Edit, Bash, Grep and Glob, so it reads and edits files in your repo directly. You need @neondatabase/serverless, drizzle-orm and drizzle-kit installed, and a connection string in DATABASE_URL. On a project that does not use Neon and Drizzle, there is nothing here for it to do — worth checking your stack first.