MCP Host Client Server SSE

@HanShan006

About MCP Host Client Server SSE

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

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

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"
      ]
    }
  }
}

Tools

No tools detected

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?

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

FAQ from MCP Host Client Server SSE

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.

Frequently asked questions

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.

Comments

Basic information

More Other MCP servers

Mobile Mcp

mobile-next

Model Context Protocol Server for Mobile Automation and Scraping (iOS, Android, Emulators, Simulators and Real Devices)

5.4K

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.