MCP, MCP server
pgops
pgops, an MCP server listed in the PlugVet directory.
Compatibility: Not stated.
Grade C
One Medium finding. Read the findings before installing.
Not a guarantee. A hygiene check of the source at the commit shown, not a security audit.
PERMISSION_SHELL_UNDECLARED
Why this grade
- PERMISSION_SHELL_UNDECLARED Medium
Runs shell commands that the manifest or description does not mention.
scripts/release_checklist.py, line 31
p = subprocess.run(resolved, cwd=ROOT, capture_output=True, text=True, check=False)
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
requests shell access. No manifest field names shell or command execution.
PERMISSION_SHELL_UNDECLARED
scripts/release_checklist.py, line 31
p = subprocess.run(resolved, cwd=ROOT, capture_output=True, text=True, check=False)
Install and update
Note
The docs document an installer that pipes a download into a shell.
INSTALL_DOCUMENTED_INSTALLER
SETUP.md, line 12
| [uv](https://docs.astral.sh/uv/) | latest | `pip install uv` or `curl -LsSf https://astral.sh/uv/install.sh \| sh` - brings its own Python |
Network
Concern
can reach a host that is not written as a fixed address.
NETWORK_NO_FIXED_HOST
src/pgops/completions.py, line 68
rows = await conn.fetch(_TABLE_QUERY)
src/pgops/function_safety.py, line 125
rows = await conn.fetch(
src/pgops/migrations/ledger.py, line 127
rows = await self._conn.fetch(
Show more
src/pgops/migrations/ledger.py, line 151
rows = await self._conn.fetch(
src/pgops/migrations/ledger.py, line 162
rows = await self._conn.fetch(
src/pgops/tools/advisor.py, line 237
unused = await conn.fetch(_UNUSED_INDEXES_SQL)
src/pgops/tools/advisor.py, line 268
advice.redundant_indexes = _find_redundant(list(await conn.fetch(_INDEX_COLUMNS_SQL)))
src/pgops/tools/advisor.py, line 270
hotspots = await conn.fetch(_TABLE_SCAN_STATS_SQL)
Secrets
Concern
reads a credential or environment file.
SECRETS_PATH_DOTENV
.dockerignore, line 7
keys/
.dockerignore, line 8
.env
.env.example, line 2
# Copy to `.env` and fill in real values. Every variable is optional except PGOPS_DSN.
Show more
.gitignore, line 14
# secrets / local env
README.md, line 203
| [Environment variables](https://github.com/arzharch/pgops-mcp/blob/main/.env.example) | Every knob, documented |
SETUP.md, line 56
cp .env.example .env
SETUP.md, line 57
# then edit .env and set PGOPS_DSN
SETUP.md, line 61
the comments in `.env.example` for what each knob does and when to change it.
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
uv.lock, line 1
version = 1
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 aaadd7e01953. requests shell access. No manifest field names shell or command execution. The docs document an installer that pipes a download into a shell. can reach a host that is not written as a fixed address. reads a credential or environment file. a file was over the read cap and was not fully read.
Date and source
Date checked:
github.com
Commit graded: aaadd7e0195335fa3d0c6a43fe6e871902cd1567
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.