# oracle/database-navigator architecture

> Architecture diagram of the GitHub repository oracle/database-navigator, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-06). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/oracle/database-navigator
- Repository: https://github.com/oracle/database-navigator

## Overview

Database Navigator is an IntelliJ database development plugin. The principal workflow is to configure a connection, browse database objects, then open a SQL console or data editor and execute or edit against the database; code execution and debugging are related workflows. The repository also contains an integrated database assistant, vector/embedding features, machine-learning workflows, and Liquibase support. The README documents product capabilities, while sampled implementation excerpts are limited, so unverified links are shown as dashed rather than asserted as calls.

Main entry points: [`src/main/java/com/dbn/browser/DatabaseBrowserManager.java`](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/browser/DatabaseBrowserManager.java) (Object browser), [`src/main/java/com/dbn/execution/ExecutionManager.java`](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/execution/ExecutionManager.java) (Execution engine), [`src/main/java/com/dbn/assistant/DatabaseAssistantManager.java`](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/DatabaseAssistantManager.java) (Assistant manager), [`src/main/java/com/dbn/assistant/service/generic/GenericAssistantAdapter.java`](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/service/generic/GenericAssistantAdapter.java) (Assistant adapters)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_connections["Connections and browsing"]
  node_connection["Connection management"]
  node_connection_handler["Connection handler"]
  node_tns["TNS import"]
  node_browser["Object browser"]
  node_object_api["Database objects API<br/>[DBSchema.java]"]
end

subgraph group_development["Editing and execution"]
  node_editor["Code editor"]
  node_source_code["Source code"]
  node_data_editor["Data editor"]
  node_execution["Execution engine"]
  node_statement_execution["Statement execution"]
  node_debugger["Debugger"]
end

subgraph group_assistant["Database Assistant"]
  node_assistant_ui["Assistant chat UI<br/>[ChatBoxForm.java]"]
  node_assistant_manager["Assistant manager"]
  node_assistant_adapter["Assistant adapters"]
  node_model_invoker["Model invocation"]
  node_providers["AI providers<br/>[AIProvider.java]"]
  node_assistant_http["Assistant HTTP client"]
  node_mcp["MCP tools"]
end

subgraph group_data_ai["Data and AI"]
  node_vector_manager["Vector services"]
  node_query_embedding["Query embeddings"]
  node_table_embedding["Table embeddings"]
  node_query_processing["Query metadata"]
  node_ml_manager["Machine learning"]
  node_ml_executor["ML pipeline executor"]
end

subgraph group_operations["Database operations"]
  node_liquibase["Liquibase integration"]
  node_execution_settings["Execution settings"]
  node_object_management["Object management"]
end

node_developer(("Developer"))
node_ide["IntelliJ IDE"]
node_database[("Database")]
node_plugin["Plugin entry"]

node_developer -->|"uses plugin"| node_ide
node_ide -.->|"opens"| node_plugin
node_developer -->|"configures connection"| node_connection
node_connection -.->|"provides connections"| node_connection_handler
node_connection_handler -.->|"connects to"| node_database
node_developer -->|"browses objects"| node_browser
node_browser -.->|"uses connection"| node_connection_handler
node_browser -.->|"shows objects"| node_object_api
node_developer -->|"opens code"| node_editor
node_developer -->|"edits table data"| node_data_editor
node_editor -.->|"manages source"| node_source_code
node_developer -->|"runs programs"| node_execution
node_execution -.->|"dispatches statements"| node_statement_execution
node_execution -.->|"executes against"| node_database
node_developer -->|"debugs programs"| node_debugger
node_developer -.->|"asks assistant"| node_assistant_ui
node_assistant_ui -.->|"submits prompt"| node_assistant_manager
node_assistant_manager -.->|"selects adapter"| node_assistant_adapter
node_assistant_adapter -.->|"invokes model"| node_model_invoker
node_model_invoker -.->|"uses provider"| node_providers
node_assistant_adapter -.->|"sends requests"| node_assistant_http
node_assistant_manager -.->|"offers tools"| node_mcp
node_developer -.->|"uses embeddings"| node_vector_manager
node_vector_manager -.->|"runs query pipeline"| node_query_embedding
node_vector_manager -.->|"runs table pipeline"| node_table_embedding
node_query_embedding -->|"builds metadata"| node_query_processing
node_query_embedding -.->|"writes embeddings"| node_database
node_developer -.->|"uses ML"| node_ml_manager
node_ml_manager -.->|"executes pipeline"| node_ml_executor
node_ml_executor -.->|"trains model"| node_database
node_developer -.->|"manages migrations"| node_liquibase
node_execution -->|"uses settings"| node_execution_settings
node_browser -.->|"manages objects"| node_object_management
node_tns -.->|"imports connection data"| node_connection

click node_plugin "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/DatabaseNavigator.java"
click node_connection "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/connection/ConnectionManager.java"
click node_connection_handler "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/connection/ConnectionHandler.java"
click node_tns "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/connection/config/tns/TnsImportService.java"
click node_browser "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/browser/DatabaseBrowserManager.java"
click node_object_api "https://github.com/oracle/database-navigator/blob/main/modules/dbn-api/src/main/java/com/dbn/api/object/DBSchema.java"
click node_editor "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/editor/DatabaseFileEditorManager.java"
click node_source_code "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/editor/code/SourceCodeManager.java"
click node_data_editor "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/editor/DatabaseFileEditorManager.java"
click node_execution "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/execution/ExecutionManager.java"
click node_statement_execution "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/execution/statement/StatementExecutionManager.java"
click node_debugger "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/debugger/DatabaseDebuggerManager.java"
click node_assistant_ui "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/chat/window/ui/ChatBoxForm.java"
click node_assistant_manager "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/DatabaseAssistantManager.java"
click node_assistant_adapter "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/service/generic/GenericAssistantAdapter.java"
click node_model_invoker "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/service/generic/model/AssistantModelInvoker.java"
click node_providers "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/provider/AIProvider.java"
click node_assistant_http "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/http/AssistantHttpClient.java"
click node_mcp "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/mcp/AssistantMcpToolProviders.java"
click node_vector_manager "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/vector/DatabaseVectorManager.java"
click node_query_embedding "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/vector/pipeline/QueryEmbeddingPipeline.java"
click node_table_embedding "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/vector/pipeline/TableEmbeddingPipeline.java"
click node_query_processing "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/vector/service/QueryProcessingService.java"
click node_ml_manager "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/ml/DatabaseMLManager.java"
click node_ml_executor "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/ml/execution/MLPipelineExecutor.java"
click node_liquibase "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/liquibase/DatabaseLiquibaseManager.java"
click node_execution_settings "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/execution/common/options/ExecutionEngineSettings.java"
click node_object_management "https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/object/management/ObjectManagementService.java"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_connection,node_connection_handler,node_tns,node_browser,node_object_api toneBlue
class node_editor,node_source_code,node_data_editor,node_execution,node_statement_execution,node_debugger,node_database toneAmber
class node_assistant_ui,node_assistant_manager,node_assistant_adapter,node_model_invoker,node_providers,node_assistant_http,node_mcp toneMint
class node_vector_manager,node_query_embedding,node_table_embedding,node_query_processing,node_ml_manager,node_ml_executor toneRose
class node_liquibase,node_execution_settings,node_object_management,node_developer,node_ide toneIndigo
class node_plugin toneTeal
```

## Components

### Connections and browsing

- [Connection management](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/connection/ConnectionManager.java): `src/main/java/com/dbn/connection/ConnectionManager.java`
- [Connection handler](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/connection/ConnectionHandler.java): `src/main/java/com/dbn/connection/ConnectionHandler.java`
- [TNS import](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/connection/config/tns/TnsImportService.java): `src/main/java/com/dbn/connection/config/tns/TnsImportService.java`
- [Object browser](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/browser/DatabaseBrowserManager.java): `src/main/java/com/dbn/browser/DatabaseBrowserManager.java`
- [Database objects API](https://github.com/oracle/database-navigator/blob/main/modules/dbn-api/src/main/java/com/dbn/api/object/DBSchema.java): `modules/dbn-api/src/main/java/com/dbn/api/object/DBSchema.java`

### Editing and execution

- [Code editor](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/editor/DatabaseFileEditorManager.java): `src/main/java/com/dbn/editor/DatabaseFileEditorManager.java`
- [Source code](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/editor/code/SourceCodeManager.java): `src/main/java/com/dbn/editor/code/SourceCodeManager.java`
- [Data editor](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/editor/DatabaseFileEditorManager.java): `src/main/java/com/dbn/editor/DatabaseFileEditorManager.java`
- [Execution engine](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/execution/ExecutionManager.java): `src/main/java/com/dbn/execution/ExecutionManager.java`
- [Statement execution](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/execution/statement/StatementExecutionManager.java): `src/main/java/com/dbn/execution/statement/StatementExecutionManager.java`
- [Debugger](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/debugger/DatabaseDebuggerManager.java): `src/main/java/com/dbn/debugger/DatabaseDebuggerManager.java`

### Database Assistant

- [Assistant chat UI](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/chat/window/ui/ChatBoxForm.java): `src/main/java/com/dbn/assistant/chat/window/ui/ChatBoxForm.java`
- [Assistant manager](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/DatabaseAssistantManager.java): `src/main/java/com/dbn/assistant/DatabaseAssistantManager.java`
- [Assistant adapters](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/service/generic/GenericAssistantAdapter.java): `src/main/java/com/dbn/assistant/service/generic/GenericAssistantAdapter.java`
- [Model invocation](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/service/generic/model/AssistantModelInvoker.java): `src/main/java/com/dbn/assistant/service/generic/model/AssistantModelInvoker.java`
- [AI providers](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/provider/AIProvider.java): `src/main/java/com/dbn/assistant/provider/AIProvider.java`
- [Assistant HTTP client](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/http/AssistantHttpClient.java): `src/main/java/com/dbn/assistant/http/AssistantHttpClient.java`
- [MCP tools](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/assistant/mcp/AssistantMcpToolProviders.java): `src/main/java/com/dbn/assistant/mcp/AssistantMcpToolProviders.java`

### Data and AI

- [Vector services](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/vector/DatabaseVectorManager.java): `src/main/java/com/dbn/vector/DatabaseVectorManager.java`
- [Query embeddings](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/vector/pipeline/QueryEmbeddingPipeline.java): `src/main/java/com/dbn/vector/pipeline/QueryEmbeddingPipeline.java`
- [Table embeddings](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/vector/pipeline/TableEmbeddingPipeline.java): `src/main/java/com/dbn/vector/pipeline/TableEmbeddingPipeline.java`
- [Query metadata](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/vector/service/QueryProcessingService.java): `src/main/java/com/dbn/vector/service/QueryProcessingService.java`
- [Machine learning](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/ml/DatabaseMLManager.java): `src/main/java/com/dbn/ml/DatabaseMLManager.java`
- [ML pipeline executor](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/ml/execution/MLPipelineExecutor.java): `src/main/java/com/dbn/ml/execution/MLPipelineExecutor.java`

### Database operations

- [Liquibase integration](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/liquibase/DatabaseLiquibaseManager.java): `src/main/java/com/dbn/liquibase/DatabaseLiquibaseManager.java`
- [Execution settings](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/execution/common/options/ExecutionEngineSettings.java): `src/main/java/com/dbn/execution/common/options/ExecutionEngineSettings.java`
- [Object management](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/object/management/ObjectManagementService.java): `src/main/java/com/dbn/object/management/ObjectManagementService.java`

### Other components

- **Developer**
- **IntelliJ IDE**
- **Database**
- [Plugin entry](https://github.com/oracle/database-navigator/blob/main/src/main/java/com/dbn/DatabaseNavigator.java): `src/main/java/com/dbn/DatabaseNavigator.java`

## Connections

- Developer → IntelliJ IDE: uses plugin (evidence: `README.md`)
- IntelliJ IDE → Plugin entry: opens
- Developer → Connection management: configures connection (evidence: `README.md`)
- Connection management → Connection handler: provides connections
- Connection handler → Database: connects to
- Developer → Object browser: browses objects (evidence: `README.md`)
- Object browser → Connection handler: uses connection
- Object browser → Database objects API: shows objects
- Developer → Code editor: opens code (evidence: `README.md`)
- Developer → Data editor: edits table data (evidence: `README.md`)
- Code editor → Source code: manages source
- Developer → Execution engine: runs programs (evidence: `README.md`)
- Execution engine → Statement execution: dispatches statements
- Execution engine → Database: executes against
- Developer → Debugger: debugs programs (evidence: `README.md`)
- Developer → Assistant chat UI: asks assistant
- Assistant chat UI → Assistant manager: submits prompt
- Assistant manager → Assistant adapters: selects adapter
- Assistant adapters → Model invocation: invokes model
- Model invocation → AI providers: uses provider
- Assistant adapters → Assistant HTTP client: sends requests
- Assistant manager → MCP tools: offers tools
- Developer → Vector services: uses embeddings
- Vector services → Query embeddings: runs query pipeline
- Vector services → Table embeddings: runs table pipeline
- Query embeddings → Query metadata: builds metadata (evidence: `src/main/java/com/dbn/vector/pipeline/QueryEmbeddingPipeline.java`)
- Query embeddings → Database: writes embeddings
- Developer → Machine learning: uses ML
- Machine learning → ML pipeline executor: executes pipeline
- ML pipeline executor → Database: trains model
- Developer → Liquibase integration: manages migrations
- Execution engine → Execution settings: uses settings (evidence: `src/main/java/com/dbn/execution/common/options/ExecutionEngineSettings.java`)
- Object browser → Object management: manages objects
- TNS import → Connection management: imports connection data
