# Oracle Database Navigator for IntelliJ IDEA
[](https://plugins.jetbrains.com/plugin/1800-database-navigator)
[](https://plugins.jetbrains.com/plugin/1800-database-navigator)
Oracle Database Navigator is a database development and management tool for IntelliJ-based IDEs, providing a comprehensive set of features for working with relational databases directly within the IDE.
This plugin is developed and actively maintained by Oracle as part of its developer tools ecosystem.
---
## Highlights
- Advanced code editors with deep IDE integration
- Rich database object navigation and intuitive browsing experience
- Integrated data editor with real-time result grids and inline editing
- Powerful execution engine with support for scripts, programs, and run configurations
- Built-in debugging and compiler support for database programs
- Intelligent workflows for managing database development directly within the IDE
---
## Features
- Advanced SQL and PL/SQL editor integrated with the IDE
- Database object browser (schemas, tables, views, procedures, etc.)
- Data editor with inline editing and result grids
- Script execution with run configurations and execution tracking
- Integrated debugging and compiler support for database programs
- Intelligent navigation across database objects
- Secure and flexible connection management
- Integrated AI-powered Database Assistant
- Oracle Cloud Infrastructure (OCI) integration (where applicable)
---
## Supported Databases
- Oracle
- MySQL
- PostgreSQL
- SQLite
- Any JDBC-compatible database (experimental)
---
## Getting Started
### Installation
1. Open IntelliJ IDEA (or any JetBrains IDE)
2. Go to **Settings / Preferences → Plugins**
3. Search for **Database Navigator**
4. Click **Install**
5. Restart the IDE
Or install directly from the JetBrains Marketplace:
https://plugins.jetbrains.com/plugin/1800-database-navigator
---
### Creating a Connection
1. Open the **DB Browser** tool window
2. Click the **+** icon to add a new connection
3. Select your database type
4. Enter connection details (e.g. host, port, credentials)
5. Test and save the connection
---
## Usage
### Browsing Database Objects
- Expand your connection in the DB Browser
- Navigate through schemas, tables, views, indexes, and procedures
### Running Queries
- Open a SQL console
- Write your query
- Execute using **Ctrl/Cmd + Enter**
### Editing Data
- Right-click a table → **Edit Data**
- Modify data directly in the grid view
- Choose whether changes are auto-committed or require explicit commit
### Editing Code
- Right-click a program (procedure, function, package) → **Edit Code**
- Modify the code in the editor
- Compare changes against the code version in the DB
- Save changes and verify execution results
### Executing and Debugging Programs
- Right-click a program (e.g. procedure) → **Execute...** or **Debug...**
- Provide values for the program arguments
- Execute and verify results in the DB Execution Console
- Monitor and control execution using the debugger tool
### Exploring Editor and Browser Features
- Right-click a database object in the DB Browser
- Explore available actions for each object type
- Open **DB Navigator** from the main menu to access additional features
---
## Compatibility
- IntelliJ IDEA
- WebStorm
- PyCharm
- Other JetBrains IDEs
---
## Documentation
- [DBN documentation](./docs/index.md): repository guides for connections, browsing, editors, execution, debugging, and configuration
- [Official Oracle product documentation](https://docs.oracle.com/en/database/oracle/database-navigator/4.0/dbnug/introduction-oracle-database-navigator.html): the guide available through the plugin's Help topic
---
## Examples
### Common Use Cases
The following examples illustrate common ways to use DBN:
- **Explore data:** Browse database objects and table data from the DB Browser
- **Run SQL:** Open a database console and execute queries
- **Edit data:** Modify table data directly in the grid
- **Work with database code:** Execute or debug stored procedures and functions
---
## Help
We welcome your feedback. If you find a bug, encounter unexpected behavior, or have an idea for improving DBN, please [submit an issue](https://github.com/oracle/database-navigator/issues). Include the DBN and IDE versions, database type, and steps to reproduce whenever possible.
---
## Contributing
This project welcomes contributions from the community. Before submitting a pull request, please [review our contribution guide](./CONTRIBUTING.md)
---
## Security
Please consult the [security guide](./SECURITY.md) for our responsible security vulnerability disclosure process
---
## License
This project is licensed under the Apache License 2.0.
See the [LICENSE](LICENSE.txt) file for details.
---
## Acknowledgements
- Original Database Navigator contributors
- Open-source community
- JetBrains Platform