pgGraph IDE and graph visualization tool

Getting started with pgGraph and gdotv is easy. It’s just one simple installation, available on Windows, macOS and Linux. No prerequisites, additional configuration or installation required. You can get started in seconds.

Enter your PostgreSQL connection details, point gdotv at the pgGraph-enabled database and you are ready to query. pgGraph keeps one implicit graph per database, so there is no graph name to specify.

Want a step-by-step walkthrough? Make sure to check out our demo, Get Started with pgGraph + gdotv on YouTube, or read our introduction to pgGraph support.

pgGraph is driven by SQL functions in a graph schema, but you do not have to hand-write them. gdotv lets you write GQL directly and automatically runs it through pgGraph’s graph.gql() function, so you get GQL syntax validation, schema-aware autocomplete and parameter injection as you type. It is the same approach gdotv takes for Apache AGE with Cypher.

Prefer the raw primitives? Switch the query tab to the “SQL (pgGraph)” language and call graph.search(), graph.traverse() or graph.shortest_path() yourself. Results that contain graph elements render as an interactive graph either way, with a table, JSON and object-browser view one click away.

Not yet. pgGraph is in early alpha, and its maintainer’s guidance is to avoid production use for now, even though it has been tested to be stable. Run it in Docker or a dedicated development database while you evaluate it.

Two further things to know before you start: graphs built in pgGraph’s default read-only projection mode cannot be edited from gdotv, and interactive create, update and delete of vertices, edges and properties requires a graph built in mutable_overlay mode.

Both bring graph queries to PostgreSQL, but from opposite directions. Apache AGE adds a dedicated property-graph model and the openCypher language to Postgres, so you model and store a graph inside your database. pgGraph builds a derived graph index over the relational tables you already have and exposes traversals as functions, so nothing about your schema changes and the index can be rebuilt at any time.

Choose AGE when you want a real property graph living next to your relational data and Cypher to query it. Choose pgGraph when the graph is already implicit in your tables and foreign keys and you want fast traversals, shortest paths and GQL over it with no migration. gdotv connects to both, so you can compare them side by side.

Organizing data derived via powerful data visualization tools have several real-life applications. Graph visualization and analysis resources allow users to make informed decisions based on actual data. Here are a few examples of the type of companies or clients that can leverage pgGraph along with the robust data visualization aspect offered by gdotv:

• Data scientists and managers: Visual data analysis allows users to uncover and understand emerging patterns and relationships between data points, discover valuable insights to make informed decisions on ways to transform business processes.
• Cyber security groups: Build security graphs to represent protected assets, infrastructure, code dependencies or networks and visualize the connected relationships throughout the organization.
• Business intelligence analysts: Create customized reports and visualizations that can be easily executed for analysts to investigate and communicate on interaction between business data points.
• Fraud detection: Detect fraud patterns by modeling relationships between transactions and financial actors, then interactively visualize graph data to uncover and present potentially suspicious behavior.

gdotv Desktop runs locally on your device – no deployment needed and no handing over your data to a third-party system. Everything happens within your organisation’s network, and we have no access to your data.

Our Team and Enterprise versions run within your own environment, providing the same security benefits.

It’s easy to install and configure too: our setup wizard gets you connected to your graph database in seconds.

Yes! Whether you’d like to access multiple pgGraph databases, or interact with other graph vendors at the same time, gdotv doesn’t limit you to a single database. You can establish as many connections as you like from within our intuitive UI, and seamlessly switch between them.

Connecting is easy, and there’s no need to manage multiple vendor specific user interfaces. With gdotv, query and compare results from all your RDF and Labeled Property Graph databases under one umbrella.