Database Tools and SQL Support

Database Tools for Higher Productivity

As the most intelligent Java IDE, IntelliJ IDEA* also brings you powerful database tools and full 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 correctly resolves all table and column references over your SQL files and enables you to rename any symbol and its usages easily.

Code Analysis and Quick-fixes

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

Powerful Editor

The editor that comes with the IDE makes you highly productive when editing SQL or any other code.

Code Formatting

Have your SQL code formatted automatically, based on flexible user-defined code styles.

Slick Table Editor

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

Navigation

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

Managing Schema

Create and modify your schema with ease, including tables and columns, indices, foreign keys, functions, procedures, etc. for all supported databases.

Diagrams

With IntelliJ IDEA you can always see your tables and their relationships on an insightful diagram.

Get Started

Get started with database tools in IntelliJ IDEA with 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 can help you work with Java Persistence API and Hibernate. More info »