1. Introduction

Fat brother is a software cleanliness person, can solve problems with existing software will never install new software. Java back-end development deals primarily with databases, so database graphical interfaces (GUIs) are essential. In general graphical manipulation of relational databases (RMDBS) most people will choose Navicat. Navicat is not necessary if you are using Intellij IDEA, either the flagship or the community version, which comes with a graphical interface for the database, but you can integrate the graphical interface with the community version through plug-ins. Today, take the flagship version as an example to demonstrate the database graphics management ability of IDEA.

2. IDEA Database graphics management

Open Database in the right sidebar of IDEA flagship version is the graphical interface of Database. Community version can be obtained by installing plug-ins.

Click ➕ and you’ll see a list of all the supported database types, including the common MySQL, Oracle, PostgreSQL, H2, SQL Server, and even ClickHouse and MongoDB documentation databases.

Select one of these and configure it. MySQL for example:

Then you get to the graphical interface, where you can manage your database graphically. This graphical interface provides a lot of functionality, so LET me show you a few commonly used functions.

The Console Console

You can use the console to write DDL and DML statements to manipulate the database. In Win, the shortcut keys are CTRL+SHIFT+F10.

Provides a powerful prompt function, Tx transaction type control, view history statements, multiple query results comparison and other functions. And for the query results display form is very rich, in addition to the table you know there are many, for example

You can use the following steps to meet your needs:

Generate code statement function

You can start by generating DDL statements from an existing database.

It is also useful to generate entity classes from the database.

Import/Export function

This is a must-have feature for almost any database GUI.

Syntax highlighting

This function is one of the fundamental reasons why I choose to use it. As for the development, the coherence of thinking is very important. Most of the time, I hope that when writing Mybatis Mapper, I can quickly jump to the database, or prompt me the relevant table and field information of the database in real time to help you correct errors.

Are you itching to give it a try at this point? It’s not over yet!

3. Other database plug-ins

You can even integrate other types of databases with plug-ins, especially Redis and Elasticsearch.

Redis

You can integrate the Redis GUI tools with the following plug-ins without having to search for the Redis visual client.

Elasticsearch

Elasticsearch can now be visualized by installing the free plugin:

4. To summarize

The IDEA database management GUI has been summarized today, which basically allows you to forgo many other management tools. Someone said to eat memory, if you eat memory on the focus to let a bad memory? Tool switching back and forth is not very comfortable.