Postgres — the complete, unedited output of the deterministic mcptrustchecker engine v1.13.0, scanned . Every finding, capability tag and score component below is exactly what the engine produced — no AI, no post-processing.
{
"tool": {
"name": "mcptrustchecker",
"version": "1.13.0",
"methodologyVersion": "mcptrustchecker-1.13"
},
"target": {
"id": "@tejasanik/postgres-mcp-server",
"source": {
"kind": "package",
"origin": "@tejasanik/postgres-mcp-server"
},
"server": {
"name": "@tejasanik/postgres-mcp-server"
}
},
"grade": "A",
"score": {
"score": 93,
"threatScore": 100,
"grade": "A",
"band": "A",
"categorySubtotals": {
"injection": 0,
"exfiltration": 0,
"permissions": 0,
"supply-chain": 0,
"network": 0,
"hygiene": 0
},
"vector": [
{
"kind": "client",
"term": "capability-exposure",
"level": "high",
"label": "capability blast radius (high) — client exposure if the model is manipulated",
"appliedPenalty": 6
},
{
"kind": "client",
"term": "verification-discount",
"level": "repo",
"label": "publisher verification (public source) — no provenance, but the source is public and inspectable",
"appliedPenalty": 1
},
{
"kind": "client",
"term": "coverage-honesty",
"level": "source",
"label": "inspection depth (source) — how much of the target the scan could see",
"appliedPenalty": 0
}
],
"gatesFired": [],
"methodologyVersion": "mcptrustchecker-1.13"
},
"capability": {
"level": "high",
"reasons": [
"can send data / act on an external service",
"reads sensitive or local data",
"has a read → egress path (a data-exfiltration surface)"
],
"tags": [
"sensitive-source",
"external-sink"
]
},
"coverage": {
"level": "source",
"inputs": {
"toolSurface": true,
"implementationSource": true,
"packageMetadata": true,
"liveTransport": false
},
"caveats": [
"Tools were statically extracted from the published source (36 recovered), not enumerated from a running server. Tool-poisoning, Unicode-smuggling, capability and toxic-flow analysis ran on this inferred surface, but a mis-parsed registration could be missed or mis-attributed, so tool-derived findings are capped below “confirmed”. To grade the real runtime surface, scan the running server: --command \"npx -y <package>\"."
]
},
"findings": [
{
"ruleId": "MTC-FLOW-004",
"title": "Sensitive-source and external-sink co-exist",
"category": "exfiltration",
"severity": "high",
"confidence": "strong",
"description": "Tools that read sensitive data ([execute_sql, execute_sql_file, preview_sql_file, mutation_preview, mutation_dry_run, dry_run_sql_file, batch_execute, begin_transaction, explain_query, lock_check, safe_alter_table]) and tools that can send data out ([export_to_sql_file]) are exposed together. An agent can move private data to the sink.",
"remediation": "Keep secret-reading and egress capabilities on separate, separately-approved servers.",
"location": {
"kind": "flow",
"name": "execute_sql → export_to_sql_file"
},
"evidence": "sources [execute_sql, execute_sql_file, preview_sql_file, mutation_preview, mutation_dry_run, dry_run_sql_file, batch_execute, begin_transaction, explain_query,",
"owasp": "LLM02:2025 Sensitive Information Disclosure",
"references": [],
"data": {
"sources": [
"execute_sql",
"execute_sql_file",
"preview_sql_file",
"mutation_preview",
"mutation_dry_run",
"dry_run_sql_file",
"batch_execute",
"begin_transaction",
"explain_query",
"lock_check",
"safe_alter_table"
],
"sinks": [
"export_to_sql_file"
]
}
},
{
"ruleId": "MTC-CAP-008",
"title": "Unconstrained path parameter \"filePath\" on \"execute_sql_file\"",
"category": "permissions",
"severity": "low",
"confidence": "heuristic",
"description": "Tool \"execute_sql_file\" takes a path parameter \"filePath\" with no constraint. Without a canonicalize-and-contain check (not visible statically), this permits ../ traversal outside the intended root.",
"remediation": "Resolve and verify the path stays within an allowed root; reject traversal sequences.",
"location": {
"kind": "tool",
"name": "execute_sql_file",
"field": "inputSchema.properties.filePath"
},
"data": {
"param": "filePath"
}
},
{
"ruleId": "MTC-CAP-008",
"title": "Unconstrained path parameter \"filePath\" on \"preview_sql_file\"",
"category": "permissions",
"severity": "low",
"confidence": "heuristic",
"description": "Tool \"preview_sql_file\" takes a path parameter \"filePath\" with no constraint. Without a canonicalize-and-contain check (not visible statically), this permits ../ traversal outside the intended root.",
"remediation": "Resolve and verify the path stays within an allowed root; reject traversal sequences.",
"location": {
"kind": "tool",
"name": "preview_sql_file",
"field": "inputSchema.properties.filePath"
},
"data": {
"param": "filePath"
}
},
{
"ruleId": "MTC-CAP-008",
"title": "Unconstrained path parameter \"filePath\" on \"dry_run_sql_file\"",
"category": "permissions",
"severity": "low",
"confidence": "heuristic",
"description": "Tool \"dry_run_sql_file\" takes a path parameter \"filePath\" with no constraint. Without a canonicalize-and-contain check (not visible statically), this permits ../ traversal outside the intended root.",
"remediation": "Resolve and verify the path stays within an allowed root; reject traversal sequences.",
"location": {
"kind": "tool",
"name": "dry_run_sql_file",
"field": "inputSchema.properties.filePath"
},
"data": {
"param": "filePath"
}
}
],
"toxicFlows": [
{
"id": "flow-1",
"severity": "high",
"confidence": "strong",
"untrustedInput": [],
"sensitiveSource": [
"execute_sql",
"execute_sql_file",
"preview_sql_file",
"mutation_preview",
"mutation_dry_run",
"dry_run_sql_file",
"batch_execute",
"begin_transaction",
"explain_query",
"lock_check",
"safe_alter_table"
],
"externalSink": [
"export_to_sql_file"
],
"selfContained": false,
"path": [
"batch_execute",
"export_to_sql_file"
],
"pathWired": false,
"description": "A sensitive-source → external-sink chain exists: batch_execute → export_to_sql_file."
}
],
"capabilities": [
{
"tool": "list_servers",
"tags": [],
"reasons": {}
},
{
"tool": "list_databases",
"tags": [],
"reasons": {}
},
{
"tool": "switch_server_db",
"tags": [],
"reasons": {}
},
{
"tool": "get_current_connection",
"tags": [],
"reasons": {}
},
{
"tool": "list_schemas",
"tags": [],
"reasons": {}
},
{
"tool": "list_objects",
"tags": [],
"reasons": {}
},
{
"tool": "get_object_details",
"tags": [],
"reasons": {}
},
{
"tool": "execute_sql",
"tags": [
"sensitive-source"
],
"reasons": {
"sensitive-source": [
"keyword \"execute_sql\""
]
}
},
{
"tool": "execute_sql_file",
"tags": [
"sensitive-source"
],
"reasons": {
"sensitive-source": [
"keyword \"execute_sql\""
]
}
},
{
"tool": "preview_sql_file",
"tags": [
"sensitive-source"
],
"reasons": {
"sensitive-source": [
"keyword \"execute_sql\""
]
}
},
{
"tool": "mutation_preview",
"tags": [
"sensitive-source"
],
"reasons": {
"sensitive-source": [
"parameter \"sql\""
]
}
},
{
"tool": "mutation_dry_run",
"tags": [
"sensitive-source"
],
"reasons": {
"sensitive-source": [
"parameter \"sql\""
]
}
},
{
"tool": "dry_run_sql_file",
"tags": [
"sensitive-source"
],
"reasons": {
"sensitive-source": [
"keyword \"run_sql\""
]
}
},
{
"tool": "batch_execute",
"tags": [
"sensitive-source"
],
"reasons": {
"sensitive-source": [
"parameter \"sql\""
]
}
},
{
"tool": "begin_transaction",
"tags": [
"sensitive-source"
],
"reasons": {
"sensitive-source": [
"keyword \"execute_sql\""
]
}
},
{
"tool": "commit_transaction",
"tags": [],
"reasons": {}
},
{
"tool": "rollback_transaction",
"tags": [],
"reasons": {}
},
{
"tool": "get_transaction_info",
"tags": [],
"reasons": {}
},
{
"tool": "list_transactions",
"tags": [],
"reasons": {}
},
{
"tool": "explain_query",
"tags": [
"sensitive-source"
],
"reasons": {
"sensitive-source": [
"parameter \"sql\""
]
}
},
{
"tool": "get_top_queries",
"tags": [],
"reasons": {}
},
{
"tool": "analyze_workload_indexes",
"tags": [],
"reasons": {}
},
{
"tool": "analyze_query_indexes",
"tags": [],
"reasons": {}
},
{
"tool": "export_to_sql_file",
"tags": [
"external-sink"
],
"reasons": {
"external-sink": [
"keyword \"export_to\""
]
}
},
{
"tool": "transfer_objects",
"tags": [],
"reasons": {}
},
{
"tool": "describe_table",
"tags": [],
"reasons": {}
},
{
"tool": "find_dependents",
"tags": [],
"reasons": {}
},
{
"tool": "schema_diff",
"tags": [],
"reasons": {}
},
{
"tool": "lock_check",
"tags": [
"sensitive-source"
],
"reasons": {
"sensitive-source": [
"parameter \"sql\""
]
}
},
{
"tool": "detect_migration_state",
"tags": [],
"reasons": {}
},
{
"tool": "safe_alter_table",
"tags": [
"sensitive-source"
],
"reasons": {
"sensitive-source": [
"keyword \"run_sql\""
]
}
},
{
"tool": "column_profile",
"tags": [],
"reasons": {}
},
{
"tool": "generate_seed_data",
"tags": [],
"reasons": {}
},
{
"tool": "find_blocking_queries",
"tags": [],
"reasons": {}
},
{
"tool": "kill_query",
"tags": [],
"reasons": {}
},
{
"tool": "analyze_db_health",
"tags": [],
"reasons": {}
}
],
"surfaceDigest": "4121a71ff96c4b580e583d1a1957634a17669ba843c5a1e4f36e140faeb9b648",
"stats": {
"tools": 36,
"prompts": 0,
"resources": 0,
"findingsBySeverity": {
"critical": 0,
"high": 1,
"medium": 0,
"low": 3,
"info": 0
}
}
}