Content
# 2026-2025-Best-MCP
รวม **Best MCP server** ที่คัดเลือกมาจากการเปรียบเทียบ MCP server หลายตัว
ในคลัง repo ของ [@aekanun2020](https://github.com/aekanun2020) — ครอบคลุมทั้งงาน **MSSQL execute query** และ **RAG**
## ตัวที่เลือก (จากการเปรียบเทียบ)
ตัวที่ได้จากการคัดเลือกเปรียบเทียบ MCP server หลายตัว — ต้นฉบับเหล่านี้ใช้ **SSE transport** (port `9000/sse`)
| Folder | Type | transport | Source | Comparison Document |
|---|---|---|---|---|
| [`mssql-mcp-server/`](./mssql-mcp-server) | MSSQL (execute query) | SSE | [2026-customLangFlow-...-mssql](https://github.com/aekanun2020/2026-customLangFlow-and-v5-mcpserver-for-mssql) | [COMPARISON.md](./COMPARISON.md) |
| [`rag-mcp-server-suparag/`](./rag-mcp-server-suparag) | RAG (Best/Newest) | SSE | [SupaRAG](https://github.com/aekanun2020/SupaRAG) | [RAG-COMPARISON.md](./RAG-COMPARISON.md) |
| [`rag-mcp-server-v3/`](./rag-mcp-server-v3) | RAG (Lightweight + `add_context`) | SSE | [v3-2026-mcp-streamable-sse-rag](https://github.com/aekanun2020/v3-2026-mcp-streamable-sse-rag) | [RAG-COMPARISON.md](./RAG-COMPARISON.md) |
## Streamable HTTP (Moved from Selected Ones)
Another 2 folders are versions moved from SSE to **Streamable HTTP transport** (current MCP standard — single endpoint `/mcp`, stateless, no session enforcement) while maintaining all original capabilities.
| Folder | Type | endpoint | port (host) | Original | Testing Guide |
|---|---|---|---|---|---|
| [`mssql-mcp-server-streamablehttp/`](./mssql-mcp-server-streamablehttp) | MSSQL (execute query) | `/mcp` | `9000` | [`mssql-mcp-server/`](./mssql-mcp-server) | — |
| [`rag-mcp-server-streamablehttp/`](./rag-mcp-server-streamablehttp) | RAG (Hybrid Thai) | `/mcp` | `8000` | [`rag-mcp-server-v3/`](./rag-mcp-server-v3) | [TESTING_GUIDE.md](./rag-mcp-server-streamablehttp/TESTING_GUIDE.md) |
---
## 1) MSSQL MCP Server — v5 + Database Context
Taken from [`2026-customLangFlow-and-v5-mcpserver-for-mssql`](https://github.com/aekanun2020/2026-customLangFlow-and-v5-mcpserver-for-mssql)
Full reasons and comparison table in [COMPARISON.md](./COMPARISON.md)
### Brief Summary of Why This is the Best
- Has `get_database_context` tool that fetches schema + relationships (foreign keys) + T-SQL guide of entire DB at once, allowing LLM agents to write correct SQL before executing `execute_query_tool` → reduces SQL errors
- Has `DatabaseCache` that caches both schema and relationship graph, reducing context time from ~10 seconds (cold) to ~23ms (warm)
- Passed real-world testing with multi-level business questions, achieving high average scores (~98–99.5/100) and 0 SQL errors
- Supports SSE transport + Docker + Claude Desktop config out-of-the-box
## Getting Started
```bash
cd mssql-mcp-server
cp .env.example .env # configure DB_SERVER / DB_NAME / DB_USER / DB_PASSWORD
docker-compose up # server (SSE) available at http://localhost:9000/sse
```
> Want to use current standard transport (Streamable HTTP, endpoint `/mcp`)? Use [`mssql-mcp-server-streamablehttp/`](./mssql-mcp-server-streamablehttp) — available at `http://localhost:9000/mcp`
---
## 2) RAG MCP Server — Selected from Comparison of 2 (Each Excels in Different Aspects)
Details and comparison table of 5 RAG servers in [RAG-COMPARISON.md](./RAG-COMPARISON.md)
- **[`rag-mcp-server-suparag/`](./rag-mcp-server-suparag)** — Best/Newest, focuses on "smart indexing":
Contextual Retrieval by Anthropic + OpenSearch (dual index) + BGE-M3 + Qwen + Streamlit UI
- **[`rag-mcp-server-v3/`](./rag-mcp-server-v3)** — Lightweight (Qdrant), focuses on "flexibility in usage":
Has `add_context` tool for agents to add knowledge to RAG base during conversations (others don't have this)
Choose: Want accuracy/ready for production → SupaRAG; Want lightweight/agent can add knowledge → v3
> **Note:** If you need RAG on current standard transport, use [`rag-mcp-server-streamablehttp/`](./rag-mcp-server-streamablehttp) — moved v3 (Hybrid + `add_context`) to Streamable HTTP (endpoint `/mcp`, port `8000`) with Qdrant + Ollama in a single compose, with testing guide in [TESTING_GUIDE.md](./rag-mcp-server-streamablehttp/TESTING_GUIDE.md)
