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.
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.
The editor that comes with the IDE makes you highly productive when editing SQL or any other code.
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.
With IntelliJ IDEA it is easier than ever to find your way over your SQL files and schema definition.
Create and modify your schema with ease, including tables and columns, indices, foreign keys, functions, procedures, etc. for all supported databases.
With IntelliJ IDEA you can always see your tables and their relationships on an insightful diagram.
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 »