Database Navigator

Compatible with IntelliJ IDEA (Ultimate, Community), Android Studio and 12 more
Screenshot 1
Screenshot 2
Database development, scripting and navigation tool
This software solution enhances the capabilities of the IntelliJ IDEA development environment and its associated products by providing comprehensive features for database development and maintenance. It includes a robust SQL and PL/SQL editor that adheres to the IDE standards, along with advanced functionality for managing database connections, executing scripts, browsing database objects, editing data and code, supporting database compiler operations, executing and debugging methods, and facilitating the creation of database objects. Additionally, it offers diverse navigation capabilities that seamlessly integrate across all its components, providing a powerful toolset for efficient and effective database development and management.

Supported Databases:
  • Oracle
  • MySQL
  • SQLite
  • PostgreSQL
  • Any JDBC compliant database (EXPERIMENTAL)



This tool is free for personal and commercial use.
Donations are very welcome though.

What’s New

  • 3.4.4425
    • Script execution engine - support for Oracle TNS_ADMIN / cloud connections
    • New-UI tool window icons rework
    • NLS support - work in progress
    • Bug fixes
  • 3.4.4179
    • Postgres SQL syntax - literal comparison operators
    • Oracle TNS_ADMIN - support for environment variable
    • New-UI tool window icons rework
    • Support for latest IDE EAP versions
    • Bug fixes
  • 3.4.3713
    • Object browser - new display mode (Connection selector)
    • Object browser trees - sticky-path scroll headers
    • Optimised database object lookup (Ctrl-Shift-D)
    • New-UI adaptations and icons (WIP)
    • Bug fixes
  • 3.4.3407
    • New UI adaptations and icons (WIP)
    • Bug fixes
  • 3.4.3211
    • Prompted background-capable DB operations
    • Ide startup optimisations (lazy component initialisation)
    • Expression-based object filters
    • New-UI adaptations and icons (WIP)
    • Bug fixes
  • 3.4.2700
    • IDE startup optimisations
    • Support for latest IDE versions
    • Run profiles simplification
    • Collapsible execution context details
    • DDL file attachments (alternative file-name patterns)
    • Bug fixes
  • 3.4.2455
    • Copyright support for SQL / PLSQL source code
    • Oracle SQL - support for LIBRARY ddl statements
    • Oracle PLSQL - basic support for conditional code blocks
    • IDE freezing issues - background operations
    • Bug fixes
  • 3.4.2299
    • Fixed SQLite connectivity issues with certain system locales
    • Data editor improvements
    • NCLOB data native support
    • Identifier resolver and navigation improvements
    • Memory optimisations
    • Bug fixes and stability improvements
  • 3.4.1710
    • Addressed IDE freezing issues
    • Bug fixes and performance improvements
  • 3.4.1220
    • Discontinued support for IntelliJ 17 and earlier versions
    • Plugin conflict resolution management
    • Support for Ctrl-S / Ctrl-Enter actions (save / execute)
    • Simplified debugger profile management
    • Fixed occasional editor double gutter actions
    • Improved overall plugin startup responsiveness
    • Bug fixes
  • 3.3.9995
    • New icons and UI improvements - WIP
    • Fixed SSH connectivity problems
    • Data Export - custom quoting on csv outputs
    • Fixed parametric statement execution
    • Bug fixes
  • 3.3.9310
    • Fixed H2 connectivity issues with latest IDEs
    • Diagnostics - DeveloperMode timeouts
    • Diagnostics - Additional failsafe exception logging
    • Record viewers - column quick filters
    • Bug fixes
  • 3.3.9100
    • SQL file associations restore on plugin uninstall
    • Fixed missing editor toolbars / top notifications
    • Reworked connection configuration
    • Oracle TNS import filter / options
    • Support for latest IDE EAP versions
    • Bug fixes
  • 3.3.7711
    • Bug fixes
    • Memory optimisation
    • Stability improvements
  • 3.3.4510
    • Architectural changes (background services rework)
    • Bug fixes and performance improvements
    • Probably a whole set of brand new bugs...
  • 3.3.3100 - UNSTABLE
    • Architectural changes (components - move to services)
    • Resources allocation redesign (background operations optimisation)
    • Bug fixes and performance improvements
  • 3.3.2160
    • Oracle JDBC debugger fix
    • Bug fixes and performance improvements
  • 3.3.2100
    • Built-in driver upgrades
    • Database families - language support MySQL and PostgreSQL offsprings
    • Bug fixes
  • 3.3.1923
    • Data Editor improvements
    • Fixed issues with code completion and identifier resolvers
    • Bug fixes and performance improvements
  • 3.3.1555
    • Folder connection context (work in progress)
    • Oracle SQL "create synonym" syntax support
    • SQLite configuration validations (multiple db files)
    • Support for latest IDE EAP versions
    • Bug fixes and performance improvements
  • 3.2.7709
    • Oracle SQL and PLSQL language syntax updates
    • Bug fixes
  • 3.2.6411
    • Parser and connection diagnostics / hidden developer actions
    • Oracle SQL and PLSQL language syntax updates
    • Bug fixes
  • 3.2.5802
    • Support for latest IDE EAP versions
    • Oracle SQL and PLSQL language syntax updates
    • Bug fixes and performance improvements
  • 3.2.4501
    • Oracle JSON syntax support
    • Support for latest IDE EAP versions
    • Bug fixes, performance and memory optimisations
  • 3.2.3024
    • New Jira-Markup data-export format
    • Code completion - overall performance improvements
    • Database-object lookup (Ctrl+Shift+D) - performance improvements
    • Support for latest IDE EAP versions
    • Bug fixes
  • 3.2.1395
    • Resource monitor enhancements
    • Connectivity timeout configuration
    • "Rename" feature for execution results
    • Support for latest IDE versions
    • Editor intention action descriptions
    • Bug fixes and performance improvements
  • 3.2.0589
    • Data export enhancements (CLOB, XMLTYPE)
    • Oracle tnsnames.ora connection import
    • SQL Console list in object browser
    • Resolved broken JIRA issue reporting framework
    • New data-grid numeric functions on selection (Sum / Count / Average)
    • Bug fixes
  • 3.2.0163
    • Fixed MS-SQL Server meta-data load issues
    • Fixed Oracle JDWP debugger issues under MacOS (DBN-436)
    • Fixed Oracle code completion issues
    • Small bug fixes and cosmetics
  • 3.2.0127
    • Generic database support (Experimental)
    • Support for latest IDE EAP versions
    • Bug fixes and performance improvements
  • 3.1.1432
    • Fixed issue with built-in driver libraries
    • Memory cleanup strategy redesign
    • Bug fixes and performance improvements
  • 3.1.1245
    • Fixed PosgreSQL language issues
    • Optimized Oracle meta-data interface for large databases
    • SQLite data editor issues
    • Optimized database connectivity and background operations
    • Support for latest IDE EAP versions
    • Discontinued support for IntelliJ 14.x and related products
    • Bug fixes and performance improvements
  • 3.1.0231
    • Support for latest IDE versions
    • Discontinued support for IntelliJ 13.x and related products
    • Small bug fixes and performance improvements
    • JRE 8.x or higher required
  • 3.0.8222
    • Resolved JDWP debugger initialization issues
    • Memory footprint optimization
    • Resource manager dialog (alpha)
    • Bug fixes
  • 3.0.8142 (beta)
    • Connectivity status indicator
    • Session management (dedicated connectivity)
    • Redesigned resource management
    • Resource monitor dialog (work in progress - not released)
    • Spellchecker enhancements (configurable levels)
    • Important stability and performance improvements
  • 3.0.7621
    • Parallel / asynchronous statement execution (using pool connections)
    • Data grid column info tooltips
    • Stability and cosmetic improvements
  • 3.0.7248
    • Support for latest IDE EAP versions
    • Source editor breadcrumbs
    • Data editor - qualified CLOB / TEXT editor
    • Bug fixes and performance improvements
  • 3.0.6893
    • Support for latest IDE releases
    • Workspace restore option
    • Spellchecking support for database file editors
    • Bug fixes and cosmetics
  • 3.0.6112
    • More accurate transaction status handling
    • Readonly pool connections for metadata load
    • Fixed SQLite meta-data issues
    • Support for latest IDE releases
    • Optimizations: more responsive code editors
    • Bug fixes
  • 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
Aug 19, 2024
Version 3.4.4425.0

Rating & Reviews

4.0
101 Ratings (4,451,636 Downloads)
5
4
3
2
1

yhzhaohy

2 days ago
  1. Open the folder "C:\Users\your_user\AppData\Roaming\JetBrains\IdeaIC2024.3\plugins\DBNavigator\lib"
  2. Copy the dbn.jar file to another folder, e.g., "update_dbn"
  3. Open Command Prompt in the "update_dbn" folder and execute the command "jar xf dbn.jar"
  4. Modify the "META-INF\plugin.xml" file by removing the "until-build" attribute under the "<idea_version>" element
  5. Execute the command "jar cf dbn.jar *"
  6. Replace the original "dbn.jar" in the "\plugins\DBNavigator\lib" folder with the new one
0

jool77

1 week ago

It seems that the development of this plugin has ended. It is shame as it is really good and I've been using it a lot. Hopefully current version can still be used with newer IDE versions.

0

Alex Pastel

30.12.2024

You can continue to use the plugin past IDE build 242.* if you open the "dbn.jar" in your <install_or_plugin_dir>/DBNavigator/lib directory, edit the file META-INF/plugin.xml, find the <idea_version> element and remove the "until-build" attribute.

+4

Additional Information

Vendor:
Dan Cioca(Non-trader)
Plugin ID:
DBN