Available in products
Database Tools and SQL Support
IntelliJ IDEA provides outstanding tools and code assistance features for work with database and SQL in your projects. You are able to connect to databases, edit schema as well as table data, run queries, and even analyze schema with UML diagrams.
Defining data sources enables code assistance for SQL queries in your project. After you set a data source you are able to run queries and edit database schema.
You can define data source by establishing a connection to database or with static DDL file.
SQL in Other Languages
All features IntelliJ IDEA provides for SQL are also available for SQL embedded into other languages.
You can edit SQL query right in place or open it in a special editor.
IntelliJ IDEA lets you run queries right from the code, where you define it.
With UML diagrams, you can analyze structure and relationships between tables.
IntelliJ IDEA offers comprehensive SQL editor with syntax highlighting, smart code completion, on-the-fly code analysis, code formatting and navigation.
The editor supports all popular dialects including PostgreSQL, MySQL, Oracle, SQL Server, as well as many others.
With the table editor you can edit table data with sorting, filters and support for drag and drop. Table data can be exported to SQL, TSV, CSV and HTML.