广告合作
MCP.so
登录

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?

  1. Clone the repository, install dependencies (openai, mcp-framework, starlette, uvicorn).
  2. Create a config.ini file with your OpenAI API key.
  3. Initialize the SQLite database: python create_database.py.
  4. Start the MCP server: python mcp_server.py.
  5. 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")

常见问题

1

What are the prerequisites?

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

2

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`.

3

Which database does it use?

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

4

Which language models are supported?

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

5

What transport protocol is used?

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

评论

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

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

广告合作