Fivetran

Fivetran — manage connectors, destinations, sync status, and groups via REST API

Security Scan

The skill's code, required environment variables, and instructions align with its stated purpose of calling the Fivetran REST API; nothing indicates it is trying to do unrelated or malicious work.

Purpose & Capability

Name/description (Fivetran REST API: connectors, destinations, groups, syncs) match the provided Python CLI which implements those endpoints. The required env vars (FIVETRAN_API_KEY, FIVETRAN_API_SECRET) are exactly what an API client needs.

Instruction Scope

SKILL.md directs running the included script and does not ask for extra data. The script itself will, as a fallback, attempt to read a .env file under the workspace path (~/.openclaw/workspace/.env or $WORKSPACE/.env) when an environment variable is not set. This file-read behavior is reasonable for credential lookup but is not called out in SKILL.md and represents a small scope extension to how credentials may be obtained.

Install Mechanism

No install spec or external downloads — instruction-only with a bundled Python script. No network fetches of code or third-party packages during install.

Credentials

Requested credentials (FIVETRAN_API_KEY, FIVETRAN_API_SECRET) are proportional to the purpose. The script also reads the WORKSPACE env var (optional) to locate a .env file — WORKSPACE is not declared as a required env var in SKILL.md, so callers should be aware of this optional path-based credential lookup.

Persistence & Privilege

The skill is not always-enabled, does not request system-wide configuration changes, and does not persist or modify other skills' settings. It runs on demand as a CLI tool.

Assessment

This skill is internally consistent for managing Fivetran via its API. Before installing: (1) Verify you trust the author/homepage (the skill is authored by agxntsix.ai, not an official Fivetran repo). (2) Use a least-privilege Fivetran API key/secret (scoped or test account) so misuse is limited. (3) Be aware the script will fallback to reading a .env file at $WORKSPACE/.env or ~/.openclaw/workspace/.env if env vars are missing — avoid storing unrelated secrets there. (4) Review the included scripts/fivetran.py source yourself (it is small and uses only stdlib) and consider running it in an isolated environment first. (5) Rotate or revoke the API credentials if you stop using the skill or if you suspect misuse.

Fivetran — manage connectors, destinations, sync status, and groups via REST API

Requirements

Variable	Required	Description
FIVETRAN_API_KEY	✅	API key
FIVETRAN_API_SECRET	✅	API secret

Quick Start

# List connectors
python3 {{baseDir}}/scripts/fivetran.py connectors group_id <value>

# Get connector
python3 {{baseDir}}/scripts/fivetran.py connector-get id <value>

# Create connector
python3 {{baseDir}}/scripts/fivetran.py connector-create --service <value> --group_id <value> --config <value>

# Update connector
python3 {{baseDir}}/scripts/fivetran.py connector-update id <value> --paused <value>

# Delete connector
python3 {{baseDir}}/scripts/fivetran.py connector-delete id <value>

# Trigger sync
python3 {{baseDir}}/scripts/fivetran.py connector-sync id <value>

# Get schema
python3 {{baseDir}}/scripts/fivetran.py connector-schema id <value>

# List destinations
python3 {{baseDir}}/scripts/fivetran.py destinations

All Commands

Command	Description
connectors	List connectors
connector-get	Get connector
connector-create	Create connector
connector-update	Update connector
connector-delete	Delete connector
connector-sync	Trigger sync
connector-schema	Get schema
destinations	List destinations
destination-get	Get destination
groups	List groups
group-get	Get group
group-create	Create group
users	List users
metadata-connectors	List connector types
webhooks	List webhooks

Output Format

All commands output JSON by default. Add --human for readable formatted output.

python3 {{baseDir}}/scripts/fivetran.py <command> --human

Script Reference

Script	Description
{{baseDir}}/scripts/fivetran.py	Main CLI — all commands in one tool

Credits

Built by M. Abidi | agxntsix.ai YouTube | GitHub Part of the AgxntSix Skill Suite for OpenClaw agents.

📅 Need help setting up OpenClaw for your business? Book a free consultation