MCP Host Client Server SSE

@HanShan006

About MCP Host Client Server SSE

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

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

Basic information

Category

Other

Runtime

python

Transports

stdio

Publisher

HanShan006

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.

Comments

More Other MCP servers

Production-ready MCP integrations for AI applications

Klavis AI: MCP integration platforms that let AI agents use tools reliably at any scale

EverArt

modelcontextprotocol

Model Context Protocol Servers

MCP Go 🚀

A Go implementation of the Model Context Protocol (MCP), enabling seamless integration between LLM applications and external data sources and tools.

Servers

modelcontextprotocol

Model Context Protocol Servers

Codelf

A search tool helps dev to solve the naming things problem.