teradata-etl-mcp-server@1.0.2
CAUTION· not startedPublisher claims: "Unified MCP server for ELT operations with Teradata, TTU, Airbyte, Airflow, and dbt" Observed in sandbox: no network, touches nothing outside the project, writes no memory.
Coverage
Not started: dependency install failed; the server itself was not observed.- Tested
- the dependency install step · every file read, file written and host contacted by what ran
- Not tested
- server startup · the tool list · tool behavior
What this means for the label: Caution here covers what ran. The server's tools were not exercised with a real credential, so nothing about their behavior is asserted; the credential summary below says what to do with that.
Before you give it your token
- It will ask for
MCP_CLIENT_SSH_PASSWORDConfiguration, not credentials: CONNECTIONS_FILE, ENV_FILE, MCP_CLIENT_SSH_HOST, MCP_CLIENT_SSH_KEY_PATH, MCP_CLIENT_SSH_PORT, MCP_CLIENT_SSH_USER, MCP_LOG_LEVEL, TWB_ROOT- Where it talks to
- no vendor host named in the codeAlso airbyte.com — not the publisher's domain; check what for before connecting.
- What we saw when it ran
- no credential files read · no network
- What we could not test
- server startup · the tool list · tool behavior
Connect it with a scoped credential, under the guard, and read the third-party hosts first. The code names airbyte.com as well as its own vendor. The guard injects MCP_CLIENT_SSH_PASSWORD only into requests to the host you bind (and its subdomains) and refuses the rest.
Never paste a credential into a chat, a ticket or a report, including ours. How the guard holds it.
Is [email protected] safe to install?
KillerSkills ran it in the KillerSkills honeypot sandbox (2 scenarios; not started: dependency install failed; the server itself was not observed) on 2026-11-19 and scored it 70/100 (Caution). It is not known to be malicious, but it has behaviour or code a security policy should decide on before install. Notable findings: Access to sensitive file paths; Access to sensitive file paths; Access to sensitive file paths. Summary: no network, touches nothing outside the project, writes no memory.
Behavior trace
Honeypot run · 1 s · 2 scenarios · 0 deviationsStatic findings
logger.warning("Failed to create .env: %s", e)Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.out-of-band updates to ``.env`` (e.g. a rerun of the setup wizard for aFix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.``.env`` file, ``TERADATA_*`` vars are loaded from that file. ThisFix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose." <workspace>/dbt_project/dbt_<slug>/.env — server-written, per-sub-project "Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."Verify TTU_TTU_VERSION matches your installation or set TTU_TPT_BINARY_PATH in .env."Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.``Settings()``); only then will out-of-band ``.env`` updates beFix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."to overwrite the per-sub-project ``.env`` (server-side write).\n"Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.``cwd=<project_dir>`` so ``dotenv`` finds ``.env`` automatically.Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.``dotenv run -- dbt ...`` against the per-sub-project ``.env``. TheFix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.auth=None, dotenv_path=Path(self.project_dir) / ".env"Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."4. Do NOT create connections.yaml or .env yourself, and do NOT use "Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose." The MCP SERVER writes the per-sub-project ``.env`` at scaffold time and on "Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.This parameter must not be used to pass credentials or otherFix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."The agent must NOT create connections.yaml or .env, must NOT use "Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.# to ensure dotenv finds .env. Use remote_dir (the path on theFix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.Credentials flow exclusively via the per-sub-project ``.env`` file:Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."Set TTU_TTU_VERSION or explicit binary paths in .env.",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."attacks. Add the remote host to ~/.ssh/known_hosts and pass "Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.would fail anyway — the ``.env`` was scaffolded alongside theFix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose." 1. Pass the .env file explicitly:",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose." <workspace>/.env — wizard-managed user creds\n"Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.# per-project .env file or Airflow Connections/Variables instead.Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.env=self._compute_env(auth, dotenv_path=Path(self.project_dir) / ".env"),Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.# would fail to find creds via the per-sub-project ``.env``Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.dotenv_path = self.project_dir / ".env"Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.".env or the profile's 'oidc_clientid' field."Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.lines.append(f" .env file not found at: {env_path.resolve()}")Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.# Write .env next to profiles.yml so `dotenv run -- dbt ...`Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."Verify TTU_TTU_VERSION matches your installation or set TTU_TDLOAD_BINARY_PATH in .env."Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."Wrote .env with %d TERADATA_* keys at %s",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.# user leaves a default-database field blank in the wizard or .env.Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.Wizard or .env file. Just use ttu_execute or teradata_discoverFix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."TERADATA_USERNAME in the wizard/.env or the profile's "Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."``echo TERADATA_DATABASE=... >> .env``):\n"Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.does NOT reload settings from ``.env`` or other external sourcesFix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."inline export; use .env file or Airflow "Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.env_file=".env",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.After the wizard rewrites ``.env`` the user must click "ReloadFix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."Verify TTU_TTU_VERSION matches your installation or set TTU_BTEQ_BINARY_PATH in .env."Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.env_path = env_file or Path(".env")Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.# Create .gitignore if it doesn't exist. ``.env`` is includedFix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose." 2. Or place a .env file in the working directory the server is launched from.",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.Post-``.env``-migration, the dbt task in a generated Airflow DAG runsFix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose." teradata-etl-mcp-server --env-file /absolute/path/to/.env",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."\x00\x1a\ufffd\ufa6c\ufa6f\ufad0\ufad1\ufad5\ufad6\ufad7"Fix: Put hosts, commands and strings in plain source. Decoding at runtime looks identical to malware and costs points on its own.- "refresh_env" : Overwrite the existing sub-project's ``.env`` file with currentFix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.target_database: Target Teradata database (uses TERADATA_DATABASE from .env if None)Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.or from .env settings. The LLM never handles passwords.Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."error": "Workspace ID not found in settings. Please set AIRBYTE_WORKSPACE_ID in your .env file.",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."or edit the ``.env`` file — credentials are user-managed. Ask "Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."Auto-updated existing connection %s to manual "Fix: Pin versions and sources; vendor anything fetched at install time.# auto-update the existing connection to manual instead of returningFix: Pin versions and sources; vendor anything fetched at install time.credentials. Falls back to .env TERADATA_* settings.Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.proc = subprocess.Popen( # noqa: S603Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.credentials. Falls back to .env TERADATA_* settings when not provided.Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."the wizard (or .env), or pass a named teradata_profile."Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose."If the above steps fail, contact a DBA to kill the blocking session.",Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell."the wizard (or .env), or pass a named teradata_profile "Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.subprocess.run( # noqa: S603, S607Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.result = subprocess.run(Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out._TD_DISALLOWED_CHARS = re.compile("[\u0000\u001a\ufffd\ufa6c\ufa6f\ufad0\ufad1\ufad5\ufad6\ufad7]")Fix: Put hosts, commands and strings in plain source. Decoding at runtime looks identical to malware and costs points on its own."[\u0000\u001a\ufffd\ufa6c\ufa6f\ufad0\ufad1\ufad5\ufad6\ufad7]"Fix: Put hosts, commands and strings in plain source. Decoding at runtime looks identical to malware and costs points on its own.Connection; the dbt task runs against the sub-project's ``.env``.Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.have a cron schedule, auto-updates them to manual. The cronFix: Pin versions and sources; vendor anything fetched at install time.Direct file reads bypass credential masking, return unstructured data,Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.result = subprocess.run(Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out."[\u0000\u001a\ufffd\ufa6c\ufa6f\ufad0\ufad1\ufad5\ufad6\ufad7]"Fix: Put hosts, commands and strings in plain source. Decoding at runtime looks identical to malware and costs points on its own.# chmod failure is non-fatal since file is already written successfully.Fix: Request the narrowest permission that works; replace wildcards with the exact paths or hosts.traversal string like ``'../../etc/passwd'`` and let glob/readFix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.result = subprocess.run(Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out."the wizard (or .env), or pass a named teradata_profile "Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.credentials. Falls back to .env TERADATA_* settings when not provided.Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.restrict_permissions: If False, skip POSIX ``chmod 0o640`` afterFix: Request the narrowest permission that works; replace wildcards with the exact paths or hosts.Cost to the agent
Tokens estimated at four characters each. The tool list is re-read by the agent on every turn, so it is the number to compare between servers that do the same job: ranked across the index.
Known vulnerabilities
No advisories in OSV for teradata-etl-mcp-server@1.0.2 as of 10 h ago. This is the package itself, not its dependencies.
What would make this Verified
10 points to 80 · weights: behavior 45%, static 25%, prompt 15%, publisher 15%- Unclaimed publisher≈ +8 on the totalClaim teradata: a verified publisher gets +50 on publisher trust. It is free and usually instant with GitHub sign-in.
- Access to sensitive file paths≈ +4 on the totalStop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
- Credential pass-through configuration≈ +4 on the totalStop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
- Auto-update or dynamic fetch configuration≈ +4 on the totalPin versions and sources; vendor anything fetched at install time.
- Unicode escape sequence detected≈ +2 on the totalPut hosts, commands and strings in plain source. Decoding at runtime looks identical to malware and costs points on its own.
- Python subprocess execution detected≈ +2 on the totalBuild commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.