MCP, MCP server
PlainQuery | MCP DB Agent
Ask your database questions in plain English. PlainQuery connects PostgreSQL databases to Claude, Cursor, or VS Code — and answers with real, structured data instead of guesses.
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.
Rescanned at commit 90db627edb1c, unchanged since the check below.
NETWORK_NO_FIXED_HOST SECRETS_PATH_DOTENV OBFUSCATION_FILE_OVER_READ_CAP
Why this grade
- NETWORK_NO_FIXED_HOST Low
Makes a network call whose host is not written as a fixed address.
AGENTS.md, line 152
curl -X POST http://localhost:8000/api/v1/users/register \ - SECRETS_PATH_DOTENV Low
Mentions a .env file.
AGENTS.md, line 30
# Run integration tests (needs API keys in .env and a seeded demo.db) - OBFUSCATION_FILE_OVER_READ_CAP Note
A file was over the read cap and was not fully read.
uv.lock, line 1
version = 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
Pass
No shell or command execution found, and no extra permission was declared.
Install and update
Pass
No install-time script found, and dependencies are pinned or absent.
Network
Concern
can reach a host that is not written as a fixed address.
NETWORK_NO_FIXED_HOST
AGENTS.md, line 152
curl -X POST http://localhost:8000/api/v1/users/register \
CLAUDE.md, line 198
curl -X POST http://localhost:8000/api/v1/users/register \
frontend/src/app/(protected)/layout.tsx, line 43
await fetch(`${backendUrl}/api/v1/auth/logout`, {
Show more
frontend/src/app/auth/login/complete/route.ts, line 24
const res = await fetch(
frontend/src/app/auth/login/complete/route.ts, line 37
const statusRes = await fetch(`${backendUrl}/api/v1/account/status`, {
frontend/src/app/auth/signout/route.ts, line 10
await fetch(`${backendUrl}/api/v1/auth/logout`, {
frontend/src/app/auth/verify/complete/route.ts, line 23
const res = await fetch(
frontend/src/lib/api/backend.ts, line 18
return fetch(`${BACKEND_URL}/api${path}`, {
frontend/src/lib/api/backend.ts, line 33
return fetch(`${BACKEND_URL}/api${path}`, {
scripts/smoke_oauth_mcp.py, line 156
resp = httpx.post(f"{ISSUER}/oauth/token", data=token_payload, timeout=15)
Dockerfile, line 31
sys.exit(0 if urllib.request.urlopen('http://127.0.0.1:8000/api/health/ready', timeout=3).status==200 else 1)"
Secrets
Concern
reads a credential or environment file.
SECRETS_PATH_DOTENV
AGENTS.md, line 30
# Run integration tests (needs API keys in .env and a seeded demo.db)
CLAUDE.md, line 30
# Run integration tests (needs API keys in .env and a seeded demo.db)
alembic/env.py, line 9
# Load .env so AUTH_DATABASE_URL is available when running alembic from the CLI
Show more
alembic/env.py, line 13
load_dotenv(Path(__file__).parent.parent / ".env")
scripts/reset_auth_db.py, line 3
Reads ``AUTH_DATABASE_URL`` from your ``.env`` (via src.config.settings) and
scripts/smoke_mcp_deployment.py, line 40
_DEFAULT_ENV_FILE = Path(__file__).parent.parent / ".env"
scripts/smoke_oauth_mcp.py, line 9
2. Make sure your .env has OAUTH_ISSUER_URL, OAUTH_AUDIENCE, OAUTH_CLIENT_ID set.
scripts/smoke_oauth_mcp.py, line 28
# Load settings from .env
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
frontend/pnpm-lock.yaml, line 1
lockfileVersion: '9.0'
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 90db627edb1c. 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: 90db627edb1c43248f596d450fd051ed33549de6
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.