MCP Host Client Server SSE

@HanShan006

代码仓库

基本信息

分类

其他

传输方式

stdio

作者

HanShan006

关于 MCP Host Client Server SSE

手搓MCP样例，使用SSE模式，访问本地数据。从Hosts到server全部代码演示。

#mcp #sql-query #natural-language-processing

MCP Host Client Server SSE 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "MCP_Host_Client_Server_SSE": {
      "command": "python",
      "args": [
        "create_database.py"
      ]
    }
  }
}

MCP Host Client Server SSE 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MCP Host Client Server SSE?

MCP Host Client Server SSE is a natural language SQL database query system built on the Model Context Protocol (MCP). It integrates with OpenAI to convert natural language questions into SQL queries, using Server-Sent Events (SSE) for real-time communication between the host and server.

How to use MCP Host Client Server SSE?

Clone the repository, install dependencies (openai, mcp-framework, starlette, uvicorn).
Create a config.ini file with your OpenAI API key.
Initialize the SQLite database: python create_database.py.
Start the MCP server: python mcp_server.py.
Run the host application: python mcp_host.py.

Key features of MCP Host Client Server SSE

MCP protocol-based server-client architecture
Natural language to SQL query translation via OpenAI
Real-time communication using Server-Sent Events (SSE)
SQLite database integration with sample tables (users, orders)
OpenAI/DeepSeek API integration
Asynchronous support and full logging system

Use cases of MCP Host Client Server SSE

Query all user information in natural language
Retrieve specific user orders (e.g., "Show all orders of Zhang San")
Get aggregated statistics (e.g., "Total consumption per user")
Filter data by conditions (e.g., "Orders over 5000")

常见问题

What are the prerequisites?

Python 3.8+, pip package manager, and an OpenAI API key.

How do I configure the API key?

Create a `config.ini` file in the project root and add `[secrets] API_KEY=your_api_key_here`.

Which database does it use?

SQLite. Sample tables `users` and `orders` are created by `create_database.py`.

Which language models are supported?

The system integrates both OpenAI and DeepSeek APIs for natural language processing.

What transport protocol is used?

Server-Sent Events (SSE) for real‑time streaming of query results from the MCP server to the host.

其他分类下的更多 MCP 服务器

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w

Yuppsy

Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code