Skip to end of metadata
Go to start of metadata




Script Editor

Dialect sensitive editor for SQL and for Procedural-SQL script files (.sql, .plsql) providing advanced editing capabilities.

  • Language highlighting configurable in the "Colors & Fonts" IDE settings section
  • Code formatting, folding and bracket matching
  • Qualified code completion suggesting only suitable variants for the invoking position
  • Two configurable levels for code completion (to narrow down the suggested variants to the desired extent)
  • Sortable code completion variant-lists
  • Error highlighting for incomplete statements or invalid references to database entities
  • Basic structure projection in the "Structure" tool window
  • Statement execution triggers on editor gutter
  • Editor intentions (statement execution and selection of connection/schema for the current editor)
  • Navigation from resolved identifiers to the respective object in browser
  • Navigation within editor for aliases / variables (e.g. alias reference to alias definition)

   MySql Procedural-SQL is highlighted with the Oracle highlighter
   Identifier resolver still experiences issues and may report invalid references even though they are valid. A major redesign of the identifier-resolver is planned already.

see more


Connection Manager

Flexible database connectivity management.

  • Connections configurable in scope of project or module
  • Persistent mapping between connection/schema and sql scripts
  • Connection pooling for concurrent database access and dedicated connectivity (managed internally)
  • Silent connectivity restoring in case of database linkage breaks (e.g. idle session timeouts, administrative session kills)
  • Virtual connections for deciding the .sql dialect of the mapped file (no real database behind)

see more


Object Browser

Tool window displaying available connections and the database objects.

  • Tree-wise visualization of database connections and hierarchical objects structure
  • Contextual popup menu with supported operations on each database entity (e.g. compile, execute, refresh lists)
  • Several embedded navigation capabilities via context menu (e.g. from column to its constraints, from synonym to underlying object)
  • Accessors for database object editor and method execution operation
  • Navigation history and speed search capabilities
  • Highlighting of invalid objects, accessors for multiple-compile operation (identify invalid objects and fire compilation operation on them) **
  • DDL extraction to editor or to clipboard (deprecated feature - see ddl file creation in code-editor section) **
  • Lazy loading of database objects (objects are loaded only on demand from the database to save system resources)
  • Intelligent background loading strategy to ensure minimal waiting times for developer

see more


Code Editor

Highlighted code editor for program-objects (e.g. functions) and views

  • Editor for database functions, procedures, packages, types and triggers
  • Qualified editor for database views (advanced editing capabilities like code completion, folding, navigation, error highlighting)
  • Show changes facility (diff visualization for local changes and changes against database)
  • Basic team coding support to prevent blind overwriting on concurrent editing (if the edited object was changed by a third party since it was last saved, developer will be prompted to merge the changes)
  • Support for creation of DDL files for database objects
  • DDL file mapping - locating and aggregating project .ddl files with the database objects being edited (ddl files are automatically updated when object is edited)
  • Firing compile operation after updating changes to database **
  • Compiler error messages in the execution console with navigation to code (to exact row and column position) **
  • Navigable structure projection in the "Structure" tool window
  • Identifier highlighting (Editor settings: "Highlight usages of element at caret")

Note: Version conflict editors are not highlighted. Will be fixed in future releases.

see more


Data Editor

Tabular dataset editor for manipulating data in tables and editable views

  • Advanced cell editors for several data types (data choosers, calendar, large text editor)
  • Input validation and error highlighting (erroneous inputs are leniently notified by a lightweight error pop-up)
  • Data sorting (click on column header will switch the sorting order)
  • Gutter highlighting for unsaved changes (inserted, changed or removed entries are emphasized in the editor gutter)
  • Data export to file or to clipboard in several formats (sql insert statements, .xls, .csv)
  • Flexible data filtering capabilities (simple - list of conditions joined with AND or OR; custom - sql editor for freestyle "where" condition)
  • Quick filter suggestions (e.g. "filter by column value", "filter by clipboard value")
  • Transaction awareness when changing data (commit and rollback controls are being enabled for the corresponding connection)
  • Navigable structure projection in the "Structure" tool window
  • Smart editing (cell becomes editable right after being selected to skip annoying "double-click to edit")
  • Editing lock (for comfortable data browsing)
  • CLOB editor with configurable highlighting (supports all file types supplied by IntelliJ)**
  • Record editor

see more


Execution Engine

Statement and database-method execution, compile engine for database programs

  • Execution of sql statements can be fired directly from the editor gutter against the database mapped to the editor
  • Sticky linkage between statements in editor and execution result (navigation from the editor to the result and backwards is ensured even if the file is being edited)
  • Sortable query results in tabular form
  • Export of query results to file or to clipboard in several formats (sql insert statements, .xls, .csv)
  • Message window for failed statement executions
  • Executed statement preview window (useful when the underlying statement has been changed in editor)
  • Transaction awareness on execution of data manipulation statements (commit and rollback controls are being enabled for the corresponding connection)
  • Compiler engine for database program objects (functions, procedures, triggers, packages, types) **
  • Method execution engine for functions and stored procedures
  • Method execution history (execution arguments are persisted and can be reviewed/reused/deleted at any time)

Note: Configuration of execution processes is still pending.

see more


PL/SQL Debugger **

Full-fledged debugger for PL/SQL programs (procedures, functions, packages) based on the Oracle DBMS_DEBUG functionality.

  • Ensure debugging prerequisites (check for privileges, compile programs and dependencies in debug modus)
  • Add and remove breakpoints before and during debug process
  • Break/resume execution: step over, step into, step out, run to breakpoint, run to cursor
  • View and change variable values on suspended execution
  • Display cascading execution frames
  • Support watchers and expression evaluations (within the limitations of DBMS_DEBUG framework)
  • Store run parameters in method execution history

   No JDWP debugging supported yet
   Only execution of functions and stored procedures can be debugged for the time being (including package executable elements).
   Execution and debugging for file based PL/SQL code (PL/SQL scripts) is planned.

see more


** Oracle specific feature

  • No labels


  1. Anonymous

    The following table name is valid in pl/sql:


     But the # confuses the plugin.

    Rodrigo Gomez

    1. Hi Rodrigo,

      thanks for the feedback. Have created ticket for this and hope to solve it soon.

      PL/SQL parsing is still in early phase, hence you may encounter lots of other issues. Anyhow this was not known, so thanks.

  2. Anonymous

    This looks very promising. Are there any plans to support PostgreSQL? Or will it be possible to add additional "database dialects"/plugins or whatever by third party?

    Sincerely yours, Horst Weber.

    1. Hello Horst,

      the support for other databases is just a matter of time, yet there are other databases which are far more probable to be supported in the future. PostgreSQL is not so common, judged solely by the number of requests I receive in this regard. So I have to disappoint you, this will probably not happen soon.

      There is an api for new databases support of course, yet as it came out when migrating the plugin from Oracle to MySQL, extending it is not just implementing the interface. Each database behaves in its own way, hence some of the changes happen to reflect down to the very core of the application. And additionally, the parsing of a new SQL dialect is a very custom thing. The parser itself is a very generic implementation, but it requires an underlying xml definition, which must cover all possible syntactical structures. Quite an effort here as well. So again, not sure when or if there will be support for PostgreSQL.


      1. Anonymous

        Hello Dan,

         that's a pity. On the one side, I'm somewhat surprised that you don't get enough requests to support PostgreSQL. For me, I had several projects which used PostgreSQl and in some of them there were explicit requests by the customers to use it. But on the other side, looking at the lack of good literature from O'Reilly or Addison Wesley, it may suggest that you're right: it seems PostgreSQL generates less interest than it should be... (wink)

         Unfortunately, at present I don't have the time to offer my support to implement it. So I may have to wait and hope... (wink)

         And, to tell the truth: Most of the projects in which I'm involved in don't require such sophisticated tools. The JDBC Console and the "classic" way of doing the stuff "just works". But nevertheless, more would be nice and always welcome... (wink)

         Sincerely yours, Horst Weber.

  3. Anonymous

    Just dropping you a line to let you know I simply love your plug-in! Some really nice work there. My personal favorite is the PL/SQL editor which makes my life so much simpler.



    1. Thanks Arne, always good to hear that. This is the first feedback i receive so far regarding PL/SQL support. Feel free to report problems as well if you encounter any.


      1. Hi again. The only problems I have encountered seem to be related to parsing/introspection of the PL/SQL-code. I normally get a lot of red marks, even when the code compiles and executes on the DB. Here's a screenshot that illustrates three cases.

        This code actually compiles.



        Edit: Source code in text format for your convenience.

        1. Hi Arne,

          thanks for the issue report. It is true, the PL/SQL parser is not finished yet. There are several syntactical structures which are still missing or incomplete, especially concerning expressions. As a result, all the red marks, despite the fact that the code is compilable. Now i will for sure try to fix all these issues but don't know how soon cause i am pretty busy with other things right now.

          One question out of my curiosity, how are you editing the packages / procedures? Are you changing the ddl files and running them against the database or editing directly the objects in database and using the ddl linkage mechanism to automatically update the ddl files?


          1. Hi Dan,

            Great to hear that work is in progress regarding this. I can't tell you enough how much your plugin has helped my in my daily work already.

            I usually work on DDL files and run them against the database. I find that this is most effective for my workflow.

            Thanks again, looking forward to future updates.



            1. Hello Arne,

              thanks again for your appreciation.

              Regarding your usage, I would advise you to use it the other way around, i.e. editing directly the database objects. This way you can benefit from some other little gadgets like navigation to code in case of compilation error, basic team coding support (you can not overwrite concurrent changes from third party - you will be forced to merge the code). In addition to this, you can link your ddl files to the edited object, so they automatically get updated when you save the changes to database. Give it a try, it's worthwhile.


              1. Thanks for the tip, I will try it out for sure!

                Best regards,


  4. Any chance we will eventually see these tools outside of Idea, perhaps on the .Net side or as stand-alone tools?
    I know that there are tools that already do some of this stuff for t-sql in the .Net world (RedGate comes to mind) but they seem buggy and fall far short of the ease of use I am accustomed to from a JetBrains product. I would hope that a lot of the parsing/formatting/highlighting/connection mgmt etc stuff could be re-used, though I am sure it would not be trivial.

    1. Hi David, unfortunately not. This tool was implemented around the language api provided by JetBrains, and removing it from this context would be hell of a work. And I am not really sure I want to do that, because having this strong functional base was mainly the reason for doing this in the first place. And besides of that, providing a standalone version would also slow down my further development if I would need to maintain two or more code bases. But what prevents you from using it with intellij?

      1. Ok, what you wrote makes sense. I suppose the language apis in intellij and those in resharper are quite different. I could use intellij, but as a .Net developer I use Visual Studio with ReSharper, and don't currently have a license for intellij. It seems a pricey license to buy just for the db functions, but I will keep my eye on it!

        1. Hi David, when i started doing this, the language infrastructure was pretty java-centric, but I know that this considerably changed with intellij 8 and became more generic. I think the basic idea behind was to make a JB cross platform language engine. So I wouldn't be surprised to see the same language api in resharper. But I can not tell for sure because I never saw it. But I am sure this is the case for RubyMine and MPS. Their user interface is very similar to IntelliJ.

          Would be nice if JetBrains would have an even more flexible licensing model, i.e. providing a java-less "host" platform with all the plugin and custom language support.

  5. Anonymous

    Hi I'm trying to add my DB2 data base in Database Manager but it fails because of the licenses.

    This is my configuration:

    In diver Library I'm pointing the

    Unknown macro: {Home_Project}

    \lib\db2\db2jcc.jar and
    the driver is
    my Connection url is jdbc:db2://MY_PATH:8300/(DB_NAME).

    Now when I click test button it said "No license was found. An appropriate license file db2jcc_license_*.jar must be provided in the CLASSPATH setting" The thing is that I have the licenses jar but I don know how to set them into the classpath.

    Someone can help me with that?

    1. If you try to use Database Navigator plugin with DB2 this will not work, because it only supports Oracle and MySQL for now.
      But are you sure your issue has to do with this plugin? The way it looks like you are trying to setup a connection in the IntelliJ connection manager. So you might be wrong by posting this here. Please address this issue to the support forums for IntelliJ.

    2. Anonymous

      This has nothing to do with the plugin.

      You should do exactly what it said: inlcude the license jar in the classpath.

      It should be beside the db2cc.jar (in my case it is called db2jcc_license_cu.jar).

      Please, inform me if you managed to use the plugin with DB2.

      1. I understand your problem. Nevertheless the plugin only supports Oracle and MySQL. So trying to setup a connection for DB2 is absolutely pointless.

        DB2 will be probably supported in the future, but it is not certain how soon.

  6. Anonymous

    I hope the plugins developer(s) read comments for this page. Plugin doesn't work with Web IDE 94.48, see screenshot in Web IDE bugtracker

    1. Was not aware that it is not working with WebIDE. I never tested it but with IntelliJ, and I figured it should work with all it's related products (they share the same code base). I will provide a fix for this soon. Try using it with IntelliJ community edition so long.

        1. Thanks for the hint! I fixed the compatibility issue with WebIDE in release 3.0.1753.

  7. Anonymous

    It´s the same Problem with the RubyIDE. The Plugins is disabled and if you enable it, it is ignored.

    I´m using it on Mac OS X with Java 1.6 and RubyMine 2.0

    1. As mentioned above, i fixed some compatibility issues, still I tested only with WebIDE. Can you please give it a try. Thanks!

  8. Anonymous

    trying the plugin (build 1757) with RubyIDE , jdk 1.6 on ubuntu and I have still the same problem. good luck ;(smile)

    1. Well i identified the issue, but there is nothing i can do. This seems to be a bug with RubyMine. If you install the plugin via plugin manager, it will get the binaries for IntelliJ 8.0, which are of course not compatible.
      You should try to install the plugin manually by getting the version flagged with "Since Build" 90.10000. But additionally you need to remove the tag <idea-version.. from the plugin.xml descriptor contained in the DBNavigator.jar and then it will work. If i remove it myself, the versioning will then be misinterpreted on the plugin repository site.

      1. Anonymous

        thanks a lot, it is working now !!! Now I try to get the connection set-up !

        1. btw, the problem with RubyMine compatibility has been fixed now with the new version 2.0.1

  9. Anonymous

    i cant make the plugin work with a Sybase database. i manage to define a connection but i cant see anything in the DB browser - no schemas, no users, no nothing, just an empty tree.

    1. The plugin does not support Sybase. Even if you manage to define a connection, the mechanism for loading the data dictionary does not understand but Oracle and MySQL. This is not a generic implementation based on jdbc DatabaseMetaData, simply because it would be too slow. Support for Sybase will probably provided in the future...

  10. Anonymous

    How to setup connection with MySQL? I see the connector for Oracle (.WebIde10\config\plugins\DBNavigator\lib\ojdbc6.jar). Where is connector for MySQL? I tried with mysql-connector-java-3.0.17-ga-bin.jar from Mysql website and connection string jdbc:mysql://localhost:3306/ with no luck. The same connector and connection string jdbc:mysql://localhost:3306/<database_name> works well with bundled WebIDE Database Support plugin.

    1. The MySQL driver is not bundled. You have to get the appropriate one from the MySQL site.

      What user do you use? Try also "root" without password. The connection URL seems to be all right. Must be something like "jdbc:mysql://localhost:3306/mysql". What error message do you get when you Test the connectivity?

      1. Anonymous

        Sorry, I used url 'jdbc:mysql://localhost:3306/' (similar to your screenshot on this page for Oracle connection). When I added database name as I did with bundled WebIDE Database Support plugin and now all ok. Thank you for this great plugin! I hope in the future you will add support for PostgreSQL.

  11. Anonymous

    How do you get this working with Intellij 9?

     I see the db navigator tab but no way to get the rest of the features for editing, execution

    1. 1. Start by setting up a connection (Menu: DBNavitagor > Settings).
      2. Create a sql file (test.sql) and write some sql code
      3. Select the connection and schema in the header of your editor
      ... you should have handles for executing the statements in the editor gutter

  12. Anonymous


     Plugin works great with RubyMine 2.0 but FAILS on RubMine 2.0.1.

     Please fix.

    1. Hello,

      what exactly do you experience? If you did the plugin.xml trick i explained a few posts earlier (about the <idea-version.. tag), this will probably not work with 2.0.1. Try installing the plugin again. I tested it just now with 2.0.1 and it works. Please make sure you have the version 3.0.1757 of the plugin.

  13. Will it be in the future support for Oracle Database? (I want to replace functionality of Oracle SQL Developer with Database Navigator)...

    1. Well Rares, Oracle is the main database this plugin supports. It even started by supporting only Oracle. So go ahead, setup a connection to your Oracle database and see what you can do with it. But if you are looking fore features like creating tables and database objects other than by writing ddl scripts, there's not much support in that area.

      What did you mean by "replace functionality"?

      1. To answer to your last question: I want to use a single tool for database and while I'm using Intellij IDEA for writing code, I would like to use database support in the IDE.

        The functionality that I wanted is passing a role to the login process(like in SQL Developer) (e.g. as sysdba).

        1. There is not much you can do with this plugin if you intend to use it as a database administrator. It is mainly targeted for development, and less for database administration.

  14. Anonymous

    Cool plugin. Got it installed ok, got my connection defined and connected. Then discovered it doesn't support Sybase.

    Oh well. Any idea when Sybase might be supported? 

    1. Hello, I can not give a certain answer as to when Sybase will be supported, as I get so many requests for other databases as well. The other thing is I never set timelines, and I mainly develop driven by my own needs. Since I never came across Sybase, it was not really one of my priorities. What I planed though, is to support the generic SQL dialect ISO-92, and I think as soon that is in place, I will start building interfaces for the most commonly used databases.

  15. Anonymous

    I am using Idea IC 9.0.1, the operating system Linux Mandriva 2010. After I install this plug-in when searching for a class (for keyboard shortcuts Ctrl + N) and paste from the clipboard (using the keyboard shortcut Shift + Ins) an exceptionBlame Database Navigator:

        at com.intellij.openapi.keymap.impl.IdeKeyEventDispatcher$1.performAction(
        at com.intellij.openapi.keymap.impl.IdeKeyEventDispatcher.processAction(
        at com.intellij.openapi.keymap.impl.IdeKeyEventDispatcher.inInitState(
        at com.intellij.openapi.keymap.impl.IdeKeyEventDispatcher.dispatchKeyEvent(
        at com.intellij.ide.IdeEventQueue._dispatchEvent(
        at com.intellij.ide.IdeEventQueue.dispatchEvent(
        at java.awt.EventDispatchThread.pumpOneEventForFilters(
        at java.awt.EventDispatchThread.pumpEventsForFilter(
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(
        at java.awt.EventDispatchThread.pumpEvents(
        at java.awt.EventDispatchThread.pumpEvents(

     If I use the key combination Ctrl + V exception is not generated

    1. Thanks for the problem report. Will be fixed in the upcoming release.
      Please use the dedicated bug tracker if you want to keep track of the issues you report.

  16. Anonymous

    Hi, just started using IntelliJ IDEA and first thing I did was install this plugin!

    I've managed to get a connection setup (both 'Test' and 'Info' buttons return information) but under the DB Browser (or when I create a .sql file and select the connection) I cannot see any schema information...

    Specifically when I click the dropdown for the schema when editing the .sql file it says "Nothing here".

    I don't have full control over the setup of the database but can access it all from phpMyAdmin.

    Any pointers as to where I should look at getting this resolved? Can DB schema information be blocked within MySQL from being accessible to certain users via permissions? Should I be contacting the DB admim?


    1. Hi Roy, can you check whether you have access to the information schema?

      e.g.  select * from INFORMATION_SCHEMA.SCHEMATA using another tool with same credentials.

      If this returns no rows than you have to ask your administrator for more rights.

      Cheers, Dan

      1. Anonymous

        Hi Dan,

        Running that SQL query on the database via SQL-Front returns the error:

        SQL execution error #1142. Response from the database:
        select command denied to user: #foo# for table 'SCHEMAT'

        So defiantly does look like a permissions restriction.

        Cheers for the timely response!

        I'm looking at setting up a separate MySQL instance on a new development box, so should hopefully be able to sidestep the issue rather than go through layers of bureaucracy to get the correct permissions (smile)

        Cheers again,

        1. Hi Roy,

          Yes, probably it is easier to setup your own instance, yet, I do not understand what is the big deal in receiving read access to the information_schema. There is nothing you can do wrong about it.

          Something puzzles me though. How is phpMyAdmin managing to access data dictionary? Are you sure you used the very same credentials to access the database?



          1. Anonymous

            Hi Dan,

            Sorry for the late reply, haven't been checking back now that I had it up and running but came looking for some ideas of how to use the integration with .SQL files effectively.

            Anyway, phpMyAdmin - It's basically the curse of the overprotective (but by no means useless) DB admin! (smile) It turns out there's an extra layer of complexity with the authentication based on IPs.

            So when using SQL Front I was being blocked because the IP for my new computer (just joined the company) was being blocked.

            Sorry for any worry I caused!

            Loving it now that it's all up and running.

            Thanks again for the help,

  17. Anonymous

    Shame it does not work with MS SQL

    1. Just a matter of time. Stay tuned..

      1. Is MS SQL support still in the works?

  18. Anonymous

    Hello, I have a feature request, I already filled it in here:

    But it was made arrogantly clear by the devs that "we don't "lack" this doubleclick stuff - we won't do it *intentionally*". As they "strongly suggest you to try to learn our ways."..

    It would be a great feature though.

    1. Hello, you confuse this plugin with JetBrain's Database Support plugin. This is a completely different plugin( and has nothing to with IntelliJ's database built-in functionality.

      1. Anonymous

        Yeah, but it's similar as you can view the database structure on a docked window too, I'm just proposing an IMO useful feature.

        1. There are several navigation concepts behind double clicks on objects in the browser. It is highly unlikely that these will be replaced by a "paste object name in editor" feature. Besides of that I wonder why would one need such a feature when there is code completion? Moving the hand away from the keyboard to operate the mouse is so much inefficient. That is why IntelliJ people advise operating it mainly from the keyboard, and are putting all their efforts in making this possible.

  19. Anonymous

    Looks really good ,

    Only problem is when i try to write any SQL query and it hangs - Intellij becomes unresponsive and so not able to do much with this plugin.

    1. About the performance issues you experience, can you give some more details on your use-case? (i.e. database, operating system, hardware). There may be several reasons for performance problems, the one would be a slow database connection (provided you are editing a sql file which is mapped to an active database). While preparing code completion lists and while resolving identifiers in editor, the plugin lazy loads the relevant objects from the database. So you may experience slow editing at the beginning, but this shouldn't be the case after the objects are loaded. Plus the sql parser itself is doing some caching at the beginning, which also may result in unresponsiveness, but as soon as the "warm-up" phase is passed, there must be no issues with the editing.

      1. Indeed, there is a performance issue with code editing. A fix will be released soon.

  20. Performance issues fixed with release 3.0.1788

  21. Anonymous

    Downloaded latest version (3.0.1788 according to plugin.xml) and can no longer start IDEA.  In idea.log, I see:

    I am running IDEA Ultimate 9.0.2 (build #IU-95.66).

    sWhy does this plugin work for everyone else?

    1. Uh, that's an ugly one. Probably everyone else is having the same problem but no one complained so far. Thanks for reporting it. Will provide a fix tonight.

      1. Fixed with version 3.0.1790

        1. Anonymous

          Yep.  That fixed it.  Thanks. 

          But now that I've got it loaded and followed the directions to disable the IDEA SQL plugin, I can no longer use the iBATIS plugin that relied on it.  (sad)

          What will happen if I leave the IDEA SQL plugin enabled?

          1. Hello, you can enable the IDEA SQL plugin, the only thing is that SQL files will still be handled by DBNavigator plugin (with the limitation that it only supports Oracle and MySQL dialects). Not sure in what extent iBATIS uses the original SQL functionality. But give it a try.

  22. Anonymous

    Yes its affecting !!

    This plugin looks so cool that am dying to get it properly working on my m/c.

    Thanks a lot Dan for this.

    1. Well, the plugin is fixed now so give it a try. I certainly hope it will meet your expectations.

  23. Anonymous

    hey there, new to this IDE and plugins.  This plugin looks amazing, but I dont run any files locally, everything is done on the remote server.  Am I able to connect this to the database(I am running MySQL) on the server?  If so how would I set the database driver, and URL in the settings tab?  thanks in advanced.

    1. Hello,

      in order to login to a database you need a so called jdbc connector (a jar package provided by the MySQL vendors). You can find this on the MySQL pages ( Please download and unpack the tar file somewhere on your local machine. On the unpacked root folder you should find the driver library (something named like mysql-connector-java-5.1.13-bin.jar)

      Coming back to the connection setup screen:

      1. specify the path to the library in the "Driver library" field (you can browse to the file as well). As soon as you entered a valid path for the library you should be able to see a list of drivers in the "Driver" drop-down. The most suitable one should already be selected.

      2. the "URL" should look something like this:  jdbc:mysql://<>host name or id>:<port number>/<database name> (e.g. jdbc:mysql://hostname:3306/mysql)

      3. user name and password you should know if you already connected to that database. 

      [this relies on basic JDBC connectivity, if you are working with java, this is one of the first things you should learn about]

      Happy MySQL-ing... (smile) Please share your experience. Thanks!

      1. Anonymous

        Thank you so much.  Got it up and running..  Time to explore the plugin, thanks again...

  24. Anonymous

    Please add SQLITE support. Driver: org.sqlite.JDBC

    1. Well it is not just as simple as that. If you read the posts to this plugin, adding compatibility to another database is quite a complex process. But I'll do my best. May take a while though...

  25. Anonymous

    It is not working debugging the procs in oracle. It doesn't stop on break point. It always says missing permissions even though it has permissions.

    1. can you please double check this with your database administrator? I am pretty sure you do not have these privileges. The debugger can not properly initialize the Oracle debugging session. This is also the reason why the breakpoints get ignored. Normally it should break the execution at the beginning of the method without needing to set any breakpoint. Please check again. The privileges must be granted to you or to any of your granted roles. You can check this by navigating through your privileges and roles using this plugin.

      1. Anonymous

        Yes sir. I have those privileges. I can able to debug the same proc using SQL developer. Is there any log file created to see what is going on while the debugging the proc.

        1. Anonymous

          I think it is caused by this.

          java.sql.SQLException: Too many failed attempts of executing all-user-privileges. ORA-00942: table or view does not exist

          at com.dci.intellij.dbn.database.common.statement.StatementExecutionProcessor.executeQuery(
          at com.dci.intellij.dbn.database.common.statement.StatementExecutionProcessor.executeQuery(
          at com.dci.intellij.dbn.database.common.DatabaseInterfaceImpl.executeQuery(
          at com.dci.intellij.dbn.database.common.DatabaseInterfaceImpl.executeQuery(
          at com.dci.intellij.dbn.database.common.DatabaseMetadataInterfaceImpl.loadAllUserPrivileges(
          at com.dci.intellij.dbn.object.common.DBObjectBundleImpl$11$1.createResultSet(
          at com.dci.intellij.dbn.common.content.loader.DynamicContentResultSetLoader.loadContent(
          at com.dci.intellij.dbn.common.content.DynamicContentImpl.performLoad(
          at com.dci.intellij.dbn.common.content.DynamicContentImpl.load(
          at com.dci.intellij.dbn.common.content.dependency.SubcontentDependencyAdapterImpl.beforeLoad(
          at com.dci.intellij.dbn.common.content.DynamicContentImpl.performLoad(
          at com.dci.intellij.dbn.common.content.DynamicContentImpl.load(
          at com.dci.intellij.dbn.common.content.DynamicContentImpl.getElements(
          at com.dci.intellij.dbn.object.common.list.DBObjectListImpl.getObjects(
          at com.dci.intellij.dbn.object.impl.DBUserImpl.getPrivileges(
          at com.dci.intellij.dbn.object.impl.DBUserImpl.hasPrivilege(
          at com.dci.intellij.dbn.debugger.DatabaseDebuggerManager.getMissingDebugPrivileges(
          at com.dci.intellij.dbn.debugger.execution.DBProgramRunner.performPrivilegeCheck(
          at com.dci.intellij.dbn.debugger.execution.DBProgramRunner.access$000(
          at com.dci.intellij.dbn.debugger.execution.DBProgramRunner$1.execute(
          at com.intellij.openapi.progress.impl.ProgressManagerImpl$
          at com.intellij.openapi.progress.impl.ProgressManagerImpl$
          at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(
          at com.intellij.openapi.progress.impl.ProgressManagerImpl.runProcess(
          at com.intellij.openapi.progress.impl.ProgressManagerImpl$
          at com.intellij.openapi.application.impl.ApplicationImpl$
          at java.util.concurrent.Executors$
          at java.util.concurrent.FutureTask$Sync.innerRun(
          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(
          at java.util.concurrent.ThreadPoolExecutor$
          at com.intellij.openapi.application.impl.ApplicationImpl$1$
          2010-08-24 11:15:18,440 8764556 INFO - common.DBObjectBundleImpl$10$1 - Error loading data model
          java.sql.SQLException: ORA-00942: table or view does not exist

          1. Anonymous

            Hi Dan,
            If I execute this sql stmt, I can see connected user has "DEBUG CONNECT SESSION" and "DEBUG ANY PROCEDURE" privileges.

            SELECT LPAD(' ', 2*level) || granted_role "USER PRIVS"
            FROM (
            SELECT NULL grantee, username granted_role
            FROM all_users
            WHERE username LIKE UPPER('%&uname%')
            SELECT grantee, granted_role
            FROM dba_role_privs
            SELECT grantee, privilege
            FROM dba_sys_privs)
            START WITH grantee IS NULL
            CONNECT BY grantee = prior granted_role;

          2. You're right, you may have the privileges, but the plugin does not recognize that. This is because you do not have access to the system views DBA_SYS_PRIVS and DBA_ROLE_PRIVS.

            But this shouldn't prevent you from debugging your method. Is the method compiled with debug option? (the icon should show a small gray bug). The plugin should check this beforehand and prompt you if the procedure and/or its dependencies are not compiled in debug mode. Did you get the "compile" dialog? Otherwise check the option "Compile dependencies before execution" in your debug configuration.

            1. Anonymous

              I think it is calling wrong view "all-user-privileges" ??? instead of "user_sys_privs"

              java.sql.SQLException: Too many failed attempts of executing all-user-privileges. ORA-00942: table or view does not exist

              1. not really. "all-user-privileges" ist the internal name for the following sql statement (expected to load the privileges for all users):

                     sp.GRANTEE as USER_NAME,
                     sp.PRIVILEGE as GRANTED_PRIVILEGE_NAME,
                     sp.ADMIN_OPTION as IS_ADMIN_OPTION
                     DBA_SYS_PRIVS sp,
                     DBA_USERS u
                where sp.GRANTEE = u.USERNAME
                order by
                    sp.PRIVILEGE as

                Can you check whether you can run this statement with your credentials?

                1. Anonymous

                  I don't have privileges to access to dba_users. how ever if change to dba_users to all_users works fine. Following stmt works OK.

                  sp.GRANTEE as USER_NAME,
                  sp.ADMIN_OPTION as IS_ADMIN_OPTION
                  DBA_SYS_PRIVS sp,
                  all_USERS u
                  where sp.GRANTEE = u.USERNAME
                  order by

                  1. ok. for that there will be a patch today. For the main issue with debugging i do not have an answer yet. Please make sure your procedure is compiled with debug option.

  26. Anonymous

    Nice to have schema filters.

    1. Roger! will try to add this in one of the future releases. Any idea on how this should look like?

      - having a check-box list with all the schemas where some can be disabled
      - having the option to enter a name pattern for excluded or included schemas

  27. Anonymous

    This may be a premature report; I'm using PhpStorm EAP 96.1061. I just installed this plugin. Very very nice work. Just what I was looking for.

    The problem is I can't find any way to actually access the associated tool window. I went back and tried it on PhpStorm 1.x and there it was where I expected it. Actually when I restarted the 2.0 EAP the sql editor pane I had opened was still there. So everything seems in good order except a way to start it. The config panels also seem to work fine. 



    1. Hello Gordon,

      the plugin does not support the EAP versions of any IntelliJ related products yet. You were able to install it only because the version compatibility thresholds are not set correctly. I plan to upgrade it for the latest EAP version, but can not tell how soon this will happen. Please continue using it with the old version of PhpStorm, or get Intellij Community Edition to run in parallel with your main IDE for the time being.


      1. Thanks for the reply. Perils of using an EAP, quite reasonable. But I will keep an eye out for that upgrade.



        1. Hi Gordon. An EAP compatible version of the plugin is now available for download. Give it a try. Appreciate your feedback.
          Cheers, Dan

  28. Anonymous

    Nice, waiting for support for PHPStorm EAP versions.

    1. EAP versions for PhpStorm and other IntelliJ related products are now supported with version 3.0.1844

  29. Anonymous

    Hey, great plugin! Here's another vote for Postgres support.

  30. Anonymous

    I wish this was available for Postgresql! (smile)

    1. ok! I see what's going on here... (smile) my best to provide something soon.

  31. Anonymous

    I just upgraded to RubyMine 3.0. When I try to make a MySQL connection the driver library dialog won't let me select my JDBC driver jar. Everything is always grayed out :-/

    I'm on a Mac/Snow Leopard, if that helps.

    1. Not sure how this is possible. Can you please submit a bug report with a screenshot (, or send me an email? I am not aware of any logic disabling the driver library input fields.

  32. Anonymous

    Why there is no column defenitions in table tree view and in child structure tool window?
    I can't see dimensions and type of the columns at all... so I can't use this plugin without this simple functionality.. (sad)
    and +1 vote fore schema filter (regexp or something else)

    1. You can see the column type in the tree view (DB Browser) when you hoover with the mouse over or when you enable object properties preview (second button from the right in the browser window). But i agree, the column type and dimensions should be visible without having to take any additional action. I will change this for the future release. Generally any meaningful suggestion is welcome and will be implemented at some point in time. So far no one complained about the missing column details.

      Schema filter request is well noted..  (smile)

      1. Now i remember why I did not "publish" this feature. The browser looks somehow crowded with all the details.

        The feature was there from the very beginning, just disabled. Now you can enable it in the "Database Browser" settings. See version 3.0.1864.

  33. Exelent tool!

    And one more vote for Postgresql!  :)

    1. Early preview for Postgres support released a while ago

  34. +1 for Posgresql integration.

    Thanks for developing this tool!

    1. Early preview for Postgres support released a while ago

  35. Thanks for this database tool, its excellent !!

    and count +1 for PostgreSQL support please, thanks

    1. Early preview for Postgres support released a while ago

  36. Excellent tool!  The only problem I have with it is the ability to set Auto Commit to true.  From the Connection Settings-->Details tab, I can see the Auto Commit checkbox.  But, it is disabled(grayed-out).  Does anyone know how to enable that checkbox?  I have a database I want to access, but it does not support transactions.  Does this tool support databases without transactions enabled?  Thanks in advance.

    Environment: IntelliJ 11 on OS X Lion.

    1. Auto-Commit functionality has been implemented with release 3.0.2289. It is still in early phase, please report any issues you encounter.

  37. Hi Dan Cioca . I love the plugin, but I'm having a problem. I have a Joomla database and the default dates are represented like 0000-00-00 00:00:00. When I try to open a table with such a date I get the error: Database error message: Value '000-00-00 00:00:00' can not be represented as java.sql.Timestamp. How can I make it accept this date without canhging the table values?

    I have the plug in installed in PHP Storm 7.0 and DB Navigator ver 3.0 buil 2660.

    Hope you can help me.


    Federico Franco

      1. No. Not fixed yet. Seems to be a jdbc problem with 0.00... timestamp values. I will have a look.

  38. Doesn't support postgres. Please vote on: DBN-205 Support Postgres

  39. Using against Oracle 11g. From the context menu of a stored procedure, I can select Edit code and view the code for the SP. However, if that SP code changes on the database, nothing I can do will refresh the code to the latest version in the database. I have tried:

    • Disconnect/Reconnect to the database
    • Refresh the schema, all procs, the specific proc

    I can even use the compare code to compare against what is stored in the database, and it will give me the diff. I don't have edit capability on the proc, so I cannot copy the code from the diff and paste it into my editor.

    The only thing that works is restarting IDEA. I figure I am missing something...


    1. Have you tried "Reload" tool button in the editor header?

      (the third button from the left on the top of you procedure editor)

      1. I guess I tried all but that. ;) Yes, that solved my problem. Thanks.

  40. Hey,

    Is there anyway to set a keybind to execute the query which i'm positioned in? when i click "ctrl+Enter" this plugin executes all queries on the page, but i just want one of them.. the one i'm positioned in..

    thanks in advance

    1. If the cursor is really positioned inside of a statement (not after the statement), the system will execute only that particular statement.

      Will try to improve this logic so it gets more closer to what one would expect (i.e. when positioning the cursor next to a statement, it should execute that statement only). 

      1. Hi,

        Yeahh you are right, i was executing statements after the ";" soo the system was executing all statements..

        btw, im getting lots of this:

        Could not execute SELECT statement. Value '228û0000-00-00 00:00:0000"material_request_rejection_subjectRejeição de RequisiçãoRejeição de Requisiçãoû can not be represented as java.sql.Timestamp - Connection ...

        any help?

        Thanks once more :)

        best regards

        1. Hi João,

          i would need to know more about the database (incl. version) you are using and the data type of the columns you are selecting from.



          1. Hi,

            my database server is MySQL 5.1.39-community

            for that table i have:

            - int, timestamps, varchar and text

            1. Can not reproduce the issue. Seems like the result set is corrupt and contains all row data in one column. Can you try using another jdbc library (try using JDBC Type 3).

              If that doesn't work please file an issue report (, adding a ddl statement for the table you are querying and eventually uploading the jdbc library you are using.

              (please create an account if you want to be able to follow the progress on the issues you report)

  41. How do I connect to postgres on Rubymine. It's asking for Driver Library and Driver. What should I put there?

    I'm using RubyMine for Mac OS X Yosemite.


    1. You need to download the appropriate jdbc driver library for your database from (preferably the jdbc 3 driver).

      The Driver will be selected automatically as soon as you enter the path to the library you downloaded. (e.g. C:\Programs\PostgreSQL\9.3\jdbc\lib\postgresql-9.3-1102.jdbc3.jar)

      The URL should be something like jdbc:postgresql://localhost:5432/<your database>. Please change host, port and database name accordingly.

  42. Hello,

    I was wondering if there is any way to change the theme of the editor? I'm using Dracula on 14.0 and it looks terrible and almost hurts the eyes:

    Sorry if this is obvious, I looked around the settings but couldn't find this..


    1. Have released dark scheme support long time ago. You have most probably custom values in the colors&fonts settings. Look for Settings > Editor > Colors & Fonts > Data Grid (DBN). You should be able to reset to defaults and start from there with customizing. 

      Cheers, Dan

  43. Hi, I've been a long time user of Database Navigator.

    Recently I upgraded to IntelliJ 14.0.3 and now IntelliJ's own plugin "Database Tools and SQL" seems to take it over. (and that is not as good/user friendly as yours, by far)

    After the upgrade (from 13) your plug in was even no longer installed!

    I installed it again, but I don't know how/where to "enable" it.

    In my "Database" tab I always only see the IntelliJ plug in's settings.

    Can you help?

    1. Hi Geert,

      try opening Settings>Plugins, see if the plugin is in that list (potentially disabled). If you see it try enabling it. See also if you have the option to update it (i just released a new version yesterday). 
      Otherwise "Browse repositories..." in the same window and look for the plugin.

      Please let me know if that worked.


      1. Hi Dan,

        Thanks for answering.
        Yes, your plugin is enabled. The version is 3.0.3791.
        (I'd like to disable the IntelliJ plug in, but I can't since other plug ins I need (eg. Jetty integration) rely on it.)

        I just want to use Database Navigator to edit my database tables instead of IntelliJ's plug in.

        1. Hi Geert,

          I still fail to understand what the problem is.The two plugins should coexist freely without interfering with each other. I know of many users having both. Yet the *.sql file type is taken over by my plugin (unless configured differently by the user)

          Do you see the "DB Navigator" menu entry next to Help? And the "DB Browser" tool window on the left side?
          Note: The "Database" tool window is from the IJ plugin. You should not expect to open tables from there with the DBNavigator plugin. 

          1. Hooray! It seems to be working again!

            >> Do you see the "DB Navigator" menu entry next to Help?
            I did and do.

            >> And the "DB Browser" tool window on the left side?
            >> Note: The "Database" tool window is from the IJ plugin. You should not expect to open tables from there with the DBNavigator plugin.
            After all, that was what I was (unintentionally) expecting.
            My DBNavigator tool window - never really paid attention to its name - has always been on the right side.
            After the update, I searched it over there again, found a "Database" tool window and tried to make it work (again).
            After your comment I went to the "DB Browser" tool window on the left and could make everything work again as before. Phew, what a relief!
            My apologies and thanks for your help (and your great plug in)

  44. Hi, I run into some trouble with forward declarations in a package body. It's not my favourite feature of PLSQL, but sometimes you need it.

    It is not recognized by the code editor language highlighter, but it seems to give more troubles. Small packages can still be compiled, but in larger packages it seems to break the functionality of the package editor. An example of this is the package body of PLOG_OUT_AQ of the LOG4PLSQL package (

    I'm on IntelliJ IDEA 14.1.4 with the latest plugin.

    1. Hi Paul,

      do you have some code examples which are not correctly parsed / highlighted? i don't have the LOG4PLSQL in my environments to test.
      Ideally you create a ticket in the request tracker with all the information ( This way you can keep an eye on the progress..


      1. I created and included a simple example.

        At this moment I can't reproduce the situation where this breaks the functionality of the package editor.

  45. Hi,

    i have a question - is it possible to extend the support to the H2 database?

    It has the ORACLE mode - so i can specify the URL like this:


    And it will be accessible like an ORACLE - so many stuff will be available - like ROWNUM and so on..

    The main problem that when i try to specify an H2 driver - it says that driver is not right for Oracle and block to add a connection...


  46. I'm working with Postgres 9 and it does not show all schema. I have db with 7 schema (that can be easily browsed using other tools - DBVisualizer for ex.) but in DB Navigator, it come up with 1 schema only. Could you help to check?

  47. Hello, are we able to setup a connection using JDBC connection string?

    I am trying to setup a DB Conn that uses TCPS..

    1. Hello,

      can you try "Custom..." option for creating a new connection? You should be able to enter the jdbc url of your choice.
      If this doesn't work please provide me with the url pattern. I know there are some limitations here,


  48. Looks like the last time it was mentioned was in 2009.  Are there any plans for DB2 support in this plugin?




  49. Hi Dan,

    first of all great plugin. I started using it a couple of weeks ago and it just works as a charm. I found a minor issue that is very annoying, I'm having trouble with DDL statements for Oracle. For some reason it reports "false" errors on most DDL's like create or alter table for example.

    Here are some examples:

    • On an alter table to add a column like Alter Table some_table add column_name column_type; I get expected: SUPPLEMENTAL.
    • On a create table statement I get: expected one of the following: EDITIONING,  FORCE FUNCTION NO OR PACKAGE PROCEDURE SEQUENCE TRIGGER TYPE VIEW identifier.

    I`m using IntelliJ IDEA 15.0.4 on Mac OSX El Capitan

    All the best,


  50. Hello everybody.

    I found a plugin bug, which greatly hinders the work.

    Link to request created by me:

    Thanks in advance for your reply.

    Version plugin: 3.0

    Build: 5901

  51. After update to last PHPStorm EAP (163.3983.3) templates system in IDE started to fail each start of IDE. Can't load Live Templates page in settings, storm says that it can't load laravel-form.xml, after moving that xml - says that can't load bootstrap3.xml template. After moving all except user templates - then says can't load user templates .xml.

    Found that this plugin was the issue by this method: moved all plugins, started IDE - all ok, templates ok, settings/live templates ok.

    Moved half of plugins, started PHPStorm - if loaded normally - then moved next half of what's remains. Then located, that after adding plugins/DBNavigator IDE is crashing.

    After removing plugin all normal again.

  52. Hello, 

    I created bug on your tracker:

    Fix it, please.

    I would like to ask a question about the functionality.

    When you enter the code, and auto-activation schema.TABLE table introduced exclusively in upper case.
    Whether it is possible to choose the configuration register tables and fields?

    Thanks in advance for your reply.

  53. Excellent plugin! Great work!

    Thank you very much (smile)

  54. Is it possible to include schema name into the connection settings?

    (I have an Oracle DB with ~1K schemas and selecting a needed one after reconnect is a bit difficult)

  55. Is it possible to include schema name into the connection settings?

    (I have an Oracle DB with ~1K schemas and selecting a needed one after reconnect is a bit difficult)

  56. Is it possible to include schema name into the connection settings?

    (I have an Oracle DB with ~1K schemas and selecting a needed one after reconnect is a bit difficult)

  57. Is it possible to include schema name into the connection settings?

    (I have an Oracle DB with ~1K schemas and selecting a needed one after reconnect is a bit difficult)

    1. Hi Bogdan,

      There are several filtering capabilities in the connection settings. You could narrow down the list of schemas to the ones you are interested in.
      You can also use "quick filters" in the context-menu of your schema list.

      Pls let me know if one or the other works for you.


  58. Hey,

    this plugin does not work on IntelliJ Version 2018. (sad)

    1. Hi Steven,

      there is a 2018 compatible build in the repository. You probably have upgraded IJ to 2018 and still have the old DBN build. Try reinstalling DBN from the plugin manager.

  59. Hi Dan,

    as I wrote on the Plugin-Page (but I think it's busier here), are there any chances, you could implement SSH-Config support for this great Plugin?

    Best regards,


    1. Hi Willi,

      have you tried out the "SSH" tab in the connection settings? It is implemented. Not sure if it's working though, because i never had to use SSH myself, just implemented it "blindly". 


      1. Hi Dan,

        yes of course I did, if you implemented it blindly, congratulations, because it works perfectly. The thing I am missing is the possibility to use the shortcuts (and more complex definitions) of the SSH-config file. I would love this, because sometimes some stupid providers kick you out ssh-sessions and so on, stuff wich you can circumvent by using keep-alive parameters. Or if you can only reach some server via SSH-proxies you can configure this in your SSH-config to, things with are not possible with the "standard" ssh connections you implemented

        In Data-Grip (the only tool I found this was implemented, but which is to expensive and to overdone for my purposes) they just added a third auth type (OpenSSH config and authentication agent) which uses the configuration file.

        Which is perfect because, if you connect to some host via SSH and create a shortcut in your config for that host, you can just use it in the database connection. Also (and even more important I guess) you do not have to store any passwords anymore, because you use your authentication agent which stores it locally.

        Anyway I do not have any idea how they implemented it, nor do I have any Idea (not beeng a Java programmer) which libraries could help you in connection to openSSH.






  60. We have a huge database for one of our project, when i starts it, it keeps loading columns for long time and almost become unusable for that time. From its setting i unchecked almost all filters and auto completion check boxes but still its taking ages to load all columns, schemas  etc. 

    For small database its flawless, love to use it.

    1. Hi,

      can you try unchecking "workspace restore" functionality for your connection? This should speed-up things on startup, as it will not try to reload the state prior to last IDE closure.

      1. Thanks Dan, I just tried that, didn't feeling much difference. Although restarted the Intellij by closing all projects. Will update here if i see any improvement (that might not be observed in first attempt) ,while using it in next few days. thanks

  61. When I open the session browser and click on one of the sessions, I get an error stating ORA-00942: table or view does not exist. I think it is trying to populate the current sql statement. Which database view is being used?  Are the database views used by db navigator documented somewhere? Thanks for all your work on this tool.  I'm blown away.  This is the best Toad replacement I've found.

    1. Hi Jeff,

      i am using below sql for load the current statement of the selected session. You may not be granted to see these tables by your db administrator. Could you suggest an alternative lookup?


      select replace (q.SQL_FULLTEXT, chr (0)) sql_statement
      GV$SESSION s,
      GV$SQL q
      s.SQL_ADDRESS = q.ADDRESS and
      s.SID = {0}
      1. Thanks Dan.  I'll get access to those views.

        1. Dan, 

          I got permission to both gv$ views. However, I only see the current sql for my own session. 

          This sql works for all sessions:

          select sql.SQL_TEXT from V$SESSION s
          join v$sql sql on sql.SQL_ID = nvl(s.SQL_ID, s.PREV_SQL_ID)
          where s.SQL_ID = {0};

          Any change you could use this one in the app?

          1. Hi Jeff,

            thanks for pointing this out. Was not aware i could present the previously executed statement, although i always need it myself.

            Thanks for this contribution (smile)
            (feature will come with next public release)


            1. Glad to help.  (smile)  Thanks.

  62. Hi,

    please I using JetBrains DataGrip  and i have many databases in one connection (1200 databases). I have problem with Loading columns of table. Every time ends on timeout (sad)

    Thanks for help


    Ondřej Jodas

    1. Hi Ondřej,

      this is a third party plugin for intellij, not DataGrip itself. You may want to address your concerns to the Jetbrains team.


      1. Hi Dan,

        yes i known. I using this plugin in DataGrip and this issue is relevant for DB Navigator.


        Ondřej Jodas

        1. Hi Ondřej,

          where do you see the timeout? Can you post a screenshot or something?


          1. Hi,

            if i loading columns/constraints of table:

            so task run 30s and end it. Columns info dont load it:

            and i havent any info of columns in filter:


            This problem is only when i have many databases (~1000) in one connection.



            Ondřej Jodas

            1. please any idea?



              Best regards

              Ondrej Jodas

              1. Hi Ondřej,

                will add a configuration to allow you to extend the 30 seconds timeout for meta-info loaders.


                1. Hi Dan,

                  please when will be it possible to extend the timeout for meta-info?



                  Ondrej Jodas

  63. Is there a way to get the full record count when the result set is only displaying the first 500 records?  Something that re-runs the sql statement with: select count(*) from ({sql});  

  64. Formatting of SQL in the console does not appear to be working.  Anyone else having this issue?  

  65. Executing a create table AS select ... does not run.  This will run in sqlplus or other SQL editors.

    Such as

  66. Hi Dan,

          I want to add column remarks into db browser,so I download the source code from,but the idea library version seems too old.

          can you upload the source code to github?Thanks.


  67. How can I create and execute a PLSQL file ? 

    I have this script


    I create a .psql file but it seems it cannot be executed with Execute Statement command

    It could be only executed if the extension being changed to .sql ( not .psql )

  68. Every time I try to open and edit a MySQL stored procedure, I get an error: 

    "Could not load source for procedure ... source lookup returned empty".

    However, I can edit these stored procedures in DataGrip just fine...

    Here is a screen shot

  69. Excellent, but I got an issue trying to edit a MySQL function "Could not load source for function "<MY_FUNC". Error details: SELECT command denied to user '<MY_USER>'@'<IP_ADDRESS>' for table '<TABLE_NAME>'".

    The bug is in the IP address: the provided IP is the localhost IP, and not the remote database IP.

    Thank you!


  70. Importing from tnsnames.ora seems to be not working as expected. For instances, I have such an entry there: SOME_NAME_OF_AN_ENTRY=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST={HOST_NAME})(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME={DB_NAME}))).

    I expect that a new connection would be created with given host name, port and service name, but it only extract name of an entry and doesn't extract the other fields leaving them empty. Which is not right, esp. when you have a great list of connections to create, such an option is useless. Please, correct this to work properly as it does in most plugins and clients.

    1. Hi Konstantin,

      can you check if this works now with the latest version of the plugin?



  71. Another thing that really bothers me is lack of ability to create connections globally, I mean I could be working with several branches at a time in different IDEA instances, but for each branch you're obliged to create a new project with new connections. Why is it not possible to store them globally to share between different branches?

    1. Hi Konstantin,

      the entire plugin was built around a project, as most of the features rely on the concept of workspace. Moving away from this into a cross-project functionality is unthinkable at this point in time. 
      But you have means to export and import connections from one project to another, and even define connections on default project template (will be replicated with every new project).


  72. Hello.

    I'd like to report a couple of issues I'm experiencing that would be easier to quickly grasp in an image I tried to attach but was not able to do so due to permissions:

    1. There's some kind of malfunction when parsing a DATETIME column with sqlite, the date is fine but the time is not, all show 12:00:00AM, while the popular DB Browser for SQLite does not
    2. NULL values are not displayed as such but appear to be empty. This can be misleading.
    3. I use a dark theme on my IDE and displaying a table kinda turns me blind for a sec. Would be nice to inherit colors from current theme.

    Other than that, thanks for the plugin!



    1. Hi Francisco,

      would you please file a ticket (or more) in the request tracker here

      You should be able to attach screenshots and everything.. Need more information for #3 like IDE / version / environment

      Thanks for your support,



  73. Hi.

    Are there any implementation projects for SCHEDULER support for the Oracle database?

  74. Hello!

    Can you help me? How do I update data in  DB Navigator when something changed in DB? DB MySQL. I try to reload but nothing happened.

    What I want:

    When in my DB something changed DB Navigator fetch automatical changes or what I should click to do this?

  75. Hello. Thanks for this tool, it is excellent. I especially value the rich and powerful Browser and Navigator features.

    For editing DDL, SQL, etc. I prefer to use the native JetBrains editor (at least by default). Is it possible to disable the DBN association with association with SQL file types? Or at least make the native editor the default instead?

    Thanks in advance for any help you can provide.

  76. Hi, thanks for this great plugin. I have one quetion, how can I see column comment and table comment, since it offer many detail infomation for use.



  77. Dear Mr. Cioca,

    I am writing to you to share some bugs I found:

    1. Setup SSH tunnel checkbox inverted:
      I've setup SSH tunnel, but it return exception: connection is closed by foreign host. I checked that I was able to connect from terminal with same credentials. Once I un-check "Use SSH Tunnel", connection was successful.
    2. Support ed25519 SSH keys
      If I am trying to use ed25519 key it failed with "invalid privatekey: [B@5249"

    Please contact me if you need more details.



  78. Dear Mr. Cioca,

    I am writing to you to share some bugs I found:

    1. Setup SSH tunnel checkbox inverted:
      I've setup SSH tunnel, but it return exception: connection is closed by foreign host. I checked that I was able to connect from terminal with same credentials. Once I un-check "Use SSH Tunnel", connection was successful.
    2. Support ed25519 SSH keys
      If I am trying to use ed25519 key it failed with "invalid privatekey: [B@5249"

    Please contact me if you need more details.



  79. Hi Mr Cioca,

    This is a great plugin, the best for SQL and database access (smile)

    Please make it compatible with the current Intellij version 2020.x.

    Thank you!


    1. so that is why I have this error:

      I used once in 2018.1 version but since 2018.3 at least is failing

      1. same error! 2018.3 version

  80. Hey I noticed that when I connect to a RAC in oracle, the session browser will show me sessions on a different SID than what im connected to. I am unable to kill those sessions. Would it be possible to have the connection pool connect to multiple SIDs when connecting to an ORACLE RAC and have the session killer use the appropriate SID connection when killing a session?

    Right now I have to setup 2 different connections. 1 for each SID. When I want to kill a session I have to try on both connections sometimes.

    Thanks! I really enjoy this plugin.

  81. Hey I noticed that when I connect to a RAC in oracle, the session browser will show me sessions on a different SID than what im connected to. I am unable to kill those sessions. Would it be possible to have the connection pool connect to multiple SIDs when connecting to an ORACLE RAC and have the session killer use the appropriate SID connection when killing a session?

    Right now I have to setup 2 different connections. 1 for each SID. When I want to kill a session I have to try on both connections sometimes.

    Thanks! I really enjoy this plugin.