Import data
There are a few methods for importing data into Memgraph and they cover:
- How to import CSV files into Memgraph?
- How to import JSON files into Memgraph?
- How to import CYPHERL files with Cypher queries into Memgraph?
- How to migrate data from a relational database?
- How to import streaming data into Memgraph?
- How to import data directly from an application/program?
How to import CSV files into Memgraph?
To import data from CSV files into Memgraph, use the LOAD CSV clause, which is used as a standard Cypher clause, and can be invoked straight from a running Memgraph instance.
How to import JSON files into Memgraph?
You can import the JSON file into Memgraph by using the JSON query module, which has procedures for loading JSON file from a local file from a remote address.
How to import CYPHERL files with Cypher queries into Memgraph?
If your data is in the form of Cypher queries (CREATE
and MERGE
clauses)
within a CYPHERL file it can be imported via Memgraph
Lab or mgconsole.
How to migrate data from a relational database?
You can migrate data from a MySQL or
PostgresSQL database using the
mgmigrate
tool.
How to import streaming data into Memgraph?
Memgraph comes with full streaming support, and you can connect directly to a Kafka, Redpanda or Pulsar stream using Cypher queries or Memgraph Lab wizard.
How to import data directly from an application or a program?
Memgraph offers a wide range of drivers that can be used to connect directly to the platform. You can find a list of all the supported drivers here.
Where to next?
You can also connect to streams and import data from CYPHERL files to an instance running in Memgraph Cloud. To learn more about the Cypher language, check out our Cypher manual or Memgraph Playground for interactive guides. For real-world examples of how to use Memgraph, we strongly suggest going through one of the available tutorials.