Authors:
dancioca
logos

Database Navigator

Products: IntelliJ IDEA, RubyMine, WebStorm, PhpStorm, PyCharm, AppCode, Android Studio, 0xDBE, CLion, Rider

Vendor: Dan Cioca

Email:

Website: http://www.jetbrains.net...NTEST/Database+Navigator

Source code: src.zip

License: http://www.apache.org/licenses/LICENSE-2.0.html

Bugtracker page

Forum page

Database development, scripting and navigation tool
This product adds extensive database development and maintenance capabilities to the IntelliJ IDEA development environment and related products. 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
  • SQLite
  • PostgreSQL



This tool is free for personal and commercial usage.
Donations are very welcome though.
Downloads: 731306
Rating:
Participated in rating: 38
Version Compatible builds Date
3.0.5866.1 142.1 — 145.* 15.04.2016 Download
3.0.5866.2 140.1 — 141.* 15.04.2016 Download
3.0.5866.3 138.1 — 139.* 15.04.2016 Download
3.0.5866.4 130.1 — 135.* 15.04.2016 Download
3.0.3674 123.1 — 129.* 11.01.2015 Download
3.0.3145 111.1 — 122.* 26.07.2014 Download
3.0.2686 120.1 — 129.* 08.04.2014 Download
3.0.2686 97.1 — 107.* 08.04.2014 Download
3.0.2630 111.1 — 130.1180 01.08.2013 Download
3.0.2501 93.1 — 95.* 31.03.2013 Download
3.0.2017 110.1 — 110.* 15.11.2011 Download
3.0.1804 80.8000 — 85.* 11.09.2010 Download
1.1.0547 69.7126 — 75.7999 28.02.2009 Download
175 updates are hidden show all updates
Screenshot #568
Screenshot #570
Screenshot #572
Screenshot #571
Screenshot #569
Screenshot #573

Recent change notes

  • 3.0.5866
      - Fixed SQLite connection issues with Mac OSX
      - Amazon Redshift connectivity support
      - Support for latest IDE releases
      - Memory optimizations
      - Bug fixes
  • 3.0.5723
      - SQLite support
      - Multiple attached databases (sqlite)
      - General bug fixes
  • 3.0.5111
      - Support for latest IDE EAP versions
      - Request tracker move to JIRA
      - Bug fixes and performance improvements
  • 3.0.5023
      - Environment types - editing control for code and data
      - "Cancel" action for unresponsive loads in data editors
      - Outdated sources notification
      - Configurable default editors
      - Recover connections after statement execution errors (MySQL, PostgreSQL)
      - Recover dataset editor after edit errors (MySQL, PostgreSQL)
      - JDWP debugger stability improvements
      - Bug fixes
See full release notes

Comments:

12345..7>
leolozes
Rated:
2016-04-06 14:53:34
Great work! I was just wondering if it would be possible: 1. Option to share the database connection configuration between projects (make it a global idea settings maybe?). 2. Support the Oracle XMLTYPE type, right now it's not rendering the data correctly. Thanks for the great work!
.
mohamz@gmx.net
Rated:
2016-01-25 18:31:35
Awesome! This plugin is great! Just one thing missing for me: a ddl-view of the tables, like there is one in pgAdmin. I mean when you click on a table in the "DB Browser" you don't only see the schema and connection but perhaps also the properties of the table, like the owner and the grants.
.
dancioca
2015-05-21 13:54:48
@flowrider can you please file a ticket in the request tracker with more details in what you are trying to achieve? Some screenshots would also be helpful if your environment does not display correctly under dark schemes.
.
flowrider
Rated:
2015-05-21 13:33:05
First of all, great work! I have one small wish regarding the colors. Since I am using the Dracula Scheme, I have to manipulate the colors of the different DBN-Views. Unfortunatelly, I havn't found a way to edit the color of the "DB Execution Console"\Messages Tab. Is that possible?
.
dancioca
2015-05-18 22:11:02
@henderea can you please provide some more details about your environment? (ideally in the ticket you created http://dci.myjetbrains.com/youtrack/issue/DBN-1005). Things like java version you are using, os, driver jar file (you could attach it to the ticket so i can debug the problem)
.
henderea
2015-05-18 19:11:36
Since the release of the version with built-in drivers, I'm unable to get the external Postgresql drivers to work (it can't find any classes), and the built-in drivers cause a message saying something about version 51.0 not being supported. Downgrading to the version from 2 releases ago (the newest before the built-in drivers release) restores the ability to use the external driver. I'm running the latest stable IntelliJ 14 on a Mac. It would be awesome if this could get fixed.
.
pboekelaar
Rated:
2015-05-08 10:08:50
This is one the best plugins for databases I ever worked with. It is incredibly enhanced, it is almost an application of its own. Jetbrains should use this as an example on how to build a database friendly environment (0xDBE is only a DB usable tool having this plugin installed) Keep up working on it
.
dancioca
2015-04-17 13:18:30
I assume the table editor issue is with the JetBrains DB-Support plugin, not with this one. Please try reporting the issue to jetbrains.
.
Anonymous
2015-04-17 13:08:35
Could you take a look at this issue regarding the inability to create a new table row? http://stackoverflow.com/questions/29005689/intellij-database-cannot-create-new-row
.
Anonymous
2015-04-17 13:06:56
Unable to create a new table row. It just gets deleted immediately.
.
Anonymous
Rated:
2015-03-17 17:21:30
Thanks for this great plugin. Finally I can get rid of eclipse and SQLDeveloper. Keep up the great work!
.
dancioca
2015-02-16 18:40:27
@Laubrino please download the package with the build range according to your IDE version (for IDEA 14.0.3 you need 138.1 - 139.*). Alternatively you can install the plugin directly form the IDE (Settings > Plugins > Browser Repositories...) in which case the correct build will be taken.
.
Laubrino
2015-02-16 18:25:51
Hi. I get this error when I try to install your plugin to IDEA 14.0.3 free: "Plugin Database Navigator is incompatible with current installation" Does it mean I need non-free version of IDEA?
.
laci159
2015-02-08 15:08:34
I don't know if it's problem in standard code completion feature of IDEA or problem of Database Navigator, but I'm getting hints only from current file. More details here https://devnet.jetbrains.com/thread/460453
.
batat
2014-11-19 18:58:25
Microsoft excel export bug. sheetName must not be null.
.
12345..7>