Featured

Deploy OpenClaw in 60 seconds — 20% off logoDeploy OpenClaw in 60 seconds — 20% off

Launch OpenClaw on Hostinger in about 60 seconds and keep your agent live 24/7. Our referral link gives you 20% off, no coupon code needed.

Launch on Hostinger
Run your Hermes agent on Hostinger, fully managed logoRun your Hermes agent on Hostinger, fully managed

Launch Hermes on Hostinger in one click, fully managed, no VPS knowledge needed. Use code ZACAARON10 for 10% off.

Launch on Hostinger
Crawl and scrape any site into clean data, 10% off logoCrawl and scrape any site into clean data, 10% off

Firecrawl crawls and scrapes any site into clean markdown for your agent. Get 1,000 free credits, and new users get 10% off their first purchase.

Try Firecrawl free
6,000+ web scrapers for your AI agent, start free logo6,000+ web scrapers for your AI agent, start free

Apify gives your agent live web data: 6,000+ prebuilt scrapers and actors, MCP-ready. Sign up free with $5 in usage credits.

Try Apify free
One API to scrape, enrich, and extract the internet. logoOne API to scrape, enrich, and extract the internet.

Context.dev gives your agents a single API to scrape, enrich, and extract live web data — no proxies, no parsers, no maintenance.

Start building free
SetupClaw: done-for-you OpenClaw for founders & exec teams logoSetupClaw: done-for-you OpenClaw for founders & exec teams

White-glove OpenClaw for founders and exec teams (4–50+ employees): we install, harden, integrate your tools, and maintain it — secured from day one.

Get it set up for you
SEO data APIs for your agent, $1 free credit logoSEO data APIs for your agent, $1 free credit

DataForSEO gives your agent live access to SERP results, keyword data, backlinks, and on-page SEO data through one API. New accounts get a $1 credit, good for up to 20,000 keyword or backlink lookups.

Try DataForSEO free
Reach 48,000+ AI builders

A flat monthly placement in front of developers actively installing AI tools. No lock-in, cancel anytime.

Advertise here

Works with

Claude CodeClaude DesktopCursorVS CodeClineCodex CLIOpenClaw+ any MCP client

Install to Claude Code

This server doesn't publish a one-line install command. Follow the setup in the source repository.

Summary

Connects to a PostgreSQL database (pgvector) to perform semantic retrieval via the search_documents tool, returning raw document snippets for LLM synthesis.

README.md

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 definition

Setup & Configuration

  1. Copy .env.example to .env and fill in your PostgreSQL connection details:
   cp .env.example .env
  1. Make sure your POSTGRES_HOST is accessible from the container.

Running with Docker

This project provides a hardened Alpine-based Dockerfile.

  1. Build the image:
   docker build -t mcp-rag-server .
  1. 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) -> str

Executes a similarity search against the pgvector store and returns the raw text snippets and their citations. Does NOT perform LLM synthesis natively.

See related servers & alternatives →

Related MCP servers

Browse all →

Related guides

Hand-picked reading to help you choose and use Databases servers.