JetBrains, producer of numerous development tools for a wide variety of coding projects, is set to release an advanced editor for SQL management. The company already has a number of plugins for its integrated development environment (IDE) software that support databases, but 0xDBE is designed to be the definitive tool for designing, managing, and developing for databases.

0xDBE has been designed to suit the specific needs of professional DBAs and developers. It has an intelligent SQL editor, schema management, version control integration and other database tools. 0xDBE works with DB2, Derby, H2, HSQLDB, MySQL, Oracle, PostgreSQL, SQL Server, SQLite and Sybase, and it runs on Windows, OS X and Linux. 0xDBE also support major version control systems including Git, SVN, Perforce, Mercurial, and many others.

Future ready IDE tool

With support for all major database platforms from a single interface, teams can standardize on one heterogeneous SQL IDE tool. And, a rich development environment simplifies SQL scripting, query building, object management, project management and version control in live databases or offline source code repositories.

The SQL editor tool is based on JetBrain’s highly advanced IntelliJ platform. Like other IDEs from JetBrains, 0xDBE supports all popular dialects of SQL, offers auto completion and other convenience when working with SQL code, database schemas, VCS integration and others.

Features of 0xDBE

0xDBE will feature automatic code completion and parameter proposals, code analysis functions and options for code formatting. The tool should be able to resolve all table and column references in SQL files and thus provide symbols in data sources and SQL files with new names and places where confusion may occur. A built-in table editor will also help browse data, and also create and modify schemes with built-in special functions.

The explorer allows developers to connect databases and view contents. Additionally, developers can create, modify, and delete tables, columns, indexes and databases directly from the IDE. The editor within the IDE allows users to view and modify data in the database. Developers can open, edit and run SQL scripts in SQL Editor. The editor has a lot of opportunities associated with code completion and syntax highlighting, which helps write scripts quickly and correctly. The editor supports the setting, and users can extend it with new features through plug-ins.

The IDE provides an easier way to explore and maintain existing databases, design compound SQL statements, query and manipulate data in different ways. It has new design code completion that provides code completion based foreign-keys-aware completion, alter-statements-aware completion, insert statement completion, and parameter suggestion for values, functions and procedures on the context and schema constraints, helping developers write SQL code faster.

The auto correct feature detects probable bugs in your SQL code and helps database developers and administrators to add unresolved table/column to a data source, create table/column definition for unresolved symbols and quote identifies with reserved symbols and suggests the best options to fix them on the fly.

There’s a built-in table editor that can be used to browse and modify data, and that can show data or navigate by a foreign key, find usages by a primary key, and display your data in a transposed row view.

Though 0xDBE is still under heavy development, JetBrains opens subscription for early preview of the new IDE for developers who write in SQL. The company plans a general availability release before the end of the year.