Database Architect: a Claude Code agent that designs schemas before you code
adnan_hashmi · x · 2026-11-15
A community-shared Claude Code agent, Database Architect, focuses on up-front database design rather than just generating SQL—aiming to avoid schema mistakes that are painful to fix post-launch.
- Modeling: tables, primary/foreign keys, indexes, constraints
- Engine choices: PostgreSQL, MySQL, MongoDB, vector DBs
- Multi-tenancy: RLS, schema isolation, separate databases
- Performance: read/write patterns, sharding, scaling plans
- Migrations: scripts with rollback plans
Install via npx claude-code-templates@latest --agent database/database-architect.
The agent's system prompt encodes senior-DBA rules for PostgreSQL 16+: read existing migration conventions and ORM schemas first, pin down facts like table sizes, write rates, tenant boundaries and deploy style, never edit shipped migrations, and test all SQL on a real database before handoff. The author highlights its workflow of analyzing access patterns before designing tables, while cautioning that generated DDL and migrations still need human review, especially for production data changes.
More from coding & agent
- Teknium says his Hermes agents are now far more effective than Claude Code — Teknium · 2026-11-15
- Adobe hands CEO role to Anil Chakravarthy, previews local MCP for Photoshop, Illustrator, Premiere — shashib · 2026-11-15
- Running fully local AI to build a prompt-to-music-video pipeline: a deep walkthrough — julianharris · 2026-11-15
- CodeClimb: a coding agent whose reviewer keeps or reverts GraphRAG tuning experiments — blaizedsouza · 2026-11-15
- Dev ships first Steam game after 15 years, built on custom Rust engine with Claude — schiehll · 2026-11-15
- Open-source flight search MCP tool flags every split ticket as unprotected for agents — Fast_Entrance7839 · 2026-11-15