MCP security patterns — CCA-F Exam Prep

A developer connected a new AI tool to the company's MCP servers. It deleted the production database.
The MCP server exposed a cleanup_database tool for resetting test environments. No authentication -- any client could connect and call any tool. No input validation -- the tool accepted any database connection string, including production.
The AI assistant found a production connection string in an environment variable, passed it to cleanup_database, and the server executed it. No confirmation. No permission check.