Grades are a hygiene check, not a security guarantee.

MCP, MCP server

deepsql

The database agent for Postgres and MySQL. Point it at PostgreSQL or MySQL and ask questions in plain English — schema exploration, query generation, slow query analysis, index recommendations, generated dashboards.

Compatibility: Not stated.

Grade D

Two or more Medium findings, or a High finding. Only try it in a sandbox.

Graded by PlugVetRubric v2

Not a guarantee. A hygiene check of the source at the commit shown, not a security audit.

Rescanned at commit 27d07eabb817, unchanged since the check below.

INSTALL_REMOTE_SCRIPT OBFUSCATION_ENCODED_BLOB

Why this grade

  • INSTALL_REMOTE_SCRIPT High

    Fetches a script from the network and runs it (a pipe to a shell, or an install hook with a URL).

    AGENTS.md, line 264 `curl -fsSL https://hermes-agent.nousresearch.com/install.sh | bash -s -- --non-interactive --skip-setup`,

  • OBFUSCATION_ENCODED_BLOB Medium

    Contains a long base64 shaped string in a file that should be readable.

    package-lock.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.

If you think this grade is wrong, email [email protected] with the entry link and your evidence. We aim to acknowledge within two working days and decide within seven. If we confirm an error, we aim to correct it within 24 hours of confirming it. These are aims, not guarantees.

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

    Note

    requests shell access. The manifest names this permission.

    PERMISSION_SHELL_DECLARED

    scripts/local-agent-provisioner.py, line 112

    subprocess.run(cmd, check=True, env={**os.environ, "PATH": f"{Path.home()}/.local/bin:{os.environ.get('PATH','')}"})

    scripts/self-host/seed-review-suggestions.py, line 72

    out = subprocess.run(

    scripts/self-host/vaultdb.py, line 24

    out = subprocess.run(

    Show more

    scripts/self-host/vaultdb.py, line 35

    probe = subprocess.run(_host_psql(["-At", "-c", "SELECT 1"]),

    scripts/self-host/vaultdb.py, line 50

    return subprocess.check_output(_command(["-At", "-c", sql]), text=True).strip()

    scripts/self-host/vaultdb.py, line 55

    subprocess.check_call(_command(["-v", "ON_ERROR_STOP=1", "-c", sql]))

  • Install and update

    Serious

    install fetches a script from the network. README documents an installer that pipes a download into a shell. The docs document an installer that pipes a download into a shell.

    INSTALL_REMOTE_SCRIPT INSTALL_DOCUMENTED_INSTALLER

    AGENTS.md, line 264

    `curl -fsSL https://hermes-agent.nousresearch.com/install.sh | bash -s -- --non-interactive --skip-setup`,

    README.md, line 29

    curl -fsSL https://deepsql.ai/install.sh | bash

    agent/Dockerfile, line 29

    RUN curl -fsSL https://deb.nodesource.com/setup_20.x | bash - \

    Show more

    agent/Dockerfile, line 35

    RUN curl -fsSL https://astral.sh/uv/install.sh | sh \

    scripts/self-host/bootstrap-server.sh, line 99

    curl -fsSL https://get.docker.com | sh

    scripts/self-host/remote-install.sh, line 7

    # curl -fsSL https://deepsql.ai/install.sh | bash

    scripts/self-host/remote-install.sh, line 10

    # curl -fsSL https://raw.githubusercontent.com/DeepSQLAI/deepsql/main/scripts/self-host/remote-install.sh | bash

    scripts/self-host/remote-install.sh, line 118

    echo " ${BOLD}curl -fsSL https://raw.githubusercontent.com/${DEEPSQL_REPO}/main/scripts/self-host/bootstrap-server.sh | sudo bash${NC}"

    scripts/self-host/remote-install.sh, line 121

    echo " curl -fsSL https://get.docker.com | sh"

    scripts/self-host/remote-install.sh, line 124

    echo " curl -fsSL https://deepsql.ai/install.sh | bash"

    scripts/self-host/remote-install.sh, line 172

    echo " curl -fsSL https://raw.githubusercontent.com/${DEEPSQL_REPO}/main/scripts/self-host/bootstrap-server.sh | sudo bash"

    scripts/self-host/remote-install.sh, line 394

    curl -fsSL https://deepsql.ai/install.sh | bash

    scripts/self-host/remote-install.sh, line 397

    curl -fsSL https://deepsql.ai/install.sh | bash -s -- --yes

    scripts/self-host/remote-install.sh, line 400

    curl -fsSL https://deepsql.ai/install.sh | bash -s -- --branch v1.3.0

    scripts/self-host/remote-install.sh, line 403

    curl -fsSL https://raw.githubusercontent.com/DeepSQLAI/deepsql/main/scripts/self-host/remote-install.sh | bash

  • Network

    Concern

    can reach a host that is not written as a fixed address. can reach api.github.com. The description does not name that host.

    NETWORK_NO_FIXED_HOST NETWORK_UNNAMED_HOST

    CLAUDE.md, line 55

    curl -X POST http://localhost:8080/api/users/admin/bootstrap \

    agent/skills/dashboard-design/SKILL.md, line 52

    - Inline everything - one `<style>` in the shell, one `<script>` per widget block. **No external URLs, CDNs, fonts, or images** (blocked by CSP) and **no `fetch()`/XHR/WebSocket**

    backend/src/main/java/com/dbaagent/service/DashboardAgentService.java, line 250

    Do NOT hardcode result data, do NOT use fetch()/XHR/WebSockets or any external URL/CDN (all blocked) -

    Show more

    backend/src/main/java/com/dbaagent/service/pipeline/ColumnValueFetcher.java, line 38

    public ColumnValueContext fetch(String connectionId, String dbType, List<FilterColumn> filterColumns) {

    backend/src/main/java/com/dbaagent/service/pipeline/QueryGenerationPipeline.java, line 165

    var columnValues = columnValueFetcher.fetch(ctx.connectionId(), ctx.dbType(), resolved.filterColumns());

    backend/src/main/java/com/dbaagent/service/pipeline/QueryGenerationPipeline.java, line 215

    columnValues = columnValueFetcher.fetch(ctx.connectionId(), ctx.dbType(), resolved.filterColumns());

    docs/API_CLIENT_USAGE.md, line 25

    const response = await fetch('http://localhost:8080/api/playbooks')

    docs/API_CLIENT_USAGE.md, line 196

    const res = await fetch(`http://localhost:8080/api/advisor/analyze/${connectionId}`)

    docs/API_CLIENT_USAGE.md, line 221

    const response = await fetch('http://localhost:8080/api/playbooks', {

    docs/API_CLIENT_USAGE.md, line 264

    - [ ] Replace `fetch()` calls with API methods

    docs/root/IMPLEMENTATION_GUIDE.md, line 195

    const response = await fetch(`/api/brain/key-columns/analyze/${connectionId}`, {

    mcp/deepsql-phase1-lib.js, line 1373

    return await fetch(url, {

  • Secrets

    Concern

    reads a credential or environment file.

    SECRETS_PATH_DOTENV

    agent/install.sh, line 13

    # Secrets are read from the environment (or the repo .env), never committed:

    agent/install.sh, line 39

    # Load repo .env for LLM creds if not already in the environment.

    agent/install.sh, line 40

    if [[ -f "$REPO_ROOT/.env" ]]; then set -a; . "$REPO_ROOT/.env"; set +a; fi

    Show more

    agent/install.sh, line 49

    echo "Error: set DEEPSQL_CHAT_API_KEY (or AZURE_OPENAI_KEY) in the environment or $REPO_ROOT/.env" >&2

    .dockerignore, line 11

    *.log

    .dockerignore, line 12

    .env

    .dockerignore, line 14

    !.env.example

    .env.example, line 2

    # Copy this file to .env and fill in the required values.

  • Agent instructions

    Pass

    No instruction to ignore earlier instructions or to hide a step.

  • Obfuscation

    Concern

    contains an encoded blob in a file that should be readable.

    OBFUSCATION_ENCODED_BLOB

    package-lock.json, line 1

    {

    backend/src/main/java/com/dbaagent/model/brain/BrainTaskRequest.java, line 1

    package com.dbaagent.model.brain;

    src/components/DBConfigModal.js, line 10

    postgres: 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUwAAACMCAYAAAAX8ZBfAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA2tpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCB

    Show more

    src/components/DBConfigModal.js, line 11

    mysql: 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUwAAACMCAYAAAAX8ZBfAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA2tpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZW

    src/components/DBConfigModal.js, line 12

    mongodb: 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAGAAAABgCAYAAADimHc4AAAACXBIWXMAAAsTAAALEwEAmpwYAAAGYElEQVR4nO2dXYgcRRCAOxEfVPx78Rf8icYfUF/ubqr2EhEV0SAaXyIYow/m2O69EDXqgyJ4

    src/components/DBConfigModal.js, line 13

    redis: 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAADl0lEQVR4nM1VS2hUZxS+2OLCumgFF6Kgi/yv89+XBszCQtoqKi4UfIALodBFly4triwoFgR17i

    src/components/DBConfigModal.js, line 14

    mariadb: 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUwAAACMCAYAAAAX8ZBfAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA2tpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBi

    src/components/DBConfigModal.js, line 15

    oracle: 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAUwAAACMCAYAAAAX8ZBfAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA2tpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZ

    src/components/dashboardTheme.js, line 6

    @font-face{font-family:'Maven Pro';font-style:normal;font-weight:100 900;font-display:swap;src:url(data:font/woff2;base64,d09GMgABAAAAAE6sABQAAAAAloQAAE49AAEAAAAAAAAAAAAAAAAAAAAAAA

  • Licence

    Pass

    A licence file is present (LICENSE).

  • Maintainer activity

    Pass

    The latest commit is within the last 365 days.

Get the full report on this tool, £49

Note

Hygiene check of commit 27d07eabb817. requests shell access. The manifest names this permission. install fetches a script from the network. README documents an installer that pipes a download into a shell. The docs document an installer that pipes a download into a shell. can reach a host that is not written as a fixed address. can reach api.github.com. The description does not name that host. reads a credential or environment file. contains an encoded blob in a file that should be readable.

Date and source

Date checked:

View source

github.com

Commit graded: 27d07eabb817992d448de001890f2286e9b30acd

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.

Read how this letter is chosen