Querying with mgconsole
The easiest way to execute openCypher queries against Memgraph is by using Memgraph's command-line tool, mgconsole, which is installed together with Memgraph.
If you installed Memgraph using Docker, you will need to run the client
using the following command (remember to replace HOST
with valid IP of
the container - see Docker Note):
docker run -it --entrypoint=mgconsole memgraph --host HOST --use-ssl=False
Otherwise, you can connect to the running Memgraph instance by issuing the following shell command:
mgconsole --use-ssl=False
After the client has started it should present a command prompt similar to:
Type :help for shell usage
Quit the shell by typing Ctrl-D(eof) or :quit
Connected to 'memgraph://127.0.0.1:7687'
memgraph>
At this point, it is possible to execute openCypher queries on Memgraph. Each
query needs to end with the ;
(semicolon) character. For example:
CREATE (u:User {name: "Alice"})-[:Likes]->(m:Software {name: "Memgraph"});
The above will create 2 nodes in the database, one labeled "User" with name "Alice" and the other labeled "Software" with name "Memgraph". It will also create a relationship that "Alice" likes "Memgraph".
To find created nodes and relationships, execute the following query:
MATCH (u:User)-[r]->(x) RETURN u, r, x;