Manage Your Database Schema in IntelliJ IDEA 12

Andrey Cheptsov

As you know, IntelliJ IDEA provides built-in database tools with support for many SQL dialects, such as Oracle, PostgreSQL, MySQL, Microsoft SQL Server and others.

A while ago we shared this video with a quick overview of how to set up a connection to a database, use smart completion (even for SQL queries within Java), on-the-fly code analysis, navigation (between queries and database), search (for tables and fields), and more cool features.

Now, please enjoy a new video with even more exciting features available in IntelliJ IDEA 12 for working with databases:

Manage Your Database Schema from the IDE

Now you are able to define tables, columns, indexes and foreign keys simply from the Database tool window via the shortcut (Ctrl+N) or the context menu.

Create New Table

The new table wizard brings code completion and SQL preview with support for all listed dialects, so you can define a new table for any database in seconds.

Modify Column

If you modify a column (Cmd+F6), the IDE will automatically show you how your changes affect the project and will apply the appropriate changes to the code.

Transaction Control

The table editor and query console support manual transaction control, so you can commit more than one change at once or roll it back safely whenever you want.

Data Export

Data from the table editor or query results may be exported to a file or clipboard in the following formats: CSV, TSV, HTML, SQL Insert/Update statements.

CSV Editor

If you open a CSV file in the editor, the IDE will offer you to edit data in a table.

Quick Documentation

The Database tool window also provides the Quick Documentation action via Ctrl+J for any selected element from the database. The popup window shows the SQL definition for selected item and the first 10 rows (for tables and views).

As databases are part of most projects today, it was about time for us to help developers work with them more productively. Find these and many other features for database development in the latest release of IntelliJ IDEA.

Feel free to share your feedback with us in our discussion forum and in our issue tracker.

Develop with Pleasure!

Subscribe to IntelliJ IDEA Blog updates

Subscribe form

By submitting this form, I agree to the JetBrains Privacy Policy Notification icon

By submitting this form, I agree that JetBrains s.r.o. ("JetBrains") may use my name, email address, and location data to send me newsletters, including commercial communications, and to process my personal data for this purpose. I agree that JetBrains may process said data using third-party services for this purpose in accordance with the JetBrains Privacy Policy. I understand that I can revoke this consent at any time in my profile. In addition, an unsubscribe link is included in each email.

Submit

Thanks, we've got you!