{"id":541248,"date":"2025-01-29T16:41:10","date_gmt":"2025-01-29T15:41:10","guid":{"rendered":"https:\/\/blog.jetbrains.com\/?post_type=idea&p=541248"},"modified":"2025-12-08T16:04:51","modified_gmt":"2025-12-08T15:04:51","slug":"tips-for-productive-java-development-with-databases-in-intellij-idea","status":"publish","type":"idea","link":"https:\/\/blog.jetbrains.com\/pt-br\/idea\/2025\/01\/tips-for-productive-java-development-with-databases-in-intellij-idea","title":{"rendered":"9 Tips for Productive Java Development With Databases in IntelliJ IDEA"},"content":{"rendered":"\n

In this article, we\u2019ll share nine time-saving ways IntelliJ IDEA can boost your productivity when developing Java applications with databases \u2013 whether you’re starting a new project or diving into an ongoing one.<\/p>\n\n\n\n

Get IntelliJ IDEA<\/a><\/p>\n\n\n\n

Create data sources automatically from properties<\/h2>\n\n\n\n

IntelliJ IDEA makes it easy to create a data source for your Spring project right from the application.properties<\/code> file \u2013 simply open it and click on a gutter icon next to the properties. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In the opened Data Sources and Drivers<\/em> dialog, you\u2019ll see a data source already assigned and the database-related fields prefilled \u2013 all you need to do is to test connectivity (just in case) and click OK.<\/em> The data source will be created for you.<\/p>\n\n\n\n

Test Spring Data JPA query methods without running the application<\/h2>\n\n\n\n

IntelliJ IDEA simplifies Spring Data JPA method query verification! It provides autocompletion for names and the ability to check generated queries without running the application. Just click the dedicated gutter icon to execute repository methods directly in the JPQL console.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Review database schemas as diagrams<\/h2>\n\n\n\n

Database diagrams are great for quickly grasping the structure of databases and understanding the relationships between their various objects. IntelliJ IDEA can create detailed diagrams for data sources, schemas, or tables to help you analyze the data structure more effectively. To generate a diagram, right-click a database object in the Database <\/em>tool window and select Diagrams | Show Diagram<\/em>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You can also assign colors to diagram objects to further enhance the way you interact with and comprehend your database structure.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Review query results right in the editor<\/h2>\n\n\n\n

IntelliJ IDEA provides a compact way to review query results right in the editor. To enable it, click the In-Editor Results<\/em> button in the query console before running your query. \u200b\u200bThis is especially useful for working with smaller datasets or data samples.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Modify query data in the results set view<\/h2>\n\n\n\n

When you need to make changes to cell values in IntelliJ IDEA, you don\u2019t have to write and re-run queries! Simply click on a cell value that you want to edit, enter the new value, then click the Submit<\/em> button (\u2b06) or \u2318\u21a9\/Ctrl+Enter<\/em> to push changes to the database.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

View query results as charts<\/h2>\n\n\n\n

Charts provide a powerful and user-friendly way to quickly gain actionable insights from your query results. This feature is particularly useful when analyzing large datasets, looking for patterns, or presenting trends in an easily comprehensible format.<\/p>\n\n\n\n

To open chart settings, click the Switch to Chart<\/em> icon on the data editor toolbar. You can choose from a wide range of chart types, including bar charts, pie charts, area charts, line charts, and more, depending on what best suits your needs.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

When you need to present your findings or keep snapshots of data dynamics, you can export charts in .png<\/code> format. To save a chart snapshot, simply click the Export to PNG<\/em> button in Series<\/em> Settings<\/em>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Profile your query with an execution plan<\/h2>\n\n\n\n

You can also visualize execution plans for queries, illustrating the set of steps that were used to access data in a database and the cost of each step \u2013 in other words, how long it takes to run the statement. <\/p>\n\n\n\n

To open the execution plan, right-click an SQL statement, select Explain Plan | Explain Plan<\/em>, and then click on the Show Diagram<\/em> icon.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Use DB migration libraries to update application databases<\/h2>\n\n\n\n

Database schemas evolve over time as business requirements change, and database schema updates and migration can be tricky and error-prone when done manually. Instead, take advantage of IntelliJ IDEA’s built-in support for automatically generating migration scripts based on existing JPA entities. For more information, refer to this article<\/a>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Leverage AI Assistant<\/h2>\n\n\n\n

AI Assistant makes data query and managing data faster and more efficient<\/a>. It helps speed up SQL query generation, provides explanations, suggests fixes, and can even generate test data tables!<\/p>\n\n\n\n

\"AI<\/figure>\n\n\n\n
\n\n\n\n

By following these tips, you can optimize your workflow, save time, and make working with databases more productive and enjoyable. Check out this page<\/a> to learn more about the database tools in IntelliJ IDEA.<\/p>\n\n\n\n

Happy developing!<\/p>\n","protected":false},"author":1400,"featured_media":541271,"comment_status":"closed","ping_status":"closed","template":"","categories":[601],"tags":[2934,6717],"cross-post-tag":[],"acf":[],"_links":{"self":[{"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/idea\/541248"}],"collection":[{"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/idea"}],"about":[{"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/types\/idea"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/users\/1400"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/comments?post=541248"}],"version-history":[{"count":9,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/idea\/541248\/revisions"}],"predecessor-version":[{"id":666458,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/idea\/541248\/revisions\/666458"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/media\/541271"}],"wp:attachment":[{"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/media?parent=541248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/categories?post=541248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/tags?post=541248"},{"taxonomy":"cross-post-tag","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/pt-br\/wp-json\/wp\/v2\/cross-post-tag?post=541248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}