mcp-cooking-recipes-server-example
by michaelgruczel
Overview
An MCP server example for cooking recipe search and retrieval using a vector database (ChromaDB) and a relational database (PostgreSQL).
Installation
mcp run mcp_tutorial_server.pyEnvironment Variables
- POSTGRES_DB
- POSTGRES_USER
- POSTGRES_PASSWORD
- ANONYMIZED_TELEMETRY
Security Notes
The application uses hardcoded database credentials (username, password, database name) in `load_data_db.py` and `mcp_tutorial_server.py`. Additionally, `load_data_db.py` contains a clear SQL injection vulnerability in its `INSERT` statement construction using string concatenation, and `mcp_tutorial_server.py` has a similar vulnerability in its `SELECT` statement if the `recipe_id` parameter can be manipulated.
Similar Servers
MCP-PostgreSQL-Ops
The MCP server provides professional operations, monitoring, and management capabilities for PostgreSQL databases using natural language queries.
neurondb
A Model Context Protocol (MCP) server designed to expose advanced AI and database functionalities (vector search, ML, RAG, PostgreSQL admin) as tools via a standardized JSON-RPC protocol over STDIN/STDOUT, typically serving as a backend for AI agents or desktop applications.
chromadb-remote-mcp
Provides remote, authenticated access to ChromaDB for AI assistants like Claude, enabling semantic search and vector database operations from various platforms and locations.
family-serve-delicious
AI-driven, constraint-aware meal planning for families and groups using local LLM models.