IntelliJ IDEA
Available in products

Database Tools and SQL Support

Database Tools for Higher Productivity

Being the most intelligent Java IDE, IntelliJ IDEA also brings you powerful database tools and neat SQL support for Oracle, PostgreSQL, MySQL, SQL Server and many other database systems.

Database tools and SQL support are only available in IntelliJ IDEA Ultimate.




Features Overview



Code Completion

IntelliJ IDEA provides code completion based on the context and schema constraints, helping you write SQL code faster.

Renaming and Finding Usages

The IDE resolves correctly all the table and column references over your SQL files and enables you to rename any symbol and its usages.

Code Analysis and Quick-fixes

IntelliJ IDEA detects probable bugs in your SQL code and suggests you the best options to fix it on-the-fly.

Powerful Editor

The editor coming along with the IDE makes you highly productive in editing SQL or any other code.

Code Formatting

The IDE is capable to format your SQL code automatically, based on flexible user-defined code styles.

Slick Table Editor

The built-in table editor helps you efficiently browse and alter the data.

Navigation

With IntelliJ IDEA it is as easy as ever to find your way over your SQL files and schema definition.

Managing Schema

IntelliJ IDEA lets you create and modify your schema in a very easy way. You can create and modify tables and columns, indices, foreign keys, functions, procedures, etc for all supported databases.

Diagrams

With IntelliJ IDEA you can always see your tables and its relationships on a diagram.

Get Started

Get started with database tools in IntelliJ IDEA with the help of these tutorials.


What's New in IntelliJ IDEA 13

  • Structure view for the Table Editor, Results view and SQL files
  • Query filtering and results sorting
  • Finding usages by primary key
  • And many more


See also: JPA and Hibernate

Check out how IntelliJ IDEA helps you work with Java Persistence API and Hibernate. More info »