AI database schema generator

Every app, mapped into tables.

Describe your app in plain English and Kozo designs a normalized, indexed, migration-ready Postgres schema with a live ER diagram in seconds.

Generate a schema Check the score

Free to start. No credit card.

Schemasmarketplace.sql

Describe your app

Generating

3 tables · 17 columns · 2 relations

users5 col

PKiduuid

UQemailtext

full_nametext

is_makerboolean

created_attimestamptz

products7 col

PKiduuid

FKmaker_iduuid

titletext

UQslugtext

price_centsinteger

stockinteger

created_attimestamptz

orders5 col

PKiduuid

FKbuyer_iduuid

statustext

total_centsinteger

created_attimestamptz

Drag to explore

100%

Schema health

Auditing 3 of 5 tables

100/100

Ready to migrate

100 − penalty1893

Normalization100 − 0100

Integrity100 − 0100

Performance100 − 0100

(100 + 100 + 100) ÷ 3 = 100 → A

Health audit

A health score you can check.

Kozo audits every table for a primary key, timestamps, an index on each foreign key and a unique constraint on natural keys. Each finding comes with the SQL that fixes it. Apply them to the team chat schema and the real audit scores it again.

8 findings · 0 fixed

Errorchannel_membersIntegrity −18
Table has no primary key.
PRIMARY KEY (channel_id, user_id)
Warningusers.workspace_idPerformance −9
Foreign key "workspace_id" is not indexed — joins and lookups will scan.
CREATE INDEX idx_users_workspace_id ON users (workspace_id);
Warningusers.usernameNormalization −9
"username" looks like a natural key but has no UNIQUE constraint.
username TEXT NOT NULL UNIQUE
Warningchannel_members.user_idPerformance −9
Foreign key "user_id" is not indexed — joins and lookups will scan.
CREATE INDEX idx_channel_members_user_id ON channel_members (user_id);
Warningmessages.author_idPerformance −9
Foreign key "author_id" is not indexed — joins and lookups will scan.
CREATE INDEX idx_messages_author_id ON messages (author_id);
Warningmessages.parent_idPerformance −9
Foreign key "parent_id" is not indexed — joins and lookups will scan.
CREATE INDEX idx_messages_parent_id ON messages (parent_id);
Notechannel_membersIntegrity −3
No created_at / updated_at timestamps.
created_at TIMESTAMPTZ NOT NULL DEFAULT now()
NotereactionsIntegrity −3
No created_at / updated_at timestamps.
created_at TIMESTAMPTZ NOT NULL DEFAULT now()

Export

Every format you ship.

The same schema as Postgres, MySQL, Prisma, Drizzle, SQLAlchemy or JSON Schema, plus Supabase row-level security policies. Each file here comes from Kozo’s own converters, run on the sample you pick.

5 tables · 6 relations · 7 files

marketplace/marketplace.sql

 1CREATE TABLE users ( 2  id          UUID PRIMARY KEY DEFAULT gen_random_uuid(), 3  email       TEXT NOT NULL UNIQUE, 4  full_name   TEXT NOT NULL, 5  is_maker    BOOLEAN NOT NULL DEFAULT false, 6  created_at  TIMESTAMPTZ NOT NULL DEFAULT now() 7); 8 9CREATE TABLE products (10  id           UUID PRIMARY KEY DEFAULT gen_random_uuid(),11  maker_id     UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,12  title        TEXT NOT NULL,13  slug         TEXT NOT NULL UNIQUE,14  price_cents  INTEGER NOT NULL CHECK (price_cents >= 0),15  stock        INTEGER NOT NULL DEFAULT 0,16  created_at   TIMESTAMPTZ NOT NULL DEFAULT now()17);1819CREATE TABLE orders (20  id           UUID PRIMARY KEY DEFAULT gen_random_uuid(),21  buyer_id     UUID NOT NULL REFERENCES users(id),22  status       TEXT NOT NULL DEFAULT 'pending',23  total_cents  INTEGER NOT NULL DEFAULT 0,24  created_at   TIMESTAMPTZ NOT NULL DEFAULT now()25);2627CREATE TABLE order_items (28  id          UUID PRIMARY KEY DEFAULT gen_random_uuid(),29  order_id    UUID NOT NULL REFERENCES orders(id) ON DELETE CASCADE,30  product_id  UUID NOT NULL REFERENCES products(id),31  quantity    INTEGER NOT NULL CHECK (quantity > 0),32  unit_cents  INTEGER NOT NULL33);3435CREATE TABLE reviews (36  id          UUID PRIMARY KEY DEFAULT gen_random_uuid(),37  product_id  UUID NOT NULL REFERENCES products(id) ON DELETE CASCADE,38  author_id   UUID NOT NULL REFERENCES users(id),39  rating      SMALLINT NOT NULL CHECK (rating BETWEEN 1 AND 5),40  body        TEXT,41  created_at  TIMESTAMPTZ NOT NULL DEFAULT now()42);4344CREATE INDEX idx_products_maker ON products (maker_id);45CREATE INDEX idx_orders_buyer ON orders (buyer_id);46CREATE INDEX idx_order_items_order ON order_items (order_id);47CREATE INDEX idx_order_items_product ON order_items (product_id);48CREATE INDEX idx_reviews_product ON reviews (product_id);

PostgreSQL48 lines

Migrations and seed data

Up, down, and rows to test with.

Every schema ships with a reversible migration and seed rows. The down file drops tables in reverse foreign-key order, and the seed fills them in key order, so every reference points at a row that exists.

Seed order

Down drops

0001_marketplace.up.sql

 1-- Up migration 2BEGIN; 3 4CREATE TABLE users ( 5  id          UUID PRIMARY KEY DEFAULT gen_random_uuid(), 6  email       TEXT NOT NULL UNIQUE, 7  full_name   TEXT NOT NULL, 8  is_maker    BOOLEAN NOT NULL DEFAULT false, 9  created_at  TIMESTAMPTZ NOT NULL DEFAULT now()10);1112CREATE TABLE products (13  id           UUID PRIMARY KEY DEFAULT gen_random_uuid(),14  maker_id     UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,15  title        TEXT NOT NULL,16  slug         TEXT NOT NULL UNIQUE,17  price_cents  INTEGER NOT NULL CHECK (price_cents >= 0),18  stock        INTEGER NOT NULL DEFAULT 0,19  created_at   TIMESTAMPTZ NOT NULL DEFAULT now()20);2122CREATE TABLE orders (23  id           UUID PRIMARY KEY DEFAULT gen_random_uuid(),24  buyer_id     UUID NOT NULL REFERENCES users(id),25  status       TEXT NOT NULL DEFAULT 'pending',26  total_cents  INTEGER NOT NULL DEFAULT 0,27  created_at   TIMESTAMPTZ NOT NULL DEFAULT now()28);2930CREATE TABLE order_items (31  id          UUID PRIMARY KEY DEFAULT gen_random_uuid(),32  order_id    UUID NOT NULL REFERENCES orders(id) ON DELETE CASCADE,33  product_id  UUID NOT NULL REFERENCES products(id),34  quantity    INTEGER NOT NULL CHECK (quantity > 0),35  unit_cents  INTEGER NOT NULL36);3738CREATE TABLE reviews (39  id          UUID PRIMARY KEY DEFAULT gen_random_uuid(),40  product_id  UUID NOT NULL REFERENCES products(id) ON DELETE CASCADE,41  author_id   UUID NOT NULL REFERENCES users(id),42  rating      SMALLINT NOT NULL CHECK (rating BETWEEN 1 AND 5),43  body        TEXT,44  created_at  TIMESTAMPTZ NOT NULL DEFAULT now()45);4647CREATE INDEX idx_products_maker ON products (maker_id);48CREATE INDEX idx_orders_buyer ON orders (buyer_id);49CREATE INDEX idx_order_items_order ON order_items (order_id);50CREATE INDEX idx_order_items_product ON order_items (product_id);51CREATE INDEX idx_reviews_product ON reviews (product_id);5253COMMIT;

0001_marketplace.down.sql

1-- Down migration2DROP TABLE IF EXISTS order_items CASCADE;3DROP TABLE IF EXISTS reviews CASCADE;4DROP TABLE IF EXISTS products CASCADE;5DROP TABLE IF EXISTS orders CASCADE;6DROP TABLE IF EXISTS users CASCADE;

Why this order

order_items references orders and products, so it is dropped first. users references no other table, so it goes last. Seeding runs the same list the other way round.

Rows per table3

Seed rows for users: 3 rows
#	PKiduuid	emailtext	full_nametext	is_makerboolean	created_attimestamptz
1	2124ee87…	ava.chen@example.com	Ava Chen	true	now() - interval '0 days'
2	2124ee88…	liam.patel@example.com	Liam Patel	false	now() - interval '1 days'
3	2124ee89…	noah.garcia@example.com	Noah Garcia	true	now() - interval '2 days'

users references no other table, so its rows go in first.

Templates

Start from a template.

Pick the shape closest to your app, then describe what is different. Each template is drawn from the schema in Kozo’s template library.

Kozo's central glass cube and its four linked cubes glowing on a desk at night

Your workspace

Every schema, kept with its history.

Library: Every schema keeps the prompt that made it, its diagram, its health score and every export.
Versions: Each change is kept as a version with a note on what changed, so you can see how the design got here.
Import: Paste the DDL you already have to see it as a diagram and run the same health audit on it.
History: Every schema you have generated or saved, newest first and grouped by day.

Your schemas are scoped to your account and encrypted at rest, and we never use your content to train models. Kozo works from your descriptions and DDL only.

Pricing

Start free. Upgrade when it ships.

Generate schemas and explore the diagram on the free plan. Pro adds every export format, health scoring, migrations, seed data and saved history. Teams that need single sign-on or self-hosting talk to us.

What each plan includes
Generate schemas and explore the diagram on the free plan. Pro adds every export format, health scoring, migrations, seed data and saved history. Teams that need single sign-on or self-hosting talk to us. Compare plans	Free$0foreverGet startedStart free	ProRecommended$15per monthFor developers who shipStart with Pro	EnterpriseCustomFor organizationsTalk to us
Schemas from plain English	Included	Unlimited	Unlimited
Live ER diagram	Included	Included	Included
Export formats	Core	Every format	Every format
Health scoring	Not included	Included	Included
Migrations and seed data	Not included	Included	Included
Supabase RLS export	Not included	Included	Included
Saved history	Not included	Included	Included
Single sign-on	Not included	Not included	Included
Self-host option	Not included	Not included	Included
Dedicated support	Not included	Not included	Included

Free
$0forever
Get started
- Schemas from plain English
- Live ER diagram
- Export formats · Core
Start free
Pro
Recommended
$15per month
For developers who ship
- Schemas from plain English · Unlimited
- Live ER diagram
- Export formats · Every format
- Health scoring
- Migrations and seed data
- Supabase RLS export
- Saved history
Start with Pro
Enterprise
Custom
For organizations
- Schemas from plain English · Unlimited
- Live ER diagram
- Export formats · Every format
- Health scoring
- Migrations and seed data
- Supabase RLS export
- Saved history
- Single sign-on
- Self-host option
- Dedicated support
Talk to us

Questions

Asked and answered.

Anything else? Ask us directly.

What does Kozo actually generate?

From a plain-English description of your product, Kozo generates a normalized Postgres schema with tables, primary and foreign keys, indexes, and relationships. It also produces a live ER diagram, a schema health score, sample seed data, reversible migrations, and exports for MySQL, Prisma, Drizzle, SQLAlchemy, JSON Schema, and Supabase RLS policies.

How accurate and production-ready is the output?

Kozo aims for normalized, indexed schemas that follow standard relational practices. Every schema is scored across normalization, integrity, and performance with specific findings, so you can review and fix any weak spots before exporting. You always see the full diagram and SQL before committing.

Can I edit the schema or import one I already have?

Yes. You can refine the generated design and re-export at any time. You can also paste existing DDL into Kozo to visualize it as an ER diagram and run the same health audit against a database you already have.

Is my data private?

Your schemas are scoped to your account and encrypted at rest, and we never use your content to train models. Kozo works from your descriptions and DDL only.

How much does Kozo cost?

The Free plan lets you generate schemas, explore the ER diagram, and use core exports with no credit card. Pro is $15 per month for unlimited generations, all export formats, health scoring, migrations, seed data, RLS export, and saved history. Enterprise is custom-priced with SSO, a self-host option, and dedicated support.

How is the health score calculated?

Kozo checks every table for a primary key, created_at or updated_at timestamps, an index on each foreign key and a unique constraint on natural keys such as email, slug and username. Normalization, integrity and performance each start at 100 and lose 18 points per error, 9 per warning and 3 per note. The health score is their average: 90 and up is an A, 80 a B, 70 a C, 60 a D and anything lower an F.

Which formats can I export?

PostgreSQL, MySQL, Prisma, Drizzle, SQLAlchemy and JSON Schema, plus Supabase row-level security policies, an up and down migration and seed data in foreign-key order. The ER diagram downloads as PNG or SVG.

Can I start from a template?

Yes. Start from a SaaS multi-tenant, e-commerce, social feed or analytics template and describe what is different about your app.

One sentence in.Every table out.

Describe your app in plain English and get a normalized Postgres schema, its ER diagram, a health score and exports for your stack. Free to start, no credit card.

Generate a schema Talk to us

Kozo's central glass cube linked to four smaller cubes, lit by a white beam

1CREATE TABLE users ( 2 id UUID PRIMARY KEY DEFAULT gen_random_uuid(), 3 email TEXT NOT NULL UNIQUE, 4 full_name TEXT NOT NULL, 5 is_maker BOOLEAN NOT NULL DEFAULT false, 6 created_at TIMESTAMPTZ NOT NULL DEFAULT now() 7); 8 9CREATE TABLE products (10 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),11 maker_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,12 title TEXT NOT NULL,13 slug TEXT NOT NULL UNIQUE,14 price_cents INTEGER NOT NULL CHECK (price_cents >= 0),15 stock INTEGER NOT NULL DEFAULT 0,16 created_at TIMESTAMPTZ NOT NULL DEFAULT now()17);1819CREATE TABLE orders (20 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),21 buyer_id UUID NOT NULL REFERENCES users(id),22 status TEXT NOT NULL DEFAULT 'pending',23 total_cents INTEGER NOT NULL DEFAULT 0,24 created_at TIMESTAMPTZ NOT NULL DEFAULT now()25);2627CREATE TABLE order_items (28 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),29 order_id UUID NOT NULL REFERENCES orders(id) ON DELETE CASCADE,30 product_id UUID NOT NULL REFERENCES products(id),31 quantity INTEGER NOT NULL CHECK (quantity > 0),32 unit_cents INTEGER NOT NULL33);3435CREATE TABLE reviews (36 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),37 product_id UUID NOT NULL REFERENCES products(id) ON DELETE CASCADE,38 author_id UUID NOT NULL REFERENCES users(id),39 rating SMALLINT NOT NULL CHECK (rating BETWEEN 1 AND 5),40 body TEXT,41 created_at TIMESTAMPTZ NOT NULL DEFAULT now()42);4344CREATE INDEX idx_products_maker ON products (maker_id);45CREATE INDEX idx_orders_buyer ON orders (buyer_id);46CREATE INDEX idx_order_items_order ON order_items (order_id);47CREATE INDEX idx_order_items_product ON order_items (product_id);48CREATE INDEX idx_reviews_product ON reviews (product_id);

1-- Up migration 2BEGIN; 3 4CREATE TABLE users ( 5 id UUID PRIMARY KEY DEFAULT gen_random_uuid(), 6 email TEXT NOT NULL UNIQUE, 7 full_name TEXT NOT NULL, 8 is_maker BOOLEAN NOT NULL DEFAULT false, 9 created_at TIMESTAMPTZ NOT NULL DEFAULT now()10);1112CREATE TABLE products (13 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),14 maker_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,15 title TEXT NOT NULL,16 slug TEXT NOT NULL UNIQUE,17 price_cents INTEGER NOT NULL CHECK (price_cents >= 0),18 stock INTEGER NOT NULL DEFAULT 0,19 created_at TIMESTAMPTZ NOT NULL DEFAULT now()20);2122CREATE TABLE orders (23 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),24 buyer_id UUID NOT NULL REFERENCES users(id),25 status TEXT NOT NULL DEFAULT 'pending',26 total_cents INTEGER NOT NULL DEFAULT 0,27 created_at TIMESTAMPTZ NOT NULL DEFAULT now()28);2930CREATE TABLE order_items (31 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),32 order_id UUID NOT NULL REFERENCES orders(id) ON DELETE CASCADE,33 product_id UUID NOT NULL REFERENCES products(id),34 quantity INTEGER NOT NULL CHECK (quantity > 0),35 unit_cents INTEGER NOT NULL36);3738CREATE TABLE reviews (39 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),40 product_id UUID NOT NULL REFERENCES products(id) ON DELETE CASCADE,41 author_id UUID NOT NULL REFERENCES users(id),42 rating SMALLINT NOT NULL CHECK (rating BETWEEN 1 AND 5),43 body TEXT,44 created_at TIMESTAMPTZ NOT NULL DEFAULT now()45);4647CREATE INDEX idx_products_maker ON products (maker_id);48CREATE INDEX idx_orders_buyer ON orders (buyer_id);49CREATE INDEX idx_order_items_order ON order_items (order_id);50CREATE INDEX idx_order_items_product ON order_items (product_id);51CREATE INDEX idx_reviews_product ON reviews (product_id);5253COMMIT;

1-- Down migration2DROP TABLE IF EXISTS order_items CASCADE;3DROP TABLE IF EXISTS reviews CASCADE;4DROP TABLE IF EXISTS products CASCADE;5DROP TABLE IF EXISTS orders CASCADE;6DROP TABLE IF EXISTS users CASCADE;

PKiduuid

emailtext

full_nametext

is_makerboolean

created_attimestamptz

2124ee87…

ava.chen@example.com

Ava Chen

true

now() - interval '0 days'

2124ee88…

liam.patel@example.com

Liam Patel

false

now() - interval '1 days'

2124ee89…

noah.garcia@example.com

Noah Garcia

true

now() - interval '2 days'