EasyMySQL

Database, SQL and Java in one app.

What is EasyMySQL?

EasyMySQL is one app for working with databases. The database server is set up during installation and runs as soon as you open EasyMySQL, so you no longer need XAMPP or phpMyAdmin for databases. You write SQL, edit tables and look at your database as an ER diagram. If you access the database from Java, you can do that in the same window.

SQL editor

While you type, the editor suggests tables and columns from your database. If a query does not work, it marks the spot and tells you what is wrong. Auto-Fix repairs whole scripts: it test-runs them on a throwaway copy of your database until they run without errors – your data stays untouched.

SQL editor with suggestions and query results

Tables

You change values right in the table, like in Excel. You can also rename, move or delete columns there without writing SQL.

Product table with inline editing

ER diagrams

EasyMySQL draws an ER diagram from your database. You see every table and how they are linked by foreign keys. The diagram can be saved as a picture.

ER diagram with tables and foreign keys

Query builder

Here you click tables, columns and conditions together and see the resulting SQL next to it. That helps most while you are still learning SQL.

Visual query builder with generated SQL

Java

For Java, EasyMySQL creates a project in which the database connection already works. You write the code, run it and find mistakes with the debugger. You do not have to install Java yourself.

Java project with editor and terminal

Git

With Git you record what you changed and can look at every earlier state again. EasyMySQL shows you the changed lines before you save them as a commit.

Git view with changes

Why switch to EasyMySQL?

Compared with XAMPP and MySQL Workbench

EasyMySQL, XAMPP and MySQL Workbench: speed, size and features
EasyMySQLXAMPPWorkbench
Speed
Starting the app0.47 s2.7 s5.7 s
Opening a table with 1M rows0.17 s0.33 s2.1 s
Searching 1M rows0.20 s0.34 s0.25 s
Drawing an ER diagram0.22 s0.60 snot available
Importing 1M rows7.7 sfile too largenot available
Size
Memory133 MB252 MB266 MB
Disk space260 MB929 MB870 MB
Download77 MB200 MB273 MB
Database
Database server includedYesYesNo
Works without a browserYesNoYes
Works with MariaDBYesYesNo
SQL editor with suggestionsYesYesYes
Fix errors with one clickYesNoNo
Edit tables in placeYesYesYes
ER diagramsYesYesNo
Click queries togetherYesYesNo
Import CSV filesYesYesNo
Import from MongoDB and RedisYesNoNo
Keeping your data safe
Automatic backupsYesNoNo
Backup before every deleteYesNoNo
Checks the tables after a crashYesNoNo
Rescue when the server does not startYesNoNo
Coding
Write, run and debug JavaYesNoNo
Version control with GitYesNoNo
Web server with PHPNoYesNo
SQL notebooksNoNoYes
AI
AI chat inside the appYesNoNo
AI knows your tablesYesNoNo
Features18 of 208 of 204 of 20

Questions