In this challenge, you will use the Neo4j MCP server to explore the movies database schema.
How to complete this challenge
Your goal is to find out which outgoing relationships go from a User node in the movies database.
Step 1: Open a new chat window
Open a new chat window to clear the history and start a new conversation with the agent.
VS Code Chat Keyboard Shortcuts
In VS Code, you can open the chat window using Ctrl/Cmd + Shift + I.
You can create a new chat using Ctrl/Cmd + N.
Ensure that the chat is in Agent mode by selecting the Agent option in the bottom left hand corner of the chat window.
Step 2: Ask About User Relationships
Ask the specific question:
What outgoing relationships does the User node have?Step 3: Review the Response
The agent will use the get-schema tool to examine the database schema and provide information about User node relationships.
If you have followed the instructions correctly, you should now see a response from the agent that answers the question.
User Node Relationships
After exploring the database schema, what outgoing relationship does a User node have in the movies database?
-
❏
WATCHED -
✓
RATED -
❏
LIKED -
❏
REVIEWED -
❏
FOLLOWS
Hint
Use the agent to ask about the database schema. You can ask a vague question to get a comprehensive overview of the schema:
What is the schema of the movies database?Or you can ask a more targeted question to get information about a specific node type:
What relationships does a User node have?The agent should give you a single answer to the question.
Solution
The correct answer is RATED.
According to the movies database schema, User nodes are connected to Movie nodes through the RATED relationship. This means users can rate movies, and this rating relationship is stored as an outgoing relationship from the User node to the Movie node.
The other options (WATCHED, LIKED, REVIEWED, FOLLOWS) are not present in this particular database schema.
Summary
You used the get-schema tool to identify the outgoing relationships for User nodes in the movies database.
In the next challenge, you will invoke the read-cypher tool to answer a question about the dataset.