Advertise
MCP.so
Sign In

MCP Host Client Server SSE

@HanShan006

Repository

Basic information

Category

Other

Transports

stdio

Author

HanShan006

About MCP Host Client Server SSE

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

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

MCP Host Client Server SSE config

Add this server to your MCP-compatible client using the configuration below.

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

MCP Host Client Server SSE tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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")

Frequently asked questions

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.

Comments

More Other MCP servers

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

The Living Bread

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

Advertise