Which databases are supported?

PostgreSQL (the default and what Chattee deploys), MySQL/MariaDB and SQLite. The SQL and the Prisma schema follow the database you pick, and the ER diagram is drawn from that SQL.

Is the schema normalised?

To third normal form in practice: repeated text values become lookup tables, many-to-many becomes a join table, and calculated values are left out. Deliberate denormalisation for performance is a decision for later.

Can I paste an existing requirements document?

Yes — up to 12,000 characters. A PRD from the PRD generator works well as input.

Yes. No account, no card, no watermark. Each visitor can run a tool a few times an hour; the limit exists only to keep the tools fast for everyone.

What happens to what I type?

Your input is sent to an AI model to produce the result and kept with the result for 90 days so you can come back to it. It is not used to train anything, and result links are unlisted.

Can I use the result outside Chattee?

Of course. Copy it, download it, share the link. "Build this with Chattee" is there if you want the app built, not a condition.

Database Schema Generator

From a description to a normalised schema: entities, relationships, ER diagram, SQL and Prisma.

How it works

edit_note

Describe the app or paste a spec

The more you say about what people do with the data, the better the relationships come out.

account_tree

Get entities and relations

Tables with typed fields, primary and foreign keys, join tables for many-to-many, sensible indexes.

code

Take it in your format

An ER diagram, CREATE TABLE statements for your database and a Prisma schema — copy whichever you use.

What the generator gets right

The mistakes that cost weeks later are the ones it is built to avoid.

link

Join tables, not arrays

Many-to-many relationships get an explicit join table with its own keys instead of a comma-separated column.

schedule

Timestamps everywhere

Every table gets created_at and updated_at, because every app eventually asks "when did this change".

storage

Types your database has

PostgreSQL gets uuid and timestamptz, MySQL gets char(36) and datetime, SQLite gets text and integer.

Questions about the schema generator

Which databases are supported?

PostgreSQL (the default and what Chattee deploys), MySQL/MariaDB and SQLite. The SQL and the Prisma schema follow the database you pick, and the ER diagram is drawn from that SQL.
Is the schema normalised?

To third normal form in practice: repeated text values become lookup tables, many-to-many becomes a join table, and calculated values are left out. Deliberate denormalisation for performance is a decision for later.
Can I paste an existing requirements document?

Yes — up to 12,000 characters. A PRD from the PRD generator works well as input.
Is it really free?

Yes. No account, no card, no watermark. Each visitor can run a tool a few times an hour; the limit exists only to keep the tools fast for everyone.
What happens to what I type?

Your input is sent to an AI model to produce the result and kept with the result for 90 days so you can come back to it. It is not used to train anything, and result links are unlisted.
Can I use the result outside Chattee?

Of course. Copy it, download it, share the link. "Build this with Chattee" is there if you want the app built, not a condition.

Turn the schema into an app

Chattee provisions a managed PostgreSQL database, generates the API and builds the screens for each entity. Planning is free.

Start building free arrow_forward