Question 630
A coding assistant is granted unrestricted write access to a production SQL MCP server while troubleshooting a read-only query. The team is considering this step: Restrict to approved read-only tools and a nonproduction connection for diagnosis. What evidence should they review before proceeding?
Explanation
Correct Answer
Inventory exposed MCP actions, auth principal, destination and prompt-injection threats. MCP tool permissions should be least-privilege and scoped to the task, especially for AI tools. Tool calls are logged and unauthorized write attempts are denied.
Incorrect Answers
MCP tool capability and SQL principal permissions remain effective regardless of prompt intent; deny dangerous actions in the tool and database.
A live connection can still be overprivileged; scope database access, table projections and tool commands separately.
Untrusted metadata can influence tool calls, and read tools can expose data; tool logs and authorization tests are essential.