In today’s data-driven enterprises, uncovering meaningful relationships within complex data is crucial for driving strategic business decisions—and graph analytics make it possible to unlock these valuable insights. Oracle now has a new SQL Developer graph visualization extension for Visual Studio Code (VS Code), making it easy for developers to run graph queries in SQL and visualize the results instantly and interactively. This accelerates the integration of graph analytics in applications, since developers no longer need to leave their trusted coding environment, or look for and get approval for a third-party tool that works with the organization’s database version. It’s all within a single familiar tool, streamlining the development workflow.
Increase productivity with a unified workflow
VS Code is a powerful open-source code editor embraced by developer teams across Windows, Linux, and macOS. The Oracle SQL Developer extension for VS Code allows developers to securely connect to Oracle Database 23ai and write and execute operational property graph queries in SQL. With the graph visualization extension, they can immediately visualize the results of graph queries, right within the same interface. There’s no need to export data or use a third-party application: simply go from query to interactive visualization with a single click.
Unlock the power of graph data—it’s easier than ever
Graph data models help organizations discover crucial but often hidden connections—like customer interactions, fraud rings, or supply chain dependencies. These connections are hard to decipher in spreadsheets or standard views of data. With the new graph visualization extension, you can take these complex query results and transform them into interactive, intuitive visual representations. This seamless experience enables both technical and business teams to:
· Instantly identify patterns, anomalies, and relationships—without copying or duplicating data
· Simplify graph query validations through visual cues
· Accelerate the workflow for adapting graph models into analytics and business apps
With this integration into a favorite developer tool –VS Code—organizations can leverage the power of graph analytics in their applications without the friction of switching tools or disrupting productivity. And since there’s no need for external visualization software, organizations can also reduce tool sprawl, minimize training overhead, and get more accurate, real-time insights—all within the environment your teams already use.
Experience it today
Getting started couldn’t be easier. Developers just need to install the graph visualization extension from the VS Code Extensions view, connect to an Oracle Database 23ai instance, and run SQL graph queries. And with just one click on the Visualize SQL Graph button, your organization’s data relationships come to life—directly inside VS Code. See this technical blog for how to get started.
Additional Resources
We’d love to hear from you – Please discuss your experiences, post ideas, or ask questions on the public Oracle Database Discussions forum. Try our LiveLab: Explore Operational Property Graphs in Oracle Database 23ai. Or check out our Oracle Graph Learning Path blog.