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.
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:
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.