SQL Developer Graph Visualization Extension for VS Code

Overview

This extension enhances the Oracle SQL Developer extension with graph visualization capabilities for Oracle Database 23ai and above. Visualize and explore the result of GRAPH_TABLE queries as a graph.

Features

• Seamless Integration: Works alongside the Oracle SQL Developer extension for VS Code
• Interactive Graph Visualization: Visualize query results containing GRAPH_TABLE operator data
• Rich Styling Options: Customize vertex and edge appearances with colors, icons, animations, and more
• Graph Exploration: Navigate complex graph structures with intuitive controls

Prerequisites

• Oracle SQL Developer Extension for VS Code, version 25.1.1 or higher (will be installed automatically if not present)
• Oracle Database 23ai or higher

Getting Started

1. Connect to your Oracle database using the SQL Developer extension
2. Create a new SQL worksheet
3. Write a SQL query that includes the GRAPH_TABLE operator
   • Note: The query must project vertex/edge IDs for the extension to work correctly
4. Click the "Visualize SQL Graph" button in the editor toolbar or use the command palette (Ctrl/Cmd+Shift+P) and select "Visualize SQL Graph"

Basic Graph Query

select *
from graph_table(sales_pg
	match(p1)-[c]->(p2)
	columns(vertex_id(p1) as id1, vertex_id(p2) as id2, edge_id(c) as id)
)

Support

If you encounter issues, please report it on the SQL Developer for VS Code forum.

License

Oracle Graph Visualization extension for VS Code is distributed free, under the Free Use Terms and Conditions (FUTC) License.