CONNECTED DATA

Query connected data where it lives.

Run graph queries inside PostgreSQL, or keep results updated as your data changes. Choose the approach that matches your application.

SQL/PGQ guide Continuous Graph guide

CHOOSE THE MODEL

Run a graph query now or keep results live.

Choose a one-off database query or a continuously updated result for your application.

DATABASE QUERY

PostgreSQL SQL/PGQ

PG 19 GA pending

Store and query relationships directly in PostgreSQL 19, with migrations and database-first tooling.

Source: PostgreSQL property graphs
How it runs: Query the database when you need an answer
Availability: Tested on Beta 3; stable waits for GA

Read the technical guide

LIVE GRAPH RESULTS

Continuous Graph

1.1 RC public

Keep permitted graph results updated as rows change. BlueTusk uses the smallest safe update and reruns the full query whenever it cannot prove a smaller update is correct.

Source: Committed changes from Streams
How it runs: Small update, scoped query, or full safe refresh
Security: Keeps the original user permissions and row rules
Availability: Public RC; stable waits for PostgreSQL 19 GA

Read the technical guide

SAFE VERSION CHECK

Graph features turn on only when the server is ready.

BlueTusk checks that PostgreSQL actually provides SQL/PGQ before using it. It does not assume support from the version number alone.

View source evidence

15OffGraph support unavailable

16OffGraph support unavailable

17OffGraph support unavailable

18OffGraph support unavailable

19OnFeature check and tests pass

WRITE GRAPH QUERIES

Use SQL directly or build a typed EF query.

Run SQL/PGQ directly

Use SQL to create a property graph and run MATCH queries directly through the provider.

GraphQuery.cs

await using var command = dataSource.CreateCommand("""
    SELECT *
    FROM GRAPH_TABLE (
      social_graph
      MATCH (person:Person)-[knows:KNOWS]->(friend:Person)
      COLUMNS (person.name AS person, friend.name AS friend)
    )
    """);

await using var reader = await command.ExecuteReaderAsync();

PRODUCTION-STYLE EXAMPLES

See continuously updated graph results in action.

Both are complete, runnable repository projects rather than simplified mock-ups.

FRAUD

Detect connected financial risk

Keep account and transfer relationships updated so suspicious paths can be found quickly.

Open sample

NETWORK

Track a changing network

Keep network devices and their connections updated from committed database changes.

Open sample