Schema Atlas - Database Architecture Studio

Schema Atlas is a responsive, local-first Next.js App Router application built for developers and database architects to design, inspect, and export database schemas visually.

It provides an interactive node canvas supporting model creation, field editing, data types, nullability, primary and foreign keys, model directives, and automatic relationship handle routing.

Designed for privacy and speed, all modifications run local-first in the browser, with seamless bi-directional synchronization between Prisma schema definitions, PostgreSQL SQL statements, and portable JSON workspaces.

• Engineered an infinite canvas with pan, zoom, minimap, grid snapping, and Dagre automated hierarchical graph layout.
• Built bi-directional parsers for Prisma schema (schema.prisma) and PostgreSQL CREATE TABLE DDL.
• Implemented visual foreign key linking via drag-and-drop relationship handles with referential action configuration.
• Created zero-dependency workspace export/import preserving visual layout positions and model attributes.

Visual Entity-Relationship Canvas

Interactive pan, zoom, minimap, grid snap, and Dagre automatic hierarchical layout for complex database architectures.

Bi-Directional Schema Synchronization

Import and export Prisma schema (.prisma), PostgreSQL CREATE TABLE SQL, and portable workspace JSON.