MCP Host Client Server SSE

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

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.