How oracle/database-navigator works
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: DatabaseBrowserManager.java Object browser · ExecutionManager.java Execution engine · DatabaseAssistantManager.java Assistant manager · GenericAssistantAdapter.java Assistant adapters
Components 31
Connections and browsing
- Connection management
src/main/java/com/dbn/connection/ConnectionManager.java - Connection handler
src/main/java/com/dbn/connection/ConnectionHandler.java - TNS import
src/main/java/com/dbn/connection/config/tns/TnsImportService.java - Object browser
src/main/java/com/dbn/browser/DatabaseBrowserManager.java - Database objects API
modules/dbn-api/src/main/java/com/dbn/api/object/DBSchema.java
Editing and execution
- Code editor
src/main/java/com/dbn/editor/DatabaseFileEditorManager.java - Source code
src/main/java/com/dbn/editor/code/SourceCodeManager.java - Data editor
src/main/java/com/dbn/editor/DatabaseFileEditorManager.java - Execution engine
src/main/java/com/dbn/execution/ExecutionManager.java - Statement execution
src/main/java/com/dbn/execution/statement/StatementExecutionManager.java - Debugger
src/main/java/com/dbn/debugger/DatabaseDebuggerManager.java
Database Assistant
- Assistant chat UI
src/main/java/com/dbn/assistant/chat/window/ui/ChatBoxForm.java - Assistant manager
src/main/java/com/dbn/assistant/DatabaseAssistantManager.java - Assistant adapters
src/main/java/com/dbn/assistant/service/generic/GenericAssistantAdapter.java - Model invocation
src/main/java/com/dbn/assistant/service/generic/model/AssistantModelInvoker.java - AI providers
src/main/java/com/dbn/assistant/provider/AIProvider.java - Assistant HTTP client
src/main/java/com/dbn/assistant/http/AssistantHttpClient.java - MCP tools
src/main/java/com/dbn/assistant/mcp/AssistantMcpToolProviders.java
Data and AI
- Vector services
src/main/java/com/dbn/vector/DatabaseVectorManager.java - Query embeddings
src/main/java/com/dbn/vector/pipeline/QueryEmbeddingPipeline.java - Table embeddings
src/main/java/com/dbn/vector/pipeline/TableEmbeddingPipeline.java - Query metadata
src/main/java/com/dbn/vector/service/QueryProcessingService.java - Machine learning
src/main/java/com/dbn/ml/DatabaseMLManager.java - ML pipeline executor
src/main/java/com/dbn/ml/execution/MLPipelineExecutor.java
Database operations
- Liquibase integration
src/main/java/com/dbn/liquibase/DatabaseLiquibaseManager.java - Execution settings
src/main/java/com/dbn/execution/common/options/ExecutionEngineSettings.java - Object management
src/main/java/com/dbn/object/management/ObjectManagementService.java
Other components
- Developer
- IntelliJ IDE
- Database
- Plugin entry
src/main/java/com/dbn/DatabaseNavigator.java
Connections 34
- Developer → IntelliJ IDE: uses plugin
README.md - IntelliJ IDE → Plugin entry: opens
- Developer → Connection management: configures connection
README.md - Connection management → Connection handler: provides connections
- Connection handler → Database: connects to
- Developer → Object browser: browses objects
README.md - Object browser → Connection handler: uses connection
- Object browser → Database objects API: shows objects
- Developer → Code editor: opens code
README.md - Developer → Data editor: edits table data
README.md - Code editor → Source code: manages source
- Developer → Execution engine: runs programs
README.md - Execution engine → Statement execution: dispatches statements
- Execution engine → Database: executes against
- Developer → Debugger: debugs programs
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
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
src/main/java/com/dbn/execution/common/options/ExecutionEngineSettings.java - Object browser → Object management: manages objects
- TNS import → Connection management: imports connection data