openclaw 网盘下载
OpenClaw

技能详情(站内镜像,无评论)

首页 > 技能库 > surreal-sync

Data migration and synchronization to SurrealDB from MongoDB, PostgreSQL, MySQL, Neo4j, Kafka, and JSONL. Full and incremental CDC sync. Part of the surreal-...

数据与表格

许可证:MIT-0

MIT-0 ·免费使用、修改和重新分发。无需归因。

版本:v1.2.1

统计:⭐ 2 · 451 · 0 current installs · 0 all-time installs

2

安装量(当前) 0

🛡 VirusTotal :良性 · OpenClaw :良性

Package:24601/surreal-sync

安全扫描(ClawHub)

  • VirusTotal :良性
  • OpenClaw :良性

OpenClaw 评估

The skill's description, examples, and requirements are internally consistent with a CLI data-sync tool; it is instruction-only, asks for no unrelated environment credentials, and does not request elevated persistence — but exercise normal caution around how you install and pass database passwords.

目的

Name/description (SurrealDB sync from various sources) matches the SKILL.md content: CLI usage, supported sources, CDC modes, and examples are exactly what you'd expect for a migration/sync tool.

说明范围

SKILL.md gives concrete CLI examples and connection-string usage only; it does not instruct the agent to read unrelated system files or secret stores. Note: examples show credentials passed as command-line flags (e.g., --surreal-password), which can expose secrets via process listings or logs — this is a usability/security note rather than a scope mismatch.

安装机制

The skill has no install specification and no code files (instruction-only). It suggests installing a Rust binary via 'cargo install surreal-sync', which is a plausible and proportional install step for a Rust CLI; the skill itself will not download or write code to disk automatically.

证书

No required environment variables, no unrelated credentials, and CLI examples require only the typical connection strings/credentials for the source DB and SurrealDB destination — all proportional to the stated purpose.

持久

always is false and the skill does not request persistent system-wide privileges or modification of other skills/configs. Autonomous invocation is allowed (platform default) but not combined with other concerning privileges.

综合结论

This skill appears coherent and focused on data migration to SurrealDB. Before installing or running it: (1) verify the upstream repository (the SKILL.md references github.com/surrealdb/surreal-sync) and prefer official release binaries or pinned commits; (2) avoid putting passwords on the command line where possible — use config files, environment variables, or secret stores to prevent exposure in process lists and logs; (3) run initial syncs…

安装(复制给龙虾 AI)

将下方整段复制到龙虾中文库对话中,由龙虾按 SKILL.md 完成安装。

请把本段交给龙虾中文库(龙虾 AI)执行:为本机安装 OpenClaw 技能「surreal-sync」。简介:Data migration and synchronization to SurrealDB from MongoDB, PostgreSQL, MySQL…。
请 fetch 以下地址读取 SKILL.md 并按文档完成安装:https://raw.githubusercontent.com/openclaw/skills/refs/heads/main/skills/24601/surreal-sync/SKILL.md
(来源:yingzhi8.cn 技能库)

SKILL.md

打开原始 SKILL.md(GitHub raw)

---
name: surreal-sync
description: "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
metadata:
  version: "1.0.4"
  author: "24601"
  parent_skill: "surrealdb"
  snapshot_date: "2026-02-19"
  upstream:
    repo: "surrealdb/surreal-sync"
    release: "v0.3.4"
    sha: "8166b2b041b1"
---

# 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

```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 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](../../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