How to connect database to intellij idea

In Ultimate edition of IntelliJ, database bundle comes with in built. But if you are using the community edition, database not comes with that. So, I will guide you that, how to connect database to intellij idea.

If you are using ultimate edition of IntelliJ, simply go to view | tool window | database and connect it . But foe ultimaate edition, you have to download a plugin named Database Navigator. You can download it by settings in Intellij by going Files | Settings | Plugins | browse repositories | Database Navigator.

Sometimes, it shown the error message, then no problem you can download Database Navigator by JETBRAIN SITE also. In order to download it go to https://plugins.jetbrains.com/plugin/1800-database-navigator and download it.

Then you have to go in the same place Files | Settings | Plugins | browse repositories and click on Install plugin from disk. Select the package which you have downloaded and then click on restart intelliJ idea.

After restarting, go to view | tool window | db browser . In order to connect database, click on + sign and select your perferred database. In my case I prefer MYSQL so, here the _screenshots of connecting mySQL with intelliJ idea.

You can choose any database and connect, this is very easy.

 

Now you can access all the databases, which you have connected from here.

 

That’s it, Enjoy … Happy coding…