MCP Host Client Server SSE

@HanShan006

Repository

Basic information

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?

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

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

More Other MCP servers

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

🚀 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

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

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