Early Access Program Features

Announcing 0xDBE 1.0 Preview

We at JetBrains are approaching the release of our brand new IDE for developers who work with SQL and databases. We’ve started the 0xDBE 1.0 EAP (Early Access Program) over a year ago and we appreciate how many people have participated in the program. Your feedback has been instrumental in shaping and improving the product.

Today, we’re really excited to announce the 0xDBE 1.0 Preview, a nearly-finished version of our database IDE. Please give it a try and share your impressions to help us polish it before release to market.

DBIDE2_splash_upd (1)

Along with the preview we’re launching a 5-8 minute survey to get a better understanding of how you work with data. We would very much appreciate your input and feedback.

Note 0xDBE is not the final name of the product and will be changed. Now, let’s take a tour of what we’ve improved since the EAP launch.

Faster and more accurate schema introspection

First of all, we’ve reworked the way the IDE fetches meta information about database objects, and extended the JDBC-based introspection for all supported database engines to make it more native, accurate and fast. As a result, the UI has also changed. Now you can group objects in the Database view. Tables, functions, views, etc. are divided into folders and can be collapsed and expanded.


Modify table action

Now you can Modify Table (Ctrl+F6, or Cmd-F6 for OS X) from the Database tool window, or even the Editor or the Query Console. This action lets you add, change and remove columns, indices, and foreign keys. An instant SQL preview is available so you can get a DDL statement for your changes:


Text search in table editor

Sometimes it is useful to find data inside a table quickly without writing a statement. Call up a text search in the Table Editor with Ctrl+F (Cmd-F for OS X). It’s especially helpful if you don’t know which exact column contains the data you’re looking for. Regular Expressions are available for this search as well.


Code generation

The Generate action, available via Alt+Ins (Cmd-N for OS X), now helps you generate and modify DDL statements. There is a pop-up providing UI for generating statements for creating database objects, for instance, tables, functions and procedures.

You can also modify existing DDL statements and generate adding indexes, keys or columns to a created table.


The Edit as Table action from the context menu is valid for DML, so if you have several INSERT statements, you can modify the data being inserted as a table. If you add a row to this table, another INSERT statement will be generated:


Multiple query consoles

We’ve added a dedicated action for opening a new console so you can assign any shortcut to it to open it even faster. Several open consoles are available, and you can switch between them via the Files tool window, or the Recent Files menu, or the Navigation toolbar. Each console now has a schema switcher:

New console

Query console local history

You’ll be glad to know that consoles are now equipped with local history. Use it to review the changes you’ve made to SQL code in a particular console, or compare versions in the diff viewer and revert if needed:

Local history

Execution behavior

We’ve extended execution options as well. First, running under selection is now improved and works in files. You can choose what to do with selected SQL code: run as several statements, run as one statement, or make a smart expansion to a valid script.

When the cursor is inside a query, statement execution can now be customized with a few possible options. Define its intended behavior: execute the smallest statement, the largest statement, or ask you to choose what to execute.

If the cursor is outside of any statement, you can configure it to do nothing, execute the whole file, or execute statements to the end.

Executie options

Running statements from the Structure view

Running SQL statements with Ctrl+Enter (Cmd-Enter for OS X) is now possible from the Structure view/popup:

Structure view

Execution plan

An execution plan for statements is provided as well:

Explain plan

Compare query results

You can compare the results of two queries using the diff viewer:


CSV format support

Now when opening a CSV file, choose the Edit as Table action from the context menu. In the Data Format Configuration window, you can specify the value of the delimiter, whether your file has a header, when to quote values, and a few other things. It offers a preview as well:


User parameters

A new UI for editing Parameter Patterns is available in Settings > Database > User Parameters. Now Regular Expressions are highlighted and you can choose in what dialect these patterns are valid:


Visual diagrams

Visual diagrams are now available for databases. Build your own diagram displaying the dependencies between objects:


Improved navigation

To navigate to a database object (like table, procedure and so on), press Ctrl+N (Cmd-O for OS X). When navigating to a table, a table editor will open. When navigating to a procedure or function, you’ll jump to the alter DDL statement:


It’s also worth mentioning that 0xDBE has improved its support of HDPi for Windows and Linux; offers a Distraction Free mode; and makes it possible to install plugins (e.g. Terminal, Git integration), among other bug-fixes and minor enhancements.

0xDBE will be released in the middle of November as a part of JetBrains Toolbox. Its pricing will be aligned with the “Single IDE” plan. The “All Products” bundle will include 0xDBE.

Download 0xDBE 1.0 Preview today and please share your impressions with us.

Develop with pleasure!


Comments below can no longer be edited.

27 Responses to Announcing 0xDBE 1.0 Preview

  1. Avatar

    DJ Far says:

    October 21, 2015

    One of the most useful and powerful features of MySQL Workbench is its EER Diagram tool, that allows you to build an ER Model and then forward-engineer it to a physical schema. Of course, it only works with MySQL.
    Any plans to incorporate a modeling tool?

  2. Avatar

    maus says:

    October 21, 2015

    Any thought on useful implementations in MS SQL Server shops?

  3. Avatar

    N.T. says:

    October 21, 2015

    Any plans to add support for SAP HANA?

  4. Avatar

    Vitaly says:

    October 21, 2015

    I have been participated in EAP from the beginning. And after a year I have to say that it is still the same absolutely useless instrument. Just a simple toy. But too enormous toy to waste space on my SSD.

    It is impossible to use it with Oracle DB.
    I would be glad to explain my point of view and give you examples. But who cares?

    • Avatar

      Andrey Cheptsov says:

      October 22, 2015

      In fact we do care. We’ll be really happy to hear more details on why it’s useless for you. Feel free to share it here, or send it privately to andrey.cheptsov at jetbrains.com.

      • Avatar

        Vitaly says:

        October 22, 2015

        I answered you by email.

  5. Avatar

    Chris Roberts says:

    October 22, 2015

    I’ve been using 0xDBE ever since the EAP came out last year and it’s been great. Will it be included in the Toolbox subscription?

    • Avatar

      Andrey Cheptsov says:

      October 22, 2015

      Sure, it will be aligned with jetbrains.com/toolbox/ (Single IDE). The “All Products” bundle will include 0xDBE.

  6. Avatar

    A.N. says:

    October 22, 2015

    No graphical query/DDL/views creator. This would be the killer feature for us. So we could replace IBM data studio and EMS SQL manager. Both tools are very glitchy. With a graphical query editors we are much more productive than writing view with plain SQL.


  7. Avatar

    Ricardo Pereira says:

    October 22, 2015

    Please consider adding Redshift dialect…

    • Avatar

      Chris Humphries says:

      October 23, 2015

      I concur. Redshift would be great, too!

  8. Avatar

    Ryan says:

    October 22, 2015

    Given the announcement date should it should be named McFlIDE?

  9. Avatar

    Dt says:

    October 22, 2015

    Almost anything is better than pgadmin3. I’m sold.

  10. Avatar

    peter says:

    October 22, 2015

    Will this be available as part of IntelliJ? If so when? I love the current DB support in IntelliJ and I use it daily. It would be great to get these improvements in the IntelliJ version.

    • Avatar

      Maksim Sobolevskiy says:

      October 22, 2015

      Hi, Peter! All 0xDBE features are available in IntelliJ IDEA. So, look for all described features in IntelliJ IDEA 15.

  11. Avatar

    Thorn says:

    October 22, 2015

    Господи, у вас что, работают клоуны или студенты? Что за маразм создавать таблицы рукописным текстом? И эти бесконечные деревья “база-таблицы-имена таблиц” – вы из 20 века штоле? Это архаизм именно оттуда! Какие же вы узколобые, товарищи – создали стотыщную копию того, чего и так на рынке НАВАЛОМ.

  12. Avatar

    Kevin D says:

    October 23, 2015

    Still hobbled by the fact that every open query to a server uses the and connection?

    • Avatar

      Kevin D says:

      October 23, 2015

      Seems they have indeed made it so that multiple connections to a database can be run at the same time! This is great!

  13. Avatar

    Jorma says:

    October 23, 2015

    0xDBE is a great tool for us. We have both H2 and Postgres databases so it’s a very natural fit. Being able to export and import the database settings between machines would be an awesome addition.

    I started the survey but terms and conditions and a captcha were too much.

  14. Avatar

    Dude says:

    October 23, 2015

    Looks too Java (e.g. Data Sources config). Any plans to release this for .NET SQL Server developers with proper Visual Studio integration?

    • Avatar

      Maksim Sobolevskiy says:

      October 23, 2015

      Hi, Dude! For now we have no plans of that kind.

  15. Avatar

    Lazy Ninja says:

    November 2, 2015

    Love the tool – can’t wait for release.

    Will I have few days after release to purchase the license or will the EAP/Preview version stop working immediately?

    Secondly badly need TNS names (tnsnames.ora) support for Oracle

    • Avatar

      Andrey Cheptsov says:

      November 5, 2015

      There’ll be a release candidate and it will work for some time even after the release

  16. Avatar

    Bobbo says:

    November 8, 2015

    One thing that can get me off of Visual Studio, hence Windows; would be to also provide a way to handle the Azure Storage: Tables/Blobs/Message Queues. As we move more & more to Cloud based storage services, there’s a definite need to be able to manage these types of data repositories.

  17. Avatar

    Igor says:

    November 9, 2015

    Thanks for your work! What about database internal procedures debugger? I mean test window to allow write and debug procedures without creating and storing it in database. Thanks

    • Avatar

      Maksim Sobolevskiy says:

      November 11, 2015

      We hope to have it in version 2.0

  18. Avatar

    Lazy Ninja says:

    November 20, 2015

    Will there be a seperate connection type for Redshift? The Postgres introspector fails to read Redshift databases for me and I need to resort to the legacy one to be able to see the schemas

    Secondly any word on tnsnames.ora file support? Currently Oracle connection properties are quite hectic?

Discover more