Authors:
dancioca
logos

Database Navigator

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

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
  • PostgreSQL (early preview)



This tool is free for personal and commercial usage.
Donations are very welcome though.
Downloads: 543183
Rating:
Participated in rating: 34
Version Compatible builds Date
3.0.4412.1 140.1 — 141.* 24.04.2015 Download
3.0.4412.2 138.1 — 139.* 24.04.2015 Download
3.0.4412.3 130.1 — 135.* 24.04.2015 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
116 updates are hidden show all updates
Screenshot #572
Screenshot #571
Screenshot #568
Screenshot #570
Screenshot #573
Screenshot #569

Recent change notes

  • 3.0.4412
      - Support for various dark schemes in WebStorm/PhpStorm
      - Redesigned connection setup
      - Support for connection over SSH
      - Connection with empty password option
      - Fixed several Oracle PLSQL syntax issues
      - Bug fixes
  • 3.0.4307
      - Object dependency tree
      - Connection credentials interactive dialogs
      - Confirmation options for code editors
      - Session Browser "quick Find Data" support (Ctrl-F)
      - Method execution cursor result "Find Data" support (Ctrl-F)
      - General bug fixes and performance improvements
  • 3.0.4183
      - Zoom in/out support for data grids (Ctrl-MouseWheel)
      - Remember statement execution variables
      - Remember method execution parameter history
      - Session Browser colors configuration
      - Error reporting improvements (attachments)
      - Settings editor cosmetic updates
      - Minor bug fixes
  • 3.0.4012
      - Support for GRANT SQL-statement (Oracle)
      - Database Sessions Browser (all databases)
      - Session disconnect / kill actions
      - Transaction Management options
      - Restore database editors state (folding, selection, cursor position)
      - Minor bug fixes
  • 3.0.3821
      - Support for IntelliJ IDEA latest EAP version (14.1)
      - Code completion enhancements (ignore case lookup / enforce code style case option)
      - Method execution/debug intention actions (Alt-Enter)
      - Oracle PLSQL Debugger enhancements (support for record variables)
      - Column parameter info (Ctrl-P) for insert statements
      - Plugin update notification in configuration dialog
      - Discontinued support for IntelliJ IDEA 12.x and related products
      - Minor bug fixes
  • 3.0.3674
      - Support for Oracle XMLTYPE editing / method execution
      - Support for BLOB/CLOB method execution arguments
      - Method call parameter info (Ctrl-P)
      - Minor bug fixes
  • 3.0.3601
      - Object sorting options in database browser
      - Icon rework for better visibility in dark schemes
      - Support method executions with collection return types (Oracle)
      - Excel 2007 (xlsx) data export format
      - Oracle Type language support
      - Execution logging - Oracle DBMS_OUTPUT
      - Improved code completion support for local objects
      - Minor bug fixes and improvements
  • 3.0.3501
      - Parser improvements and optimizations
      - Explain plan execution support (Oracle)
      - Support for database triggers
      - Language support for XML functions (Oracle)
      - Code completion support for locally defined objects
      - Various bug fixes
  • 3.0.3401
      - Support for latest IntelliJ EAP version
      - Support for default project configuration (including connections)
      - Discontinued connection setup on module level
      - Compile error outputs on DDL script execution (Oracle)
      - Support for manually controlled database connectivity
      - Improved statement execution result linkage
      - Improved focus logic on statement execution
      - Various bug fixes and optimizations
  • 3.0.3305
      - Support connecting on demand only (i.e. disable auto-connect)
      - Support for multiple SQL consoles per connection
      - "Save Console To File" functionality
      - Statement execution shortcut improvements
      - Support for Oracle trigger syntax
      - Support for Oracle explain plan syntax
      - Bug fixes
  • 3.0.3272
      - Support for anonymous "begin / end" blocks (Oracle)
      - Support for alternative delimiter configuration (MySQL)
      - "Hide empty schemas" feature for object browser
      - MySQL DDL file support
      - DDL file formatting and configuration enhancements
      - Structure view enhancements
      - Language parsers support for database versions (postgres)
      - Bug fixes and performance improvements
  • 3.0.3192
      - Configurable "tracking" columns (display text attributes, visibility, editable)
      - Datagrid sorting settings (nulls first/last, max number of sorting columns)
      - Postgres table editor (support for Array editing)
      - Postgres SQL language (additional statements support)
      - Oracle SQL (support PIVOT clause)
      - Discontinued support for IntelliJ IDEA 11.x and related products
      - Bug fixes and performance improvements
  • 3.0.3145
      - PostgreSQL support (work in progress)
      - Multiple column sorting in dataset editor and query results (Ctrl-Click)
      - Dataset Editor - hide / move columns (persistent state)
      - Improved object lookup functionality (Ctrl-Shift-D)
      - Copy / Paste feature for connection settings
      - Metadata layer performance improvements (use prepared statements)
      - Support for latest IntelliJ IDEA EAP versions
      - Discontinued support for IntelliJ IDEA 10.x and related products
      - Bug fixes and performance improvements
  • 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

Comments:

12345..7>
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.
.
dancioca
2014-11-14 17:27:17
@gui will try to implement tunneled connectivity (e.g. ssh/ssl...). You may want to file a ticket in the request tracker if you want to follow the progress. @mitcheljh what database are you trying to use program editor? It should be possible in all currently supported databases. Coding support is not implemented for MySql and Postgres, only highlighting. @lapolonio this would be a good feature to suggest parameter values if already provided in the script for other statements. Please also file request in the bug tracker if you want to see when it gets released.
.
lapolonio
Rated:
2014-11-13 17:57:19
Hey I like the plugin. I would think it would be more user friendly if the plugin remembered bind query parameters across queries
.
mitcheljh
Rated:
2014-11-11 01:59:55
Very good features! Works as expected. It's nice to be able to edit stored procedures, functions, and triggers.
.
gui
Rated:
2014-11-07 18:04:32
Hi, I use ur plugin with a real distant server database, is there a way to have an encrypted connection for better security ?! gui
.
dancioca
2014-10-15 11:42:43
Version 3.0.3385 is a bit unstable. Work is in progress for a new more stable release. Thanks for the patience.
.
dancioca
2014-09-16 16:46:08
Shortcut for execution of statement under caret can be configured (Settings > Keymap > Plug-ins > Database Navigator > "Script Editor - Execute Statement")
.
Anonymous
Rated:
2014-09-12 19:10:31
Can i set a key to execute the query which i'm positioned in?
.
12345..7>