Graph Databases

Neo4j Cypher Examples

// Find all of Alice's friends
MATCH (a:User {name: 'Alice'})-[:FRIENDS_WITH]->(friend)
RETURN friend.name

// Friends of friends (2 hops)
MATCH (a:User {name: 'Alice'})-[:FRIENDS_WITH*2]->(fof)
RETURN DISTINCT fof.name

// Shortest path between two users
MATCH path = shortestPath(
  (a:User {name: 'Alice'})-[*]-(b:User {name: 'Bob'})
)
RETURN path

// Recommend products bought by similar users
MATCH (u:User {name: 'Alice'})-[:PURCHASED]->(p:Product)<-[:PURCHASED]-(similar)
MATCH (similar)-[:PURCHASED]->(rec:Product)
WHERE NOT (u)-[:PURCHASED]->(rec)
RETURN rec.name, COUNT(*) as score ORDER BY score DESC