MCP RAG Server
Provides semantic search and retrieval of document snippets from a PostgreSQL database with pgvector extension.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@MCP RAG Serversearch for documents about scalable vector databases"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
MCP RAG Server
An independent Model Context Protocol (MCP) server that exposes a search_documents tool. This server connects to a PostgreSQL database (pgvector) to perform semantic retrieval. It fetches relevant document snippets and returns the raw context directly to the calling Agent/LLM (e.g., OpenWebUI), so the client's LLM can perform the final synthesis.
Built with Python, FastAPI, and the official MCP SDK.
Project Structure
mcp-rag/
├── Dockerfile # Hardened Alpine-based Docker image
├── README.md
├── requirements.txt # Python dependencies
├── .env.example # Environment variables template
└── src/
├── config.py # Pydantic settings
├── rag.py # Similarity search and retrieval logic
└── server.py # FastAPI MCP server definitionRelated MCP server: Document Retrieval MCP Server
Setup & Configuration
Copy
.env.exampleto.envand fill in your PostgreSQL connection details:cp .env.example .envMake sure your
POSTGRES_HOSTis accessible from the container.
Running with Docker
This project provides a hardened Alpine-based Dockerfile.
Build the image:
docker build -t mcp-rag-server .Run the container:
docker run -d \ --name mcp-rag \ --env-file .env \ -p 8000:8000 \ mcp-rag-server
The MCP Server will be accessible at http://localhost:8000/mcp. You can configure your MCP-compatible clients (like OpenWebUI) to connect via SSE to this endpoint.
Available MCP Tools
search_documents(question: str, top_k: int = 5) -> strExecutes a similarity search against the pgvector store and returns the raw text snippets and their citations. Does NOT perform LLM synthesis natively.
This server cannot be deployed
Maintenance
Related MCP Connectors
Ingest, manage, and retrieve documents for RAG-powered AI applications
Search your knowledge bases from any AI assistant using hybrid RAG.
Search and read Vector Panda docs: API operations, pricing, storage tiers, measured benchmarks.
Query PostgreSQL databases in plain English — LLM-generated, safety-validated SQL.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables semantic search across text documents using vector embeddings stored in PostgreSQL. Provides multiple search modalities including semantic similarity, question/answer, and style-based search through a retrieval-augmented generation system.3Apache 2.0
- AlicenseNot gradedqualityDmaintenanceEnables AI agents to search and retrieve relevant document content from existing embeddings stored in Supabase vector database. Provides semantic search capabilities to find document chunks based on similarity to query text without generating new embeddings.MIT
- AlicenseNot gradedqualityBmaintenanceEnables querying a PostgreSQL database using natural language by retrieving context from Azure AI Search and generating SQL with Azure OpenAI, with validation and optional execution.MIT
- AlicenseAqualityBmaintenanceEnables ingestion and semantic search over text documents using PostgreSQL + pgvector and OpenAI-compatible embeddings, allowing any LLM agent to retrieve relevant chunks for grounded answers.4AGPL 3.0