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.
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.
The editor coming along with the IDE makes you highly productive in editing SQL or any other code.
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.
With IntelliJ IDEA it is as easy as ever to find your way over your SQL files and schema definition.
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.
With IntelliJ IDEA you can always see your tables and its relationships on a diagram.
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 »