Migrate SQL to FalkorDB

Migrate and continuously sync data from SQL systems into FalkorDB

falkordb Updated

File contents

Migrate SQL to FalkorDB

Migrate and incrementally sync data from SQL supporting systems (PostgreSQL, MySQL, BigQuery, etc.) into FalkorDB using declarative JSON/YAML mappings.

Usage

Use the corresponding Rust-based loader (e.g., postgres-to-falkordb) to migrate data either as a single run or a continuous sync (daemon mode).

Example

# Build the tool (e.g., for PostgreSQL)
cd PostgreSQL-to-FalkorDB/postgres-to-falkordb
cargo build --release

# Single run for initial migration
cargo run --release -- --config config.yaml

# Continuous sync (daemon mode)
cargo run --release -- --config config.yaml --daemon --interval-secs 60

Notes

  • Supports multiple systems: BigQuery, ClickHouse, Databricks, MariaDB, MySQL, PostgreSQL, Snowflake, Spark, and SQL Server.
  • Provides a control plane web tool to configure, initiate, and track ETL/CDC data migration runs.
  • Maps tabular relational data to graph structures based on declarative configurations.

falkordb/skills/tree/main/ingestion-skills/migrate-sql-to-falkordb commit 52745fca18

Frequently asked questions

npx skillmds@latest add falkordb/migrate-sql-to-falkordb