Database tools and SQL
The database management functionality in IntelliJ IDEA is supported by the Database tools and SQL plugin. The plugin provides support of all the features that are available in DataGrip, the standalone database management environment for developers. With the plugin, you can query, create and manage databases. Databases can work locally, on a server, or in the cloud. The plugin supports MySQL, PostgreSQL, Microsoft SQL Server, SQLite, MariaDB, Oracle, Apache Cassandra, and others. See the full list of supported vendors in Connecting to database.
Enable the Database tools and SQL plugin
This functionality relies on the Database tools and SQL plugin, which is bundled and enabled in IntelliJ IDEA by default. If the relevant features aren't available, make sure that you didn't disable the plugin.
Press Control+Alt+S to open the IDE settings and select
.Open the Installed tab, find the Database tools and SQL plugin, and select the checkbox next to the plugin name.
Get started with database tools
These topics are focused on describing features, functionality, the application interface, and might help you to get started quickly.
Start working with your data source by creating a connection to it. | |
Connect an SQL file to a data source and run your code. | |
Connect an SQL file to a data source and run your code. | |
Import and export your data to and from various formats with or without special tools like mysqldump, pg_dump, pg_restore, or psql. | |
Connectivity issue is a very common definition and might include many problems. This troubleshooting article will guide you through the most common steps to identify and fix the issue. If you could not find the answer, try to contact JetBrains and we can try to help you. | |
Generate diagrams for database objects, build query and execution plans, generate flame graphs for EXPLAIN statements. |