広告掲載
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.

コメント

「その他」の他のコンテンツ

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

Hindsight

vectorize-io

Hindsight: Agent Memory That Learns

50.4K

Glasswarp

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

広告掲載