The neo4j desktop app helps you to analyze a Neo4j database quickly.
In version 1.0.1 and higher it is possible to analyze Neo4j version 4+ servers. In that case there will be a tab per database with the database analyzer in it.
The application has three main tools:
Counts Node, Relationships, Labels, Relationship Types
Live Count of #Nodes per Label and #Relationships per Relationship Type
Explore the Database Schema
run in the neo4j desktop (1.1.10+) - add the following URL in the tab "Graph Applications"-"Install Graph Application": https://neo.jfrog.io/neo/api/npm/npm/neo4j-db-analyzer - select a Project and do "Add Application"
With the default settings this tool counts everything possible while using the count store (database statistics), which means that the queries are not expensive for the database. The following counts are executed while using the count store:
- Relationship Types
- Outgong relationship types per label
- Incoming relationship types per label
Analyzing Properties and Label Combinations
When you want to analyze Node or Relationship properties or Check Label Combinations then the query load on the database is heavy. Therefore you have to specify in the Label Filter and Relationship Type Filter which Labels and Relationship Types you want to analyze the properties from.
Be careful with very big databases to analyze properties or label combinations, don't do it on production.
The following information is gathered when you analyze Properties and Label Combinations
|Label Combinations and their Counts|
Label Property Combinations Counts
list all properties found and their data types per Label
Relationship Property Combinations Counts
list all properties found and their data types per Relationship Type
Note that when sampling is used the found properties and label combinations are an estimate.
A Database with:
- 46M Nodes
- 61M Relationships
- 101 Labels
- 124 Relationship Types
- 18 Label Combinations
The analyzis with Label/RelationshipType Properties and Label Combinations took ~15 minutes. The analyzis without Label/RelationshipType Properties and Label Combinations took 2 seconds.
In this tab you can see all the details of a Label by clicking on the 'Label' bar.
In this tab a tile is shown per label combination with the count of it.
In this tab you can see all the details of a Relationship Type by clicking on the bar. If there are no properties for the Relationship Type you cannot expand the bar.
Indexes, Constraints and Log
For convenience the Indexes and Constraints of the database are listed here. The Log tab contains the logging of the analyzis which is shown in the Summary tab during analyzing.
You can start a Live Count to count the amount of nodes per Label or the amount of relationships per Relationship Type. These counts are all done on the count store, which are very efficient. By default the first Label and the first Relationship Type is selected.
In the example below we see that every 10 seconds a count will be done for the Labels "AccountHolder" and "Country" and the Relationship Types "DELIVERED_AT" and "HAS_BANKACCOUNT".
Note: With the Label Filter and the Relationship Type Filter you can add or remove Labels or Relationship Types from the count. You will see the difference in the 'next' count.
This tools makes it possible to 'walk' over your database model even when there are a lot of Labels and Relationship Types. The tool only works when the Database is Analyzed.
The app starts with an empty canvas and you can start the exploration of the Model via selecting a Label via the "Labels Filter" or by pressing "Show All". When the ModelComplexity is too high you will get when clicking on "Show All" a warning that showing the complete model will probably fail. In that case you can better use the "Labels Filter" to start your model exploration. The complexity of the model is calculated ad follows:
ModelComplexity = (Label Count + RelationshipType Count) * (Relationship Count / Node Count) When the ModelComplexity is above 400, then "Show All" will give a warning.
For smaller model's this option will the fastest way to get a quick overview of the database model.
When a Node is selected it becomes blue, and the properties of the Node will be shown on the Right. This will contain the Node Count of the Label and the Incoming and Outgoing Relationship Types with their Relationhship counts. When the properties of this Label are analyzed you will see here also a property list with property types.
With the context menu on a selected "Label" Node you can add the incoming and outgoing relationship types to the visualization including the connected "Label" Nodes. It is also possible to remove a Relationship Type or a "Label" Node from the canvas.
Note that when you 'Clear' a Label or Relationship Type the Connected Nodes will remain on the canvas.