Database Navigator

Products: IntelliJ IDEA, RubyMine, WebStorm, PhpStorm, PyCharm, AppCode, Android Studio

Vendor: Dan Cioca




Bugtracker page


Database development, scripting and navigation tool
This product aims to add extensive database development and maintenance capabilities to the IntelliJ IDEA development environment. Along with a qualified and IDE-compliant SQL and PL/SQL editor, it provides advanced database connection management, script execution support, database objects browsing, data and code editor, support for database compiler operations, method execution and debugging, database objects factory, as well as various navigation capabilities between all its components.
See features overview on the support page.

Supported Databases:
  • Oracle
  • MySQL

This tool is free for personal and commercial usage.
Donations are very welcome though.
Downloads: 212006
Participated in rating: 27
Version Since Build Until Build File/URL Size (Kb) Date Details
3.0.2686. 130.1. 135.*. Download 6619.46 2014-04-08 21:32:09 details
3.0.2686. 120.1. 129.*. Download 6597.52 2014-04-08 21:31:08 details
3.0.2686. 111.1. 119.*. Download 6597.74 2014-04-08 21:30:00 details
3.0.2686. 97.1. 107.*. Download 6599.02 2014-04-08 21:28:50 details
3.0.2660. 111.1. 129.*. Download 6591.26 2013-09-28 21:51:59 details
3.0.2630. 111.1. 130.1180. Download 6407.51 2013-08-01 02:51:16 details
3.0.2501. 93.1. 95.*. Download 6341.73 2013-03-31 05:30:24 details
3.0.2017. 110.1. 110.*. Download 5941.48 2011-11-15 23:26:51 details
3.0.1804. 80.8000. 85.*. Download 5345.17 2010-09-11 02:31:36 details
1.1.0547. 69.7126. 75.7999. Download 4726.2 2009-02-28 00:11:44 details
. .
36 updates are hidden show all updates
Screenshot #569
Screenshot #570
Screenshot #572
Screenshot #571
Screenshot #568
Screenshot #573

Recent change notes:

  • 3.0.2686
      - Support for latest IntelliJ version
      - Live Templates Ctrl-J (work in progress)
      - "About" page (with "donate" link)
      - Multiple column sorting (work in progress - not released)
      - Method execution result improvements (tree view)
      - Reworked action system to allow multiple editor instances, split and detached editors
      - Bug fixes and performance improvements
  • 3.0.2530
      - Support for error reporting directly from IDE
      - Connection timeout and idle time management
      - Memory management improvements (fixed memory leaks on project close)
      - Improved performance for database object lookup (Ctrl+Shift+D)
      - Compatibility with latest IDE version (including EAP)
      - New Icon set (work in progress)
      - Support for dark scheme
      - Minor bug fixes and performance improvements
      - Discontinued support for IntelliJ IDEA 9.x and related products
  • 3.0.2349
      - Code formatting (Experimental - work in progress)
      - Customizable data-grid colors and fonts
      - Uncommitted changes overview / prompt dialogs
      - Balloon notifications and activiy log entries for several operations
      - Connection Auto-Commit support
      - Support for IntelliJ 12 EAP release
      - Fixed broken user interface with PyCharm and RubyMine
      - Minor bug fixes
  • 3.0.2191
      - Support for IntelliJ 11 release
      - Configurable datbase environments / environment colors
      - Data grid preview popup for BLOB/CLOBs
      - Data search functionality in dataset editors and query results (experimental)
      - Minor bug fixes
  • 3.0.2017
      - Support for latest IntelliJ EAP versions
      - Statement generation engine (extract select, insert, ddl statements)
      - Fixes of BLOB editing support
      - Support for database content encoding
      - Data Editor - navigate to referenced record
      - Navigation bar improvement for DB objects
      - XML Data Export format
      - Custom number and date/time formats in locale settings
      - Connection setup enhancements (NOTE: you may lose connection custom properties)
      - Minor bug fixes
  • 3.0.1911
      - Fixed compatibility issues with Ruby plugin
      - Support for IDEA 10.5 release
      - General bug fixes and performance improvements
  • 3.0.1898
      - recommended upgrade if you are using 3.0.1895
      - Support for IDEA X EAP releases
      - Configuration framework changes (NOTE: some of your settings may be reset to default)
      - Object name filters (e.g. Schema filters) on connection level
      - Object type filters on connection level
      - Ability to activate/deactivate connections
      - Oracle OS authentication
      - Fixed memory leak issues with large result-sets
      - General bug fixes and performance improvements
  • 3.0.1870
      - Quick SQL sandbox (SQL Console for database connections)
      - Show object detailed information (configurable)
      - Added support for SQL ISO-92 (work in progress - not usable yet)
      - Minor bug fixes
  • 3.0.1856
      - Added support for IntelliJ IDEA X (BETA)
      - Discontinued support for IDEA 8.x
      - Improved navigation within PL/SQL code
      - Added code completion for variables and method parameters in PL/SQL code
      - Enhanced database object compiler handling (keep current debug status)
      - Improved object lookup functionality (select connection prompt)
      - Added navigation-bar support for database objects (experimental)
      - Fixed xls data export for select statement results
      - Enhanced xls export data format (make use of regional settings)
      - Added HTML data export processor
      - Persisted data export options
      - Object properties (work in progress)
      - Minor bug fixes
  • 3.0.1804
      - Database object lookup (Ctrl-Shift-D) - Experimental phase
      - Improved Debugger breakpoint handling
      - Compatibility version constraint (no support for IDEA X yet)
      - Minor bug fixes
See full release notes


2014-04-11 20:36:24
I've downloaded it, but I don't see any instructions on how to install it and get it up and running
2014-03-19 18:14:25
The tool is really nice nad works like a charm - but it is not compatible with the current IntelliJ 13.1 :(
2014-01-14 19:01:30
Hi dtrucken. No font size configuration for the plugin itself. But for the entire IDE (Settings > Appearance > Override default fonts by > Size). For the editor as well (Settings > Editor > Colors & Fonts > Font > ...). The font changes should be reflected in the plugin components.
2014-01-11 01:56:32
I love it. Is there any way to control the font size in this plugin? I'm using UI-133-471?
2014-01-11 00:18:51
Doesn't support postgres. please vote on: DBN-205 Support Postgres
2013-11-28 22:12:29
Great work! Is it possible to work with column comments? I can't even see them :( Thank you!
2013-11-21 16:57:36
Doesn't work with IntelliJ IDEA Build 133.79
2013-11-19 13:57:35
Hi. On Intellij IDEA build 132.1045, I can't get the dialog box to display. Clicking the button results in an error: com.dci.intellij.dbn.connection.config.ui.ConnectionDetailSettingsForm$2.append(Ljava/lang/String;)V: com.dci.intellij.dbn.connection.config.ui.ConnectionDetailSettingsForm$2.append(Ljava/lang/String;)V java.lang.NoSuchMethodError: com.dci.intellij.dbn.connection.config.ui.ConnectionDetailSettingsForm$2.append(Ljava/lang/String;)V at com.dci.intellij.dbn.connection.config.ui.ConnectionDetailSettingsForm$2.customizeCellRenderer( at com.intellij.ui.ColoredListCellRenderer.getListCellRendererComponent( at .....
2013-11-16 07:22:34
Hi, 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? Regards Federico Franco
2013-08-24 22:07:13
ups, sorry
2013-08-24 13:02:08
Hello "longtimeago". The error is coming from the standard distribution database support not from this plugin. Please address the issue to JetBrains directly.
2013-08-24 11:17:53
I have a problem when trying to call Synchronize from Database panel, the Exception popup appears: Connection to database failed: Exception in thread "main" java.lang.NoClassDefFoundError: org/slf4j/LoggerFactory at org.hibernate.dialect.Dialect.( at java.lang.Class.forName0(Native Method) at java.lang.Class.forName( at com.intellij.persistence.database.console.RemoteJdbcServer.main( Caused by: java.lang.ClassNotFoundException: org.slf4j.LoggerFactory at$ at$ at Method) at at java.lang.ClassLoader.loadClass( at sun.misc.Launcher$AppClassLoader.loadClass( at java.lang.ClassLoader.loadClass( ... 4 more IntelliJ 12.1.4
2013-08-21 01:45:05
Should be compatible with Android Studio as well. Some features are broken (e.g. pl-sql debugging), but the most should be fine
2013-08-13 14:00:32
Its getting incompatible error message when trying to install in Android Studio 0.2
2013-03-16 02:24:03
thanks for the great plugin one thing that really bothers me though - how do i execute insert/show/anything else rather than select in sql console?