IntelliJ IDEA

Manage databases for Java and Kotlin – right in the IDE

Run queries, connect to databases, browse and export data, and even manage your schemas – all without leaving IntelliJ IDEA.

Download IntelliJ IDEA

Your database – supported

IntelliJ IDEA supports MySQL, PostgreSQL, Microsoft SQL Server, SQLite, MariaDB, Oracle, Apache Cassandra, and many others. You can find a complete list of all supported database vendors here.

PostgreSQL

MySQL

Oracle

Microsoft SQL Server

MondoDB

Redis

Azure SQL Database

Amazon Redshift

SQLite

Amazon DynamoDB

IBM Db2

And many more!

Getting started with database tools

Connect to a database

You can add databases via the Database tool window by following the simple setup steps.

Database tool window

In the Database tool window you can set up, group, and filter data sources, configure display options for each data source, and more! All connected data sources are conveniently structured by schemas, tables, and columns.

Data table

IntelliJ IDEA provides an easy-to-use GUI to navigate through data – the data editor. In the data editor you can perform all sorts of actions with results sets, like sorting, editing, and export/import.

Query console

You can execute SQL queries right in the IDE from a dedicated Query console – just type in what you want to execute.

Working with databases

View and edit data

You can freely navigate through the data, sort it, edit cell values, add/remove rows locally, and push changes to live databases – all without writing a single SQL query!

Compare data

Compare the contents of two database objects side by side. IntelliJ IDEA will highlight mismatched and equally valued cells, or even entire rows.

Export and import data

IntelliJ IDEA supports a wide range of data import/export formats – SQL, TXT, CSV, JSON, XML, Markdown, Excel, and other text formats that contain delimiter-separated values.

Filter data

You can specify filtering conditions or use quick filtering options. Filter rows by values in columns, write queries in the WHERE field, and more.

Diagram view

IntelliJ IDEA can generate a diagram that demonstrates the relationships of various objects within the database.

Visualize data with charts

You can use charts to visualize SQL query results in the data editor. Choose from plenty of chart types, like bar, pie, area, line, and many more.

SQL queries

Running SQL queries

Running queries in IntelliJ IDEA is simple – just click on the Query Console icon within the Database tool window, type your query, and click the Execute button.

Viewing query results

You can view and manage query results right in the editor.

Smart code completion

IntelliJ IDEA provides context-sensitive code completion, helping you write SQL queries faster.

On-the-fly analysis and quick-fixes

IntelliJ IDEA detects errors in your queries and suggests fixes on the fly.

Frameworks and databases

Working with Spring data

Connect databases to your Spring Boot application and enjoy full support for data management.

Persistence frameworks support for databases

Manage data with persistence frameworks – JPA and Hibernate

IntelliJ IDEA has out-of-the-box support for persistence frameworks, which simplify data management for your Java or Kotlin applications.

Database tutorials

Working with Databases in IntelliJ IDEA

In this demo session, we’ll show you how to write SQL queries and work with data in IntelliJ IDEA, from writing simple queries to more advanced tasks with the help of embedded database management functionality.

Learn more

Getting started with databases in IntelliJ IDEA
Learn how to perform various tasks like querying data, creating new databases, and managing existing ones – all without leaving your IDE.
Data sources overview
Learn how to set up a database source of your choice.
Run queries and view results
Explore an in-depth tutorial on how to run queries and SQL files and view query results.