JetBrains is ready to release the first version of its new IDE for developers. It has announced DataGrip 1.0, formerly known as 0xDBE, designed to be a developer’s “Swiss Army Knife for databases and SQL,” according to the company.

“For a year and a half we ran an Early Access Program (EAP) for this product while it was still known as 0xDBE. At some point one needs to stop and draw the line,” the DataGrip team wrote on its blog.

(Related: JetBrains previews IDE for SQL databases)

The new IDE features access to major database-management systems such as Apache Derby, DB2, H2, HSQLDB, MySQL, Oracle, PostgreSQL, SQLite, SQL Server and Sybase.

Other features include:
• The ability to modify database objects and get resulting scripts through a UI for operations
• The ability to write SQL and avoid repetitive code using code completion
• The ability to navigate through code and rename it as users type. “If you rename a variable or alias, they will be renamed throughout the code,” the team wrote
• The ability to work with data and explore relationships through the IDE’s table editor. Users can add, remove, edit and clone data rows using the table editor
• The ability to profile queries and compare results. “Choose what you want DataGrip to do when the Execute button is clicked—execute the subquery, execute the outer query, or execute the whole script,” the team wrote

Other features include quick navigation, code generation, code analysis and quick fixes, smart text editor, customizable appearance, user parameters, CSV editor, and diagrams.

DataGrip is based on JetBrain’s IntelliJ Platform, and is available as a single IDE and as a part of JetBrains Toolbox.