Database Design — database schema constructor
by Rikky
Database Design
by Rikky
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 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
Place the tables as you
wish - they can be dragged around,
and you can set their header color
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!
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
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
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
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
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
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
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
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
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
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
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
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
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!
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 RikkyFull-stack developer & designer
Andrey Rikky