MCP, MCP server
schemagate
Your text-to-SQL agent picks which tables to show the model before anyone checks what the caller is allowed to read.
Compatibility: Not stated.
Grade B
Minor issues only, no Medium or High. Worth a quick look at the findings below before installing.
Not a guarantee. A hygiene check of the source at the commit shown, not a security audit.
PERMISSION_DELETE_FILES NETWORK_NO_FIXED_HOST NETWORK_UNNAMED_HOST SECRETS_ENV_READ OBFUSCATION_FILE_OVER_READ_CAP
Why this grade
- PERMISSION_DELETE_FILES Low
Contains a call that can delete files.
examples/oracle_local.py, line 34
return subprocess.run(args, capture_output=True, text=True, **kw) - NETWORK_NO_FIXED_HOST Low
Makes a network call whose host is not written as a fixed address.
oci/stack/verify-release.sh, line 16
VERSION="${VERSION:-$(curl -fsSL https://raw.githubusercontent.com/ - NETWORK_UNNAMED_HOST Low
Calls a fixed host that the description does not name.
oci/stack/verify-release.sh, line 16
VERSION="${VERSION:-$(curl -fsSL https://raw.githubusercontent.com/ - SECRETS_ENV_READ Note
Reads an environment variable whose name contains KEY, SECRET, TOKEN, PASSWORD or CREDENTIAL.
benchmarks/complex_sql_1200.py, line 95
if not os.environ.get("ANTHROPIC_API_KEY"): - OBFUSCATION_FILE_OVER_READ_CAP Note
A file was over the read cap and was not fully read.
benchmarks/results/bird_dev/predict_dev.json, line 1
{
Any High, or two or more Medium findings, give D. One Medium gives C. Low findings or a security Note give B. Each code names a finding behind the letter.
Grades are a hygiene check of the source at the commit shown, on the date checked, not a security audit or a guarantee. The free directory grades are automated. Before release, a PlugVet engineer reviews every paid report and any grade we hold back, including all F grades, against the source code and the evidence we quote.
What was checked
Plain notes from the hygiene checks.
Permissions
Concern
can delete files.
PERMISSION_DELETE_FILES
examples/oracle_local.py, line 34
return subprocess.run(args, capture_output=True, text=True, **kw)
scripts/build_site.py, line 411
out = subprocess.run(["git", "log", "-1", "--format=%cs", "--", rel],
scripts/build_site.py, line 422
out = subprocess.run(["git", *args], cwd=ROOT, capture_output=True, text=True, timeout=30)
Show more
scripts/build_site.py, line 456
rc = subprocess.run(["git", "merge-base", "--is-ancestor", newest, since],
scripts/build_site.py, line 517
shutil.rmtree(SITE)
scripts/lock_ci.py, line 77
subprocess.run(cmd, check=True, cwd=ROOT)
studio/build.py, line 16
subprocess.run([sys.executable, str(HERE / "export_schemas.py")], check=True)
Install and update
Pass
No install-time script found, and dependencies are pinned or absent.
Network
Concern
can reach ifconfig.me. The description does not name that host. can reach a host that is not written as a fixed address.
NETWORK_NO_FIXED_HOST NETWORK_UNNAMED_HOST
oci/stack/verify-release.sh, line 16
VERSION="${VERSION:-$(curl -fsSL https://raw.githubusercontent.com/
oci/stack/verify-release.sh, line 38
curl -fsSL https://github.com/ashishsinha1602/schemagate/releases/latest/download/schemagate-oci-stack.zip \
oci/stack/verify-release.sh, line 46
curl -fsSL https://raw.githubusercontent.com/ashishsinha1602/schemagate/main/oci/stack/verify.sh \
Show more
oci/stack/verify.sh, line 104
MYIP="$(curl -fsS --max-time 20 https://ifconfig.me)"
oci/stack/verify.sh, line 124
curl -fsSL "$ZIP_URL" -o "$WORK/stack.zip" || die "could not download $ZIP_URL"
oci/stack/verify.sh, line 194
code="$(curl -sS --max-time 8 -o /dev/null -w '%{http_code}' "http://$IP:8765/mcp" 2>/dev/null)"
src/schemagate/groups.py, line 219
with urllib.request.urlopen(req, timeout=timeout) as resp:
src/schemagate/oauth.py, line 123
with urllib.request.urlopen(base + path, timeout=timeout) as r: # noqa: S310 (https only, checked)
src/schemagate/ords.py, line 100
with urllib.request.urlopen(req, timeout=timeout) as r:
.github/workflows/slsa.yml, line 66
meta = json.load(urllib.request.urlopen(f"https://pypi.org/pypi/schemagate/{v}/json"))
.github/workflows/slsa.yml, line 73
data = urllib.request.urlopen(f["url"]).read()
src/schemagate/studio.html, line 1795
const res = await fetch(API+"/select",{method:"POST",headers:{"Content-Type":"application/json"},body:JSON.stringify({question,principal,roles:[...roles],top_k:topK,ai:state.ai})})
Secrets
Note
reads an environment variable.
SECRETS_ENV_READ
benchmarks/complex_sql_1200.py, line 95
if not os.environ.get("ANTHROPIC_API_KEY"):
benchmarks/fixture_1200.py, line 606
wallet_password=os.environ.get("WALLET_PASSWORD"))
benchmarks/fixture_1200.py, line 644
pw = os.environ.get("SGBENCH_PASSWORD")
Show more
benchmarks/fixture_1200.py, line 714
wallet_password=os.environ.get("WALLET_PASSWORD")))
benchmarks/rerank_eval.py, line 188
if not os.environ.get("ANTHROPIC_API_KEY"):
src/schemagate/studio.py, line 277
model=model, api_key=key or os.environ.get("HF_TOKEN", ""),
studio/build_answers.py, line 93
if not os.environ.get("ANTHROPIC_API_KEY"):
Agent instructions
Pass
No instruction to ignore earlier instructions or to hide a step.
Obfuscation
Note
a file was over the read cap and was not fully read.
OBFUSCATION_FILE_OVER_READ_CAP
benchmarks/results/bird_dev/predict_dev.json, line 1
{
benchmarks/results/uniql_oracle/gemini-2.5-flash_oracle.json, line 1
[
benchmarks/results/uniql_oracle/gemini-2.5-flash_oracle_rules.json, line 1
[
Show more
src/schemagate/studio.html, line 1
<title>schemagate studio</title>
studio/studio.html, line 1
<title>schemagate studio</title>
Licence
Pass
A licence file is present (LICENSE).
Maintainer activity
Pass
The latest commit is within the last 365 days.
Note
Hygiene check of commit 1205e3f0e31e. can delete files. can reach ifconfig.me. The description does not name that host. can reach a host that is not written as a fixed address. reads an environment variable. a file was over the read cap and was not fully read.
Date and source
Date checked:
github.com
Commit graded: 1205e3f0e31e2ea6ca20b174b34c45c92e1d2baa
This link goes to the original host. PlugVet does not host or check what you download from there, and installing it is your own decision and risk.