Grades are a hygiene check, not a security guarantee.

MCP, MCP server

CensusChat

Ask US Census demographics a question in plain English.

Compatibility: Not stated.

Grade B

Minor issues only, no Medium or High. Worth a quick look at the findings below before installing.

Graded by PlugVetRubric v2

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

PERMISSION_DELETE_FILES NETWORK_NO_FIXED_HOST SECRETS_PATH_DOTENV SECRETS_ENV_READ OBFUSCATION_FILE_OVER_READ_CAP OBFUSCATION_FILE_CAP_REACHED

Why this grade

  • PERMISSION_DELETE_FILES Low

    Contains a call that can delete files.

    backend/scripts/load-acs-blockgroup-expanded.ts, line 595 fs.unlinkSync(PROGRESS_FILE);

  • NETWORK_NO_FIXED_HOST Low

    Makes a network call whose host is not written as a fixed address.

    demo-setup.sh, line 209 if curl -f http://localhost:3001/api/v1/health &> /dev/null; then

  • SECRETS_PATH_DOTENV Low

    Mentions a .env file.

    demo-setup.sh, line 8 # 2. Create .env file if needed

  • SECRETS_ENV_READ Note

    Reads an environment variable whose name contains KEY, SECRET, TOKEN, PASSWORD or CREDENTIAL.

    demo-setup.sh, line 112 sed -i '' "s|JWT_SECRET=.*|JWT_SECRET=$JWT_SECRET|g" .env

  • OBFUSCATION_FILE_OVER_READ_CAP Note

    A file was over the read cap and was not fully read.

    backend/package-lock.json, line 1 {

  • OBFUSCATION_FILE_CAP_REACHED Note

    The 400 file cap was reached before every file was read.

    backend/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.

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

    backend/scripts/load-acs-blockgroup-expanded.ts, line 595

    fs.unlinkSync(PROGRESS_FILE);

    backend/scripts/load-acs-blockgroup.ts, line 548

    fs.unlinkSync(PROGRESS_FILE);

    backend/scripts/load-acs-tract.ts, line 461

    fs.unlinkSync(PROGRESS_FILE);

    Show more

    backend/scripts/migrate-encrypted.ts, line 136

    fs.unlinkSync(destPath);

    backend/src/services/excelExportService.ts, line 506

    fs.unlinkSync(filePath);

    backend/src/utils/duckdbProfiler.ts, line 61

    await fs.unlink(profilePath); // Cleanup

  • 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

    demo-setup.sh, line 209

    if curl -f http://localhost:3001/api/v1/health &> /dev/null; then

    demo-setup.sh, line 221

    if curl -f http://localhost:3000 &> /dev/null; then

    demo-setup.sh, line 269

    HEALTH_CHECK=$(curl -s http://localhost:3001/api/v1/health)

    Show more

    demo-setup.sh, line 277

    if curl -f -s http://localhost:3000 > /dev/null; then

    archive/setup-scripts/start-mvp.sh, line 81

    if curl -f http://localhost:3001/health > /dev/null 2>&1; then

    archive/setup-scripts/start-mvp.sh, line 93

    if curl -f http://localhost:3000 > /dev/null 2>&1; then

    backend/scripts/load-acs-blockgroup-expanded.ts, line 169

    const response1 = await axios.get(url1, { timeout: 60000 });

    backend/scripts/load-acs-blockgroup-expanded.ts, line 176

    const response2 = await axios.get(url2, { timeout: 60000 });

    backend/scripts/load-acs-blockgroup.ts, line 199

    const response = await axios.get(url, { timeout: 30000 });

    backend/scripts/load-acs-data.ts, line 103

    const response = await axios.get(url, { timeout: 10000 });

    backend/scripts/load-acs-state.ts, line 128

    const response1 = await axios.get(url1, { timeout: 60000 });

    backend/scripts/load-acs-state.ts, line 134

    const response2 = await axios.get(url2, { timeout: 60000 });

    backend/scripts/load-acs-tract.ts, line 148

    const response1 = await axios.get(url1, { timeout: 60000 });

    backend/scripts/load-acs-tract.ts, line 154

    const response2 = await axios.get(url2, { timeout: 60000 });

  • Secrets

    Concern

    reads a credential or environment file.

    SECRETS_ENV_READ SECRETS_PATH_DOTENV

    demo-setup.sh, line 8

    # 2. Create .env file if needed

    demo-setup.sh, line 91

    # Create .env file from .env.example if it doesn't exist

    demo-setup.sh, line 112

    sed -i '' "s|JWT_SECRET=.*|JWT_SECRET=$JWT_SECRET|g" .env

    Show more

    demo-setup.sh, line 95

    if [ -f .env ]; then

    demo-setup.sh, line 96

    print_warning ".env file already exists. Skipping creation."

    demo-setup.sh, line 100

    if [ ! -f .env.example ]; then

    demo-setup.sh, line 101

    print_error ".env.example not found. Cannot create .env file."

    demo-setup.sh, line 105

    cp .env.example .env

    backend/scripts/load-acs-blockgroup-expanded.ts, line 22

    const CENSUS_API_KEY = process.env.CENSUS_API_KEY;

    backend/scripts/load-acs-blockgroup.ts, line 19

    const CENSUS_API_KEY = process.env.CENSUS_API_KEY;

    backend/scripts/load-acs-data.ts, line 20

    const CENSUS_API_KEY = process.env.CENSUS_API_KEY;

    backend/scripts/load-acs-state.ts, line 22

    const CENSUS_API_KEY = process.env.CENSUS_API_KEY;

    backend/scripts/load-acs-tract.ts, line 23

    const CENSUS_API_KEY = process.env.CENSUS_API_KEY;

    backend/scripts/migrate-encrypted.ts, line 167

    const encryptionKey = process.env.DUCKDB_ENCRYPTION_KEY;

    backend/src/config/index.ts, line 107

    password: process.env.REDIS_PASSWORD,

    backend/src/config/index.ts, line 126

    apiKey: process.env.CENSUS_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. the file cap was reached before every file was read.

    OBFUSCATION_FILE_OVER_READ_CAP OBFUSCATION_FILE_CAP_REACHED

    backend/package-lock.json, line 1

    {

    backend/src/mcp/mcpApps/bar-chart.html, line 1

    <!DOCTYPE html>

    backend/src/mcp/mcpApps/data-table.html, line 1

    <!DOCTYPE html>

    Show more

    backend/src/mcp/mcpApps/line-chart.html, line 1

    <!DOCTYPE html>

    frontend/package-lock.json, line 1

    {

    frontend/src/data/counties.json, line 1

    {"counties":[{"fips":"01001","stateFips":"01","countyFips":"001","name":"Autauga County","stateName":"Alabama","slug":"autauga-county","stateSlug":"alabama","metrics":{"population"

    test-data/wiremock/mappings/admin-endpoints.json, line 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 f094e015cd56. can delete files. 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. the file cap was reached before every file was read.

Date and source

Date checked:

View source

github.com

Commit graded: f094e015cd563b5e1ed62afc69422dbe2360a785

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