Next.js with Drizzle ORM and Liam ERD

A boilerplate demonstrating how to integrate Liam with Drizzle ORM in a Next.js application to automatically generate Entity Relationship Diagrams (ERD) for your PostgreSQL database.

This example provides a clean and practical setup to visualize your data model directly from your TypeScript schema, streamlining both development and documentation.

Features

Next.js App Router for a modern full-stack structure.
Drizzle ORM for type-safe and lightweight database access.
PostgreSQL as the relational database.
Liam integration for automatic ERD generation from Drizzle schema.
CLI setup to export diagrams as .png or .svg.
Modular structure with a dedicated db package.
TypeScript for safety and maintainability.

Technical Stack

Frontend: Next.js (App Router)
Backend: Next.js API Routes
Database: PostgreSQL + Drizzle ORM
Visualization: Liam (ERD Generator)
Language: TypeScript
Structure: Monorepo with packages/db

Use Case

Perfect for developers who want visual clarity of their database schema while keeping their workflow inside the TypeScript + Drizzle ORM ecosystem.

Ideal for:

SaaS and internal tools with complex data models
Teams needing quick database documentation
Developers who want a visual model to validate relationships

By combining Next.js, Drizzle ORM, and Liam, this boilerplate delivers a powerful and developer-friendly setup for building, documenting, and maintaining scalable database-backed applications. 🚀

Boilerplate