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.
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.
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. - Top 10 Shortcuts for Efficient Data Querying
In this article, we share the top 10 shortcuts for working with Database Tools, which will enhance your productivity while querying data.
All data management features are also available in JetBrains’ standalone database management tool – DataGrip.
