uuid
email text
created_at timestamptz
Open source database modeling for builders
Design Postgres and Supabase schemas visually.
DB Open Studio turns database structure into a clear canvas. Import a real schema, design tables and relationships, compare changes, and generate SQL migrations you can review before running anything in production.
Open source
Good database design should be within reach for every team.
DB Open Studio is open source so developers can inspect it, run it locally, adapt it to their workflow and contribute improvements. Use it freely for your own projects, fork it, extend it or help build a better visual database design tool for the community.
Database design workflow
Built for schema understanding, visual ERD design and migration review.
Use it as a Postgres schema designer, Supabase ERD tool, visual database modeler, SQL migration generator and architecture review surface for application teams.
Import Postgres schemas
Capture tables, columns, primary keys, foreign keys and indexes from Supabase or any reachable Postgres database.
Design relationships visually
Arrange tables across views, connect foreign keys, inspect columns and keep large schemas understandable.
Generate SQL migrations
Compare imported snapshots with the target visual model and produce migration SQL with risk warnings.
Run locally or with Supabase
Start with local JSON storage, then move to Supabase Auth and Supabase Postgres persistence when you need users.
How it works
From existing schema to reviewed migration.
- ImportConnect to Supabase or Postgres and take a schema snapshot.
- ModelOrganize views, edit tables, add columns and create relationships visually.
- CompareReview exactly what changed between the snapshot and your target model.
- GenerateExport SQL migrations and apply them in your own deployment workflow.
Optional AI assistant
Use AI for design proposals and migration explanations.
The AI assistant can propose tables, complete columns, repair missing relationships, summarize migration impact and highlight manual checks. It is optional and runs only when configured with an OpenAI API key.
Example prompts
Add billing tables and connect them to customers.
Review this migration for destructive risk.
Explain which relationships changed.
Quick start
Clone, install and run locally.
With an empty `.env.local`, DB Open Studio runs with local JSON persistence. No Supabase, Postgres, SMTP or OpenAI setup is required for a first run.
git clone git@github.com:victorlr7/db-open-studio.git
cd db-open-studio
npm install
cp .env.example .env.local
npm run devDeployment options
