Data migration

Data migration

Where is the data you want to migrate?

💡

If you can choose the format of the data you want to import, the fastest way to import data into Memgraph is from a CSV file using the LOAD CSV clause. Learn more about the shortest path to import data into Memgraph by reading best practices for import.

Need help with data migration?

Schedule a 30 min session with one of our engineers to discuss how Memgraph fits with your architecture. Our engineers are highly experienced in helping companies of all sizes to integrate and get the most out of Memgraph in their projects. Talk to us about data modeling, optimizing queries, defining infrastructure requirements or migrating from your existing graph database. No nonsense or sales pitch, just tech.

Book a call

CSV files

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.

JSON files

You can import data from a JSON file into Memgraph by using the json_util query module, which contains procedures for loading JSON files from a local file and from a remote address.

You can also use the import_util.json procedure to import data from a local JSON file, but the file needs to in a specific format defined by the procedure.

CYPHERL files

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.

Neo4j

Export the data into a CSV file and import it into Memgraph using the LOAD CSV clause, like in this example.

Alternatively, you can use the migrate module which allows you to access data from a Neo4j database.

Data from an application or a program

Memgraph offers a wide range of client libraries that can be used to connect directly to the platform and import data.

Relational database management systems

Ideally, export data into a CSV file, remodeled the data and rewrite the CSV file, then import it into Memgraph using the LOAD CSV clause, like in this example.

Alternatively, you can use the migrate module from the MAGE graph library which allows you to access data from a MySQL database, an SQL Server, Oracle database, PostgreSQL or a CSV file in AWS S3.

Data from a stream

Memgraph comes with full streaming support, and you can connect directly to a Kafka, Redpanda or Pulsar stream using Cypher queries or Memgraph Lab.

Parquet, ORC or IPC/Feather/Arrow file

If you are a Python user you can import Parquet, ORC or IPC/Feather/Arrow file into Memgraph using GQLAlchemy.

NetworkX, PyG or DGL graph

If you are a Python user you can import NetworkX, PyG or DGL graph into Memgraph using GQLAlchemy.

Best practicesBest practices