DataGrip 1.0 (formerly 0xDBE): A new IDE for DBs and SQL

Maksim Sobolevskiy

Hi there,

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.

We thank all of you who gave us feedback and we’re looking forward to your help with the following versions.

So please welcome DataGrip 1.0, our IDE for databases and SQL!

DataGrip1_splash@2x

Access major database management systems

  • Big players on the market: Oracle, SQL Server, DB2, Sybase
  • Popular among the community: MySQL, PostgreSQL
  • Small but useful: SQLite, Apache Derby, HyperSQL and H2

Modify database objects and get resulting scripts

DataGrip provides a UI for operations like creating/modifying tables and managing their columns, keys and indices. Execute generated code at once, or open it in the text editor and continue to work with the DDL script directly.

modify

Write SQL efficiently and avoid repetitive coding

With DataGrip you can write code faster by making use of code completion. Just start typing the name of a database object, identifier or variable to get a list of matching suggestions. DataGrip is aware of dependencies for completing JOIN clauses, can suggest types of parameters for functions and procedures, and describe table structure for INSERT statements. There are Live Templates for generating conventional parts of statements – use the default ones and create new ones as well.

complletion

Navigate through the code and rename as you type

DataGrip resolves object references in SQL files. If you rename a variable or alias, they will be renamed throughout the code. If you rename database objects from SQL, they will also be renamed in the actual database.

The IDE shows usages of objects (table, column, etc.) or variables in dedicated views. Navigation tools help you select an object in various contexts like the editor, schema view, and others.

refactorings

Work with data and explore relationships

Powerful table editor lets you add, remove, edit, and clone data rows. Use the filter text field to see only the data you need, without writing WHERE clauses. The other way to find what you need is the text search. It’s helpful if you don’t know which exact column contains the data you’re looking for. Regular expressions are available in the text search. Navigate through the data by foreign keys—you can go to the data your row is referring to and vice versa.

tableeditor

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. Do you want a particular part of code to be executed? Just select it and run. Execution plan is provided. Result-set is similar to the table editor with the same options available including adding/deleting rows, text search, and data navigation. Compare two result-sets in diff viewer.

executing

DataGrip is based on IntelliJ Platform which brings:

  • Text editor with multiple cursors and syntax-aware selection
  • Version control systems integration: Git, Subversion, etc.
  • Plugin ecosystem: Terminal, Textmate bundles, etc.

See DataGrip features page for CSV editor, diagrams, parameterized queries and more.

FAQ

Is DataGrip available via JetBrains ToolBox as part of the “All Products” pack?
Yes, it is available both as a Single IDE and as part of “All Products.” If you already have “All Products,” you can already use DataGrip.

Does DataGrip repeat the functionality of the database tools in other JetBrains IDEs?
Yes, the first version focuses on that core functionality.

Can I use DataGrip with SQL dialects that are not listed?
Yes, JDBC driver is the only requirement.

Are stored code debugging, administration tools and NoSQL features planned?
Yes, we’re going to add this functionality in future versions.

Can I suggest a feature or communicate my feedback?
Yes! Please talk to us via the feedback form, issue tracker, community forums, and Twitter.

Yours,
The DataGrip team
_
JetBrains
The Drive to Develop

Comments below can no longer be edited.

120 Responses to DataGrip 1.0 (formerly 0xDBE): A new IDE for DBs and SQL

  1. Rymson Balentien says:

    December 16, 2015

    I love 0xDBE and I’ve used it quite a lot this past year, submitting bugs and feature requests whenever I felt it was appropriate, and I want to congratulate you on your v1 release! That said I’m not sure yet I feel as 0xDBE was ready to go live..We are still missing important schema information within the tool (triggers and constraints being the most important). I’m also not sure if the text-only explain plan cuts it, as the ‘raw desc’ column which sometimes contains useful information is unreadable, as it contains too much information (SQLSERVER). Are these features still being worked on? I guess I’ll sit 0xDBE out until january 9th, when my current install expires and see what to do from there. The only issue is that I can’t see myself working with SSMS anymore either.. 🙂

    • Rymson Balentien says:

      December 16, 2015

      I just wanted to add that even though there are some issues I still think 0xDBE is currently the best tool out there!

      • Don says:

        December 19, 2015

        Have you tried DbVisualizer?

    • Maksim Sobolevskiy says:

      December 17, 2015

      Thank you for your feedback, Rymson! Since you are one of the most active EAPers and, in fact, our advocate, we plan to give you a one year licence for DataGrip for free.

      • Rymson Balentien says:

        January 7, 2016

        Dear Maksim,

        I’m sorry I am replying this late. I missed this comment. Indeed I received a license from you guys for which I am very grateful! I’ve recently switched jobs so I haven’t posted many bug requests, but don’t worry I will stay as active as ever before (as well as get my colleagues to use it as well!)

        • Maksim Sobolevskiy says:

          January 11, 2016

          Ha! Thank you so much! You are the person whom we really appreciate. I hope you like your new job! 🙂

    • Maksim Sobolevskiy says:

      October 31, 2017

      Some time passed and now we support triggers and constraints 🙂

  2. Graham says:

    December 16, 2015

    This repeats the functionality in Intellij, but does it add any more features over and above Intellij? If they are equal right now, will that always be the case? Would be nice to see a feature comparison chart.

    • Andrey Cheptsov says:

      December 17, 2015

      The latest version of IntelliJ IDEA Ultimate includes the functionality of DataGrip 1.0. Still, DataGrip is focused on working with databases and SQL and thus may provide better user experience as a standalone IDE.

  3. trailmax says:

    December 17, 2015

    How large the databases can this tool handle? I’ve got a DB with hundreds of tables, with hundreds of fields inside of each table, many thousands of views, sprocs, functions. Many third-party tools just choke on this monster, only SSMS barely handles it. Can your tool handle large set of objects?

    • Maksim Sobolevskiy says:

      December 17, 2015

      Hi! We can handle this kind of databases. So, please download a trial and make sure of it. If there would be some troubles we are always glad to help.

      • trailmax says:

        December 17, 2015

        ah, nevermind. Can’t even connect to local sqlexpress instance.

        • Maksim Sobolevskiy says:

          December 21, 2015

          Why? What is the problem?

          • trailmax says:

            December 21, 2015

            I get “Unable to connect to the instance because there possibly network issue blah-blah…”. But instance is online, TCP/IP connectivity is enabled and I can access it through SSMS.
            Possibly issue with SQL Server 2008RC2 – quite dated now, but suspect the jdbc drivers are crap – I’ve spent hours fighting them trying to get TeamCity to work on SQL Server.

          • trailmax says:

            December 21, 2015

            Drop me an email to trailmax1@gmail.com if need more info for debugging.

        • Maksim Sobolevskiy says:

          December 22, 2015

          Hi! Can you please provide a screenshot of connection window?
          Very often case is when the port number points to the other place than an instance name, and port number has a priority.
          If you still have problems, let’s continue via email.

          Is it possible to connect with JDTS driver?

          We actually support 2008RC2.

          • trailmax says:

            January 18, 2016

            Sorry, missed this message. I don’t get notifications for some reason.

            Here is the screenshot: http://i.imgur.com/CMq8hLp.png
            Now I’m trying to connect to SQL Server 2012 with Windows Authentication – just the same as with 2008R2.

            I have TCP/IP connections enabled on both instances (2008R2 and 2012) and SQL Server Browser has always been turned on – as Anton suggested below.

        • Anton says:

          January 9, 2016

          I’m not a developer of this program, but faced with the same problem.
          Next two steps:
          1. Enable tcp/ip in sql server configuration manager
          2. Enable SQL Server Browser service (stopped by default)
          Helped me solve this problem

        • Maksim Sobolevskiy says:

          January 20, 2016

          Max, let’s try the following at first: just remove the port number and try to connect.

          • Tate Griffin says:

            February 14, 2016

            Removing the port and only specifying the host and instance worked for me.

    • Bruno Paschoali says:

      February 15, 2016

      Hi.

      Problably, your problem is firewall blocking the port that you are using. Try to desativate firewall just for test.

  4. Mihai says:

    December 17, 2015

    This sounds great. What I need it to be is a competitor to Sql Server Data Tools.

    It should let me write only the create table statement (or stored proc etc) and automatically diff with a deployed database. From that it needs to generate an update script that I can use on that database. If this is not already there can we get a youtrack request for this and +1 it?

    Obviously it must have version control and the smart suggestions we’ve come to expect from JetBrains.

  5. Leo Lozes says:

    December 17, 2015

    Just tested it for a few minutes, hoping that I could dump Toad and use this instead. The first things I noticed:

    – There’s no editing in the result grid when you execute a statement from a table with the ROWID attribute (like Toad does). It’s pretty useful.
    – The XMLTYPE editing doesn’t seem to work well, I get an [72000][1461] ORA-01461 error.
    – The PL/SQL packages are not parsed correctly, almost everything is in red.

    On the other side:
    – Very easy to configure, I got my three connections working in 5 minutes.
    – The autocomplete works great.

  6. Albatros says:

    December 17, 2015

    Is there any support for sqlite in the future

    • Maksim Sobolevskiy says:

      December 17, 2015

      We have SQLite support.

  7. Michal says:

    December 17, 2015

    Will thee be some community version or student license?

    I have used it a lot with postgres, I have got quite used to it.

    Thanks

    • Maksim Sobolevskiy says:

      December 17, 2015

      There is no community version but you can always get a free license as a student.
      Check this please https://www.jetbrains.com/student/

  8. Jake Pogorelec says:

    December 17, 2015

    I have been using 0xDBe for a long time now and they even implemented DB2 on iSeries when I posted it (They were currently only supporting DB2 on Linux) Anyhow I really love using this product!

    • Maksim Sobolevskiy says:

      December 21, 2015

      Thanks, Jake!

  9. Jerry says:

    December 17, 2015

    What are the current plans for No SQL support? I’d love a legitimate IDE tool for working with Mongo and Cassandra

    • Maksim Sobolevskiy says:

      December 21, 2015

      Surely, we shall start from most popular NoSQL dbs, but for now there are not particular plans.

    • Mani says:

      December 25, 2015

      Also looking for something like this.

      Currently use NoSQL Manager (for both mongodb and cassandra) which works well. http://www.mongodbmanager.com/

  10. Charlie says:

    December 17, 2015

    Can you import and export excel sheets? Map columns on import?

    • Maksim Sobolevskiy says:

      December 21, 2015

      We have no import excel sheets. What about exporting, there is an export to CSV and if the tab is a separator, excel will open this kind of file.

      • Charlie says:

        December 29, 2015

        I was showing data grip to our database guy at work and this is the first feature he asked for. There are many times when someone will hand him an excel sheet and he needs to import it into our database. Half the time the columns don’t line up exactly so being able to map them on import is a must. Exporting is not a likely as high as a priority, but I’m sure it would save time being able to hand someone an excel sheet back instead of having to do the manual conversion first. He currently uses SQL Studio with SQL Server, but we’re thinking of migrating to Postgres and looking at alternative software. I use Intellij Idea so this is why I had him try out Data Grip.

  11. Steven Barnett says:

    December 17, 2015

    Seems I’m way to thick to use this product. While SQL Management Studio opens and connects without problems, I’ve not found the magic words that allow me to connect to my local SQL Express instance using DataGrip. I did manage to get at a SQLite database though, so there is hope for me yet! Guess I just wait for a FAQ or some kind person to post clues on stackoverflow.

    • Maksim Sobolevskiy says:

      December 22, 2015

      Hi, Steven! Can you please provide a screenshot of connection window?
      Very often case is when the port number points to the other place than an instance name, and port number has a priority.

  12. JetBrains unveils DataGrip 1.0 - SD Times says:

    December 17, 2015

    […] “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. […]

  13. Billy Cravens says:

    December 17, 2015

    Been running latest versions on up-to-date beefy MBP, and it crashes without warning. Possibly a Java runtime issue? (I think I’m using OSX’s stock)

  14. Ali says:

    December 17, 2015

    I’ve been using the 0xDBE since Dec 2014, alongside Intellij to connect to my hadoop clusters. Its been great. Curious if datagrip will be treated similar to PyCharm, where most of functions will be available as a plugin for Intellij?

    • Maksim Sobolevskiy says:

      December 21, 2015

      IntelliJ IDEA has all DataGrip functionallity.

  15. laispace says:

    December 18, 2015

    Nice!

    Any plan for supporting nosql such as MongoDB?

    • Maksim Sobolevskiy says:

      February 15, 2016

      Far plan, but not in closest releases.

  16. DataGrip 1.0 erschienen: Ein UI für's leichtere Managen der Datenbank - JAXenter says:

    December 18, 2015

    […] Version 1.0 ist mit den verbreiteten Datenbankmanagementsystemen von Oracle, Microsofts SQL Server, MySQL, PostgreSQL und einigen weiteren kompatibel. […]

  17. Dev says:

    December 19, 2015

    No Visual Studio extension?

    • Maksim Sobolevskiy says:

      December 21, 2015

      For now we do not plan to implement it as a VS extension.

  18. Don says:

    December 19, 2015

    Ok, gave it a go.

    What it is done right:

    * UI
    * Master password
    * Driver management
    * Data result extractors

    What needs to be improved (must haves for our use case):

    * table/field name substitution in the query, to avoid typing
    * database exploring capability – tables, views, constraints
    * anonymous sessions. not everything needs to be a file
    * folders for database connections – with 60 odd databases configured it is hard to find the right one
    * A keyboard shortcut to open up a new tab for a connection
    * ability to limit the output lines (impractical to select all 100k lines just to see if the query works), not all DBs support limit clause
    * ability to switch connections for the open tab

    Get in touch with me directly if you’d need more input how to make a dev’s work more productive

    • Don says:

      December 20, 2015

      * table/substitution turns out to be there
      * Database exploring capability is there.

      It is unclear though as to when and how these become available. After the schemas were manually set?.
      So if there is an issue – there is no indication of it.

      * The row limit is there but it is a setting somewhere deep in the menus. One can not change it for the next run that easily

      • Maksim Sobolevskiy says:

        December 21, 2015

        Don, thank you for the feedback.

        * anonymous sessions
        * folders for database connections
        * ability to switch connections for the open tab
        Useful and we shall think, thanks!

        * A keyboard shortcut to open up a new tab for a connection
        Here you can do the following:
        Windows/Linux — Ctrl+Alt+Shift+S → Alt+Ins
        Mac — Cmd+; → Cmd+N

        For all features you can create tickets in issue tracker and people will vote for them.

  19. Jerry Boonstra says:

    December 22, 2015

    I’m trying to upgrade from 0xDBE to DataGrip, but it can’t find my 0xDBE settings. Known problem or just me?

  20. Tim Bissell says:

    December 22, 2015

    I like using OxDBE as a pure database access tool when firing up Idea is too slow…

    One feature I would like is to be able to see the passwords stored in the data sources; useful if you want open the database in a different tool, and you can’t remember what it is…

  21. Carlton Dickson says:

    December 23, 2015

    Was hoping that you would create a DB client as the existing ones are average, so it’s a nice surprise to see this released. PHPSTORM smashed existing PHP IDEs out of the park so hopefully this will do the same.

    Is it possible to change the background/theme per data source (I do this to remind myself I’m on TEST/LIVE DB connections :))

    I guess an alternative is to make the connection read-only.

  22. Brandon Lamb says:

    December 24, 2015

    Hey there, we are using DB2 on iseries/ibmi/as400/systemi (so many names) and we make extensive use of stored procedures.

    It seems there is difficulty in calling a sproc that has an out parameter.

    CALL api_my_sproc_v1_0 (”, ‘ENG’, 10, 0, ?);

    2015-12-23 19:38:09] [42886][-469] [SQL0469] IN, OUT, or INOUT not valid for parameter 5 in procedure API_MY_SPROC_V1_0 in *N.

    Is there a trick to doing this? using the jt400 open drivers and not the jdbc4

    • Maksim Sobolevskiy says:

      December 29, 2015

      Thanks Brandon for the feedback. We know about this inconvenient thing, but for now we cannot say if we will create something in the close future.

      • Maksim says:

        February 10, 2016

        Maksim, got the same problem.
        Could you please fix that

  23. Vantis says:

    December 29, 2015

    Hi, I got a trouble while adding a new data source.

    there should be more databases in “Data Sources and Drivers/Schemas” tab but I cannot find them. Only if I declared the database could I can see the database not displayed before.

    It’s an old SQL Server.

    • Maksim Sobolevskiy says:

      December 29, 2015

      Hi! Can you please provide the screenshot?

  24. cuibty says:

    December 30, 2015

    It does not support stored procedures?

    • Maksim Sobolevskiy says:

      January 11, 2016

      Hi! It does. What do you mean with “support”?

  25. butsupphu says:

    January 6, 2016

    I did manage to get at a SQLite database though, so there is hope for me yet! Where is this information?

    • Maksim Sobolevskiy says:

      January 11, 2016

      Hello! What information do you mean?

  26. Wayne says:

    January 6, 2016

    Maksim,

    Is there a way to view all the databases on the server?

    It seems like I can only see one database for each connection I establish. I would like an overall view of all the databases.

    Thanks,
    Wayne

    • Maksim Sobolevskiy says:

      January 11, 2016

      Hello! Do you use MS SQL? Try looking on Schemas tab in data source properties.

      • Mat says:

        January 13, 2016

        Hello, This is exactly what i was looking for. My only feature request here would be a select all button. At my company we have 50ish db’s on a MS Sql Server and I have to constantly switch to different ones based on the client I’m working for at that moment in time. So it would be nice to just say select all the Schema’s so I don’t have to manually go threw and select them.

        • Maksim Sobolevskiy says:

          January 20, 2016

          But it will become very slow in this case, won’t it?

        • Maksim Sobolevskiy says:

          February 15, 2016

          We are actually working on this, hope to have it in the EAP.

  27. Ivan says:

    January 29, 2016

    Hi,

    quick ask: Does it support PL\SQL? Because i didn’t see any of it on the documentation.

    Regards,
    Ivan

    • Maksim Sobolevskiy says:

      February 1, 2016

      Yes it does

  28. Alex says:

    February 1, 2016

    How can I view the triggers of a table?

    • Maksim Sobolevskiy says:

      February 2, 2016

      What DBMS do you use?

      • Gustavo Andrade Ferreira says:

        June 23, 2016

        I am using Mysql with datagrip and dont see any kind of trigger viewing or manipulation. The closest i can is to execute a SHOW TRIGGERS command.

        • Maksim Sobolevskiy says:

          June 24, 2016

          You can view trigger of a table in the table elements, like here: https://pp.vk.me/c633327/v633327435/319f6/I1x61SprYZs.jpg

          For now there is no possibilities to edit a source code, but we are working on it — we understand it is strongly needed.

          • Juan says:

            October 18, 2016

            Are you still working on this feature? I am trying to modify the triggers in the database and the tool is useless in this case. MySQL Workbench has it, but I would like to use the same tool for my basic needs. Cheers

          • Maksim Sobolevskiy says:

            November 9, 2016

            Juan, we do: it’ll be in 2016.3

  29. Vasily says:

    February 12, 2016

    Hi! I like your products, and they’re really fantastic, but with DataGrip I got some butthurt comparing to Navicat (which I’ve decided to leave because of lags, stupid scrolls and such problems of usability when using Mac version – on Windows it works really good)
    So, on DataGrip:
    Altering tables means pain. Too many steps for editing column, no way to change columns order – even if there is some, I gave up looking for it. Arrows is always grey, drag-n-drop displays line where to place column, but then do nothing. So I do it by raw SQL -> No profit from IDE.
    There is no Excel export. And don’t say about CSV, my clients use only Excel, and when it comes to transformation of CSV file encoding with cyrillic text from UTF-8 to what-ever-mac-excel-can-read – it’s pain and time loses.
    For my other workflows everything is ok:)

    • Maksim Sobolevskiy says:

      February 20, 2016

      Hi! Do you have MySQL?
      If yes, we supported reordering columns from UI (these arrows won’t be grey 🙂 expect it in 1.1.
      About Excel, we haven’t implemented it yet, please vote and watch this issue:
      https://youtrack.jetbrains.com/issue/DBE-95

  30. Nikos says:

    February 21, 2016

    I use webstorm, whats the best way to get this to fit in?

    Great news btw!!!

    • Maksim Sobolevskiy says:

      February 25, 2016

      The best way is to buy PHPStorm.
      There is not DB features in WebStorm.

  31. Josian Chevalier says:

    March 7, 2016

    Hey ! I’m not an expert in database management, but I have to admit I’m quite lost with this tool. I’m working on an oracle database, and I’m struggling to find functionalities for triggers or packages. Basically, I can’t see my triggers, nor add packages.

    I actually find it more instinctive and complete to use the database integration provided by the plug-in “DB Navigator”. I suppose most of the functionalities that I can’t find are available, but he difficulty of finding it makes it kind of unusable.

    The autocomplete is very efficient though, but I wouldn’t buy and IDE just to use it as an SQL editor. I absolutely loved all the JetBrains’ product I used, but this one feels like a beta version. I use the All Products Pack though, so I’ll follow the evolutions.

    • Josian Chevalier says:

      March 7, 2016

      Also, Importing my settings from PHPStorm completely fucked up the keymap, erasing most of the shortcuts. The same thing worked perfectly from PHPStorm to PyCharm and IntellijIDEA.

  32. Wayne Fehres says:

    March 15, 2016

    I just downloaded the latest trail version on a Mac (10.11.3). It refuses to accept my Active Directory credentials when connecting to a Microsoft SQL 2012 R2 server. I tried to enter it in several ways (ex: domain/username).

    This looks like a promising product for my team but I need to get this working first.

  33. Bill Dee says:

    March 28, 2016

    Can I export data to Excel?

    • Maksim Sobolevskiy says:

      March 31, 2016

      You cannot export directly to Excel, but you can export to CSV which can be opened from Excel.

  34. MENGMENG SUN says:

    April 6, 2016

    My DataGrip became super super slow since two weeks ago. Even typing a query in console can be frozen several time. When i’m working in DataGrip Most time it can consume up to 200% CPU and 1.5 GB memory. I’m using MAC Pro with 2.6 GHz Core i7, 16 GB DDR3 and SSD. I would like to attach some screenshots from Activity Monitor but I’m not able to.

    Any thoughts?

    • Maksim Sobolevskiy says:

      April 11, 2016

      Hello! We’ve fixed this in 2016.1, so you can download RC from here:
      bit.ly/1qy4C23
      or wait for the official release.

  35. Frank Opitz says:

    April 8, 2016

    I have trouble to dump data as sql insert regarding timestamps. For example when I execute my sql insert script on MSSQL server I get a conversion error converting a varchar to a timestamp. Is there a possibility to create a dump with correct timestamp formatting?

    • Maksim Sobolevskiy says:

      April 11, 2016

      Can you please give an example?

  36. Cvetan Simsic says:

    May 6, 2016

    Is is possible to import/export whole database through DataGrip? And if, how?

    • Maksim Sobolevskiy says:

      May 11, 2016

      Hello! It is not possible for now.

    • Maksim Sobolevskiy says:

      September 1, 2016

      Will integrate with dump tools in 2016.3

  37. A very important security update: DataGrip 2016.1.1 | JetBrains DataGrip Blog says:

    May 11, 2016

    […] issues inside IntelliJ Platform. The vulnerabilities, in various forms, are also present in DataGrip 1.0; therefore, patches for that version is also […]

  38. Tim Davis says:

    June 9, 2016

    Hi, does this product support PL\V8

    • Maksim Sobolevskiy says:

      June 17, 2016

      Do you mean using it in PostgreSQL?

  39. Quinton Viljoen says:

    June 22, 2016

    I want to use this, but I need Mongo support 😐

  40. carlos arana says:

    July 5, 2016

    in mssql server timestamp column is automatic and can be edited ,
    i receive this error:
    [S0001][273] Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.

    How can i force to not include the timestamp field in editor ? not hide please

    • carlos arana says:

      July 5, 2016

      sorry the timestamp fields in mssql server CANT be edited

    • Maksim Sobolevskiy says:

      July 8, 2016

      Please watch this: https://youtrack.jetbrains.com/issue/DBE-2842

    • Maksim Sobolevskiy says:

      July 23, 2016

      As we explored, it is working as intented due to SQL Server behaviour.

  41. sebastien says:

    July 10, 2016

    Datagrip looks very promissing
    I’ve been using Querious for 3 months and it suits me well, but i like intellij products and i wanted to test Datagrip.
    I had 0 problem connecting to my datasources, but i lost plenty of time trying to use mysql 5.7. The code inspection wouldn’t let me use ‘JSON’ types, it looks like something in the code inspection needs some update ? :/
    I also updated my mysql Driver but nothing helped. i posted a thread here :
    https://intellij-support.jetbrains.com/hc/en-us/community/posts/207588505-Drivers-outdated-for-Mysql-5-7?page=1#community_comment_207377725

    • Maksim Sobolevskiy says:

      July 11, 2016

      Do you use 2016.1 of DataGrip?

      • Dan says:

        July 25, 2016

        I’m using 2016.2 and it doesn’t work for me either. Mysql version 5.7.11

        • Maksim Sobolevskiy says:

          September 1, 2016

          We added JSON injection in 2016.2, please, try

  42. Data Guy says:

    August 26, 2016

    I love this tool.
    The code complete is great, I can write long SQL expressions really quickly now.
    After a few weeks of testing, the only issue that has me jumping back to dbVisualizer is that I can’t edit “cells” sometimes.
    Sometimes I can, sometimes I can’t.
    It’s not a data issue, I can’t even set them to null sometimes.
    I enter the value, it spins and thinks for a split second, then tells my “0 rows updated”.
    The table has a primary key id field and dbVisualizer can figure out how to update the value.
    Sometimes I can literally just try over and over and it will eventually work.

  43. Charlie Catney says:

    September 1, 2016

    We have a multi tenant environment where all our customers (> 2k) have their own DB with the same schema.

    Is there a facility to execute an SQL command on multiple databases (on the same server) at the same time?

    Ideally I would like a way to filter which databases to execute the command against.

    • Maksim Sobolevskiy says:

      September 9, 2016

      For we have no such functionality

  44. The Alchemist says:

    September 23, 2016

    I don’t wanna sound entitled, but here we go.

    I was a beta tester for 0xDBE and filed a few bug reports, with screenshots and stack traces and everything.

    I was hoping I would get a complimentary license as a result, or a discount or something. 🙁

    • Maksim Sobolevskiy says:

      September 28, 2016

      Hello! We sent free licenses for those who report bugs during 0xDBE period, yes. AS far as I remember we sent them to those who reported more than 6 bugs. Was it true for you?

  45. Shahbaz Anshari says:

    November 14, 2018

    this tool seems good. Can I use this for my website to fetch the customers data?

    • Maksim Sobolevskiy says:

      November 19, 2018

      Well, we think you can if your web-site uses the relational databases

  46. danish says:

    March 5, 2020

    i have 7 year experience sql server very power full and better support query and functions
    manipulation very good

    • Maksim Sobolevskiy says:

      March 19, 2020

      Thanks!