
Describe your tables and relationships once. Get a clean ERD with primary and foreign keys clearly marked — ready for a design review or a migration doc.
A new schema usually starts as a list of tables in a document. CloudSketch AI turns that description into an entity-relationship diagram with tables, columns, primary and foreign keys and crow's-foot relationships, so reviewers can understand the data model at a glance.
“An e-commerce database with users, orders, order_items, products, and categories tables. Each order belongs to a user and contains many order_items, each linked to a product, and each product belongs to a category.”
Drawing the diagram…
An example of the diagram this prompt describes. Your own result can differ in layout and detail.
Swipe sideways to see the whole diagram.
List the tables and how they relate in plain English, or paste SQL CREATE TABLE statements or a list of columns.
CloudSketch AI identifies the entities, their keys and the cardinality of each relationship, and draws them in crow's-foot notation.
Ask for changes in plain English, switch the level of detail, then export the diagram or copy its Mermaid code into your documentation.
Primary and foreign keys are labeled clearly so the diagram reads correctly to any engineer, not just the author.
Describe entities in natural language — CloudSketch AI works out one-to-many and many-to-many relationships for you.
Export for schema reviews, onboarding docs, or a migration RFC.
Agree on tables and relationships before anyone writes a migration.
Paste existing table definitions and get a readable diagram of a database nobody has drawn before.
Explain relational modelling with a clear, correct example.
Paste your table definitions (SQL DDL or a plain list of columns) into the prompt and CloudSketch AI will build the ERD from that instead of a from-scratch description.
The ERD is database-neutral, so it works for PostgreSQL, MySQL, SQL Server, Oracle and SQLite schemas alike. Mention the data types you use in your prompt if you want them shown.
Yes. ERDs are on the free plan (20 credits to start and 10 a month with a free account, 3 a day without signing in). Pro raises the limit to 150 credits a month.
Crow's-foot notation: each relationship line shows whether it is one-to-one, one-to-many or many-to-many, and whether it is optional. Each table lists its columns with PK and FK marked.
A database schema is the set of tables, columns and constraints in the database itself. An ER diagram is the picture of it: entities, their attributes and how they relate. CloudSketch AI draws the picture from either a description or your existing table definitions.
Yes. Ask for a change in plain English, such as 'add a payments table linked to orders', and the diagram is updated. You can also copy the Mermaid code or export the diagram as an image.