DB Logo

Database Design — database schema constructor

by Rikky

DB Logo

Database Design

by Rikky

Create database
schema online

The tool for visual design of relational databases,
their relationships and structure, with export
to SQL dump. Convenient and intuitive!

Tool for visual design of relational
databases, their connections and structures.
Convenient and visual!

Database design without writing SQL queries
A convenient and visually pleasing interface of the designer

Designing a database without writing SQL queries

Exporting the entire schema to a SQL dump with one click:
The visual schema can be immediately deployed in the DBMS.

The user-friendly and pleasing-to-the-eye interface of the constructor

All database entities and their relationships are laid out before you!
This will be useful for both new and old projects.

Exporting the entire schema to an SQL dump in one click

All the DATABASE entities and their relationships are in the palm of your hand!


The creator of the project is Andrey Rick
Watch trailer

Database Design

The diagram will provide an overview
of the project's information system from a bird's-eye view

It will serve as an eternal
visual and easily expandable guide to the database

The program interface is available in the same languages as this website. Enjoy the process of designing databases!
Database Design Interface

Place the tables as you
wish - they can be dragged around,
and you can set their header color

Useful articles
and project's news:

Added: convenient table and column selection for linking, the ability to switch between dark and light themes, and 2FA authentication.

Added: convenient table and column selection for linking, the ability to switch between dark and light themes, and 2FA authentication.

Project News

Try the new convenient table selection for linking! A table search feature has been added, and now you can specify a column for linking. For fans of light interfaces, a light theme has been added. Security has been improved. read article

Access settings have been added!

Access settings have been added!

Project News

It is now possible to share the database schema with your team or clients! Everyone will be thrilled with how you presented the database schema, and this has already been verified! read article

Added: a convenient color selection for the table header, table groups, the ability to add a description to the table, and to duplicate the table. Improved scaling of the workspace.

Added: a convenient color selection for the table header, table groups, the ability to add a description to the table, and to duplicate the table. Improved scaling of the workspace.

Project News

By assigning a color to a table, you can quickly assign the same color to another table. Each color can be given a name by creating a color group for tables. You can display only one group of tables while hiding the others. The description of the table is always displayed above the table. A scaling bug has been fixed. read article

Data types have been added, extended settings and FOREIGN export, as well as mouse and touchpad sensitivity switching

Data types have been added, extended settings and FOREIGN export, as well as mouse and touchpad sensitivity switching

Project News

It is now significantly easier to select data types, as there are more of them and hints have been added. For the convenience of using the touchpad, a dedicated mode has been introduced read article

How to get data from a table in SQL: the SQL query SELECT FROM WHERE

How to get data from a table in SQL: the SQL query SELECT FROM WHERE

Examples of SQL queries

Learning SQL with examples: how to write SQL commands to retrieve data from a database? I explain how to extract information from a database in simple terms without fluff. The command SELECT FROM WHERE is easy! It works for MySQL, PostgreSQL, MS SQL, SQLite, Oracle, MariaDB, and other SQL DBMS. read article

How to add a row to a table in SQL: the SQL INSERT INTO statement

How to add a row to a table in SQL: the SQL INSERT INTO statement

Examples of SQL queries

Learning SQL with examples: how to write SQL commands to add data to a table? I explain how to insert data into a database table in simple terms without any fluff. The INSERT INTO command is easy! It works for MySQL, PostgresQL, MS SQL, SQLite, Oracle, MariaDB, and other SQL databases. read article

How to modify data in a table record in SQL: SQL UPDATE query

How to modify data in a table record in SQL: SQL UPDATE query

Examples of SQL queries

Updating SQL records, how to write SQL commands to change a row in a table? I explain how to edit data in a SQL database tuple in simple words without any unnecessary details. The UPDATE SET command is easy! It works for MySQL, PostgreSQL, MS SQL, SQLite, Oracle, MariaDB, and other SQL DBMS. read article

How to delete data from a table in SQL: the SQL query DELETE FROM WHERE

How to delete data from a table in SQL: the SQL query DELETE FROM WHERE

Examples of SQL queries

Learning SQL with examples: how to write SQL commands to delete a row from a database table? I explain row deletion in SQL, how to delete an SQL record in simple terms without unnecessary information. The DELETE FROM WHERE query is easy! It works for MySQL, PostgreSQL, MS SQL, SQLite, Oracle, MariaDB, and other SQL DBMS. read article

Relational databases are one of the components of almost any IT project. What is the essence of databases? What are they needed for?

Relational databases are one of the components of almost any IT project. What is the essence of databases? What are they needed for?

Database Fundamentals

Why is a database needed? What is a database from a programming perspective? The structure of data in a database, what does "relational" mean, and finally, why is it important to approach the design phase of a database very responsibly? read article

Basics of database design: how to create a "one-to-one" (1:1) relationship and when this type of relationship is needed, in simple terms with an example

Basics of database design: how to create a "one-to-one" (1:1) relationship and when this type of relationship is needed, in simple terms with an example

Database Fundamentals

Lessons on relational databases, online database training. How to create a "one-to-one" (1:1) relationship and when this type of relationship is needed. Learning the structure of relational databases with examples of SQL queries. read article

Fundamentals of database design: how to create a many-to-many (M:M) relationship and when this type of relationship is needed, explained simply with an example

Fundamentals of database design: how to create a many-to-many (M:M) relationship and when this type of relationship is needed, explained simply with an example

Database Fundamentals

Lessons on relational databases, online database learning. How to create a many-to-many (M:M) relationship and when this type of relationship is necessary. Exploring the structure of relational databases with examples of SQL queries. read article

Fundamentals of database design: data normalization in simple terms, the purpose of relationships in relational databases, one-to-many relationship

Fundamentals of database design: data normalization in simple terms, the purpose of relationships in relational databases, one-to-many relationship

Database Fundamentals

Lessons on relational databases, online database training. The one-to-many relationship, also known as "one to many" (1:M), explained with examples and in simple terms. read article

MySQL won't start: how to fix MySQL Shutdown Unexpectedly Error

MySQL won't start: how to fix MySQL Shutdown Unexpectedly Error

Database recovery

Everything was working like a charm, and suddenly MySQL crashes with an error? Let me explain how to fix the problem without losing data. read article

Try this!

Much more convenient than
designing a database
in Excel or describing its structure in Word

Indispensable for medium
and large projects,
all relationships and the entire database
structure are at a glance

Easily add new columns to tables.
Gather schemas for all projects in one place

Easily add
new columns
to tables:

Gather
schemas for all projects
in one place:

FAQ

How much does it cost to use this database design tool?

You can try it for free for five days. If you like it, further use will cost a very affordable price: ± 9$ per month. If you pay for a year in advance, the cost will be ± 64$ (savings: 3.67$ per month). And no card bindings or hidden automatic payments. And 9$ (or even more 3.67$ if paid for a year) is just like one taxi ride!

Database Design will make your workflow enjoyable, and your database diagrams more visual and high-quality, especially in the eyes of your clients, thus bringing you benefits that are immeasurable compared to its usage cost. By paying for the use of the project, you also support its sole developer and motivate the enhancement of the project's functionalities, making it even more convenient!

What types of database schemas can be designed here?

DB Design is perfect for designing the schema of the final version of a relational database that will be recreated in a real DB. This means you can think through and place all the tables that will be in the database on the canvas, as well as all the connections between them. There are also more abstract types of database design; you can try using the builder for them as well, but it is primarily geared towards designing real databases. You can try the builder for free for one day; if you like it, great, if not, it's not a problem.

Will I be able to print the visual schema or use its screenshots?

Yes, the builder has a special mode for screenshots and printing schemas. In this mode, the background turns white and the text black. Screenshots taken in this mode will look good in article texts and will not consume much printer ink.

Can I share the visual schema with others?

Yes, in Database Design, you can set sharing options for each schema separately. You can grant access to anyone who has the project link or specify the emails of the people you want to share with, and besides you and them, no one will be able to view the schema, even if they have the link. You can also choose the option 'schema is only available to me' if you do not want anyone else to see it. This option is set as the default for all your projects.

Can multiple people edit the same drawing simultaneously?

Currently, no, but the builder is constantly being improved, and this functionality will definitely be added later. If this functionality is important to you, please let us know in the chat — this can speed up its implementation!

Can I specify FOREIGN KEYS and INDEXES, and will they be in the SQL dump?

Yes, both foreign keys and indexes can be set up in a user-friendly interface. They are also generated when exporting to an SQL dump.

Will I need to install anything to work with the builder?

No, the builder is a web application and works from the browser.

Where are my database schemas stored? Can I save them locally?

Your schemas are stored on our cloud, and you can access them from anywhere as long as you have internet access. Currently, you can save the database dump in SQL format. This can be used to recreate the database. If you need the functionality to save and restore the visual schema, please let us know.

Can I use Database Design without the internet?

No, the builder is a web application, works from the browser, and will not operate without the internet.

Can I use Database Design from my smartphone?

Yes, Database Design can be used from any smartphone as long as you have internet access. However, I recommend working from a computer or laptop whenever possible, as only on a large screen can you achieve maximum clarity of connections between tables and their data.

What will happen to my data when the subscription expires?

For a year, they will be stored for free in our cloud even if the subscription is not paid. If the subscription is renewed, the countdown will start again from the day the subscription expires.

Is there an option to work in a light interface?

Yes, the entire internal interface has a light theme. If you prefer light interfaces, please feel free to use it! The light theme is also better for screenshots.

I need a specific functionality that is not yet in the builder.

Please write to the project's creator in the chat on the website. If the idea is great, there is a good chance that this functionality will be added. I have already added features at the request of product users, so I would be happy to receive feedback.

Did not find the question you were looking for?

Please write in the chat, and the project's creator will be happy to answer you!

From the creator of Database Design:

Hello! My name is Andrey Rikkster. I am a fullstack web developer with 10+ years of experience.

I am Russian and I am from Russia, but personally I have not done anything bad
to Ukraine or anyone else. I kindly ask to relate to me as an individual unique person,
without linking to race, nationality, region, religious affiliations, and so on.

I created this tool
for myself, and now I can't imagine
how I lived without it before.

Often it is necessary to return
to some project after a while,
and one already forgets
how everything is arranged I open Database Design,
and immediately see
what tables are there,
what columns they have.

It's really awesome!

I specifically emphasized
not only on functionality,
but also on the visual part,
so
working in Database Design
you can get even more
pleasure from the process itself.
Now I share my creation,
and I would be glad if Database Design
proves to be useful for you.

The project has been around for several years, and during this time I have released several updates,
in which functionality was improved and user interface convenience was enhanced.

I plan to continue supporting and developing Database Design,
and the fact that more than 5000 people are using it motivates me greatly:

After all, now I strive not only for myself, but also for you!

Full-stack developer & designer

Andrey Rikky

Full-stack developer & designer

Andrey Rikky
Sign Up

Sign Up