How do I install the Surreal Sync skill?

Run npx skillmds@latest add johnalbertini14-glitch/surreal-sync-2 in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Surreal Sync safe to use?

This skill has not completed SkillMD's automated safety review yet. Independent scanners report: SkillSpector: PASS, Skill Scanner: PASS. Capability flags: makes network calls, reads secrets. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Surreal Sync?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Surreal Sync free to use?

Yes. Installing skills from SkillMD is free. This skill is licensed under MIT.

Who published Surreal Sync?

johnalbertini14-glitch (@johnalbertini14-glitch) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Surreal Sync by johnalbertini14-glitch

Name: Surreal Sync
Rating: 4.5 (4 reviews)
Author: johnalbertini14-glitch

File contents

Surreal-Sync -- Data Migration and Synchronization

Surreal-Sync is a CLI tool for migrating data from various database sources to SurrealDB with full and incremental synchronization via Change Data Capture (CDC).

Supported Sources

Source	Full Sync	Incremental CDC	Method
MongoDB	Yes	Yes	Change streams
MySQL	Yes	Yes	Trigger-based CDC + sequence checkpoints
PostgreSQL (triggers)	Yes	Yes	Trigger-based CDC + sequence checkpoints
PostgreSQL (wal2json)	Yes	Yes	Logical replication with wal2json plugin
Neo4j	Yes	Yes	Timestamp-based tracking
JSONL Files	Yes	N/A	Batch import from JSON Lines
Apache Kafka	Yes	Yes	Consumer subscriptions with deduplication

Quick Start

# Install surreal-sync (Rust binary)
cargo install surreal-sync

# Full sync from PostgreSQL (trigger-based)
surreal-sync from postgres trigger-full \
  --connection-string "postgresql://user:pass@localhost/mydb" \
  --surreal-endpoint "http://localhost:8000" \
  --surreal-username root \
  --surreal-password root \
  --to-namespace prod \
  --to-database main

# Incremental CDC from PostgreSQL (wal2json)
surreal-sync from postgres wal2json \
  --connection-string "postgresql://user:pass@localhost/mydb" \
  --surreal-endpoint "http://localhost:8000" \
  --surreal-username root \
  --surreal-password root \
  --to-namespace prod \
  --to-database main

# Full sync from MongoDB
surreal-sync from mongo full \
  --connection-string "mongodb://localhost:27017/mydb" \
  --surreal-endpoint "http://localhost:8000" \
  --surreal-username root \
  --surreal-password root \
  --to-namespace prod \
  --to-database main

# Batch import from JSONL
surreal-sync from jsonl import \
  --file data.jsonl \
  --surreal-endpoint "http://localhost:8000" \
  --surreal-username root \
  --surreal-password root \
  --to-namespace prod \
  --to-database main

# Consume from Kafka
surreal-sync from kafka consume \
  --bootstrap-servers "localhost:9092" \
  --topic my-events \
  --surreal-endpoint "http://localhost:8000" \
  --surreal-username root \
  --surreal-password root \
  --to-namespace prod \
  --to-database main

CLI Pattern

surreal-sync from <SOURCE> <COMMAND> \
  --connection-string [CONNECTION STRING] \
  --surreal-endpoint [SURREAL ENDPOINT] \
  --surreal-username [SURREAL USERNAME] \
  --surreal-password [SURREAL PASSWORD] \
  --to-namespace <NS> \
  --to-database <DB>

Key Features

Automatic schema inference and SurrealDB table creation
Record ID mapping from source primary keys
Relationship extraction and graph edge creation
Configurable batch sizes and parallelism
Resumable sync with checkpoint tracking
Deduplication for Kafka consumers

Full Documentation

See the main skill's rule file for complete guidance:

rules/surreal-sync.md -- source configuration, schema mapping, CDC setup, conflict resolution, and production deployment
surrealdb/surreal-sync -- upstream repository

---name: surreal-sync-2description: Data migration and synchronization to SurrealDB from MongoDB, PostgreSQL, MySQL, Neo4j, Kafka, and JSONL. Full and incremental CDC sync. Part of the surreal-skills collection.license: MIT---# Surreal-Sync -- Data Migration and SynchronizationSurreal-Sync is a CLI tool for migrating data from various database sources toSurrealDB with full and incremental synchronization via Change Data Capture (CDC).## Supported Sources| Source | Full Sync | Incremental CDC | Method ||--------|-----------|----------------|--------|| MongoDB | Yes | Yes | Change streams || MySQL | Yes | Yes | Trigger-based CDC + sequence checkpoints || PostgreSQL (triggers) | Yes | Yes | Trigger-based CDC + sequence checkpoints || PostgreSQL (wal2json) | Yes | Yes | Logical replication with wal2json plugin || Neo4j | Yes | Yes | Timestamp-based tracking || JSONL Files | Yes | N/A | Batch import from JSON Lines || Apache Kafka | Yes | Yes | Consumer subscriptions with deduplication |## Quick Start```bash# Install surreal-sync (Rust binary)cargo install surreal-sync# Full sync from PostgreSQL (trigger-based)surreal-sync from postgres trigger-full \ --connection-string "postgresql://user:pass@localhost/mydb" \ --surreal-endpoint "http://localhost:8000" \ --surreal-username root \ --surreal-password root \ --to-namespace prod \ --to-database main# Incremental CDC from PostgreSQL (wal2json)surreal-sync from postgres wal2json \ --connection-string "postgresql://user:pass@localhost/mydb" \ --surreal-endpoint "http://localhost:8000" \ --surreal-username root \ --surreal-password root \ --to-namespace prod \ --to-database main# Full sync from MongoDBsurreal-sync from mongo full \ --connection-string "mongodb://localhost:27017/mydb" \ --surreal-endpoint "http://localhost:8000" \ --surreal-username root \ --surreal-password root \ --to-namespace prod \ --to-database main# Batch import from JSONLsurreal-sync from jsonl import \ --file data.jsonl \ --surreal-endpoint "http://localhost:8000" \ --surreal-username root \ --surreal-password root \ --to-namespace prod \ --to-database main# Consume from Kafkasurreal-sync from kafka consume \ --bootstrap-servers "localhost:9092" \ --topic my-events \ --surreal-endpoint "http://localhost:8000" \ --surreal-username root \ --surreal-password root \ --to-namespace prod \ --to-database main```## CLI Pattern```surreal-sync from <SOURCE> <COMMAND> \ --connection-string [CONNECTION STRING] \ --surreal-endpoint [SURREAL ENDPOINT] \ --surreal-username [SURREAL USERNAME] \ --surreal-password [SURREAL PASSWORD] \ --to-namespace <NS> \ --to-database <DB>```## Key Features- Automatic schema inference and SurrealDB table creation- Record ID mapping from source primary keys- Relationship extraction and graph edge creation- Configurable batch sizes and parallelism- Resumable sync with checkpoint tracking- Deduplication for Kafka consumers## Full DocumentationSee the main skill's rule file for complete guidance:- **[rules/surreal-sync.md](../../rules/surreal-sync.md)** -- source configuration, schema mapping, CDC setup, conflict resolution, and production deployment- **[surrealdb/surreal-sync](https://github.com/surrealdb/surreal-sync)** -- upstream repository

Frequently asked questions

Surreal Sync