Hologres MCP Server Sse

🚀 Hologres MCP Server

Hologres MCP Server is an open - source project that adheres to the Model Context Protocol (MCP), aiming to provide AI applications with the ability to interact with Hologres databases. It offers two transport modes: SSE (Server - Sent Events) and STDIO, along with comprehensive documentation and sample code.

🚀 Quick Start

Hologres MCP Server implements the MCP protocol, enabling AI agents to easily access data and functions in Hologres databases. Whether you're building an AI - driven IDE, enhancing a chat interface, or creating custom AI workflows, MCP provides a standard way to connect LLMs with the required context.

📦 Installation

Prerequisites

• Python 3.10 or higher
• uv for package management

Run in Development Mode

# SSE mode
python -m hologres_mcp_server.main

# STDIO mode
python -m hologres_mcp_server.main --transport stdio

📚 Documentation

Cherry Studio Integration

1. Install Cherry Studio from the GitHub Releases page.
2. Configure the MCP server in Cherry Studio:
   • SSE mode: Use the host and port (e.g., http://localhost:8001).
   • STDIO mode: Configure commands and parameters, referring to the examples in the documentation.

💻 Usage Examples

Python Examples

SSE Mode Client

# Connect to the SSE endpoint
sse_client = connect_to_sse()

# Initialize the connection
initialize()

# List available tools
tools_response = list_tools()

# Execute a SQL query
sql_result = call_tool("execute_sql", {
    "query": "SELECT 'Hello, Hologres!' AS greeting"
})

STDIO Mode Client

# Start the client
client = StdioClient(command)

# Initialize the connection
client.send_message("initialize", {
    "clientInfo": {
        "name": "python-stdio-test-client",
        "version": "1.0.0"
    }
})

# Execute a SQL query
client.send_message("callTool", {
    "name": "execute_sql",
    "arguments": {
        "query": "SELECT 'Hello, Hologres!' AS greeting"
    }
})

Node.js Example

// Connect to the SSE endpoint
eventSource = await connectToSSE();

// Initialize the connection
await initialize();

// Execute a SQL query
const sqlResult = await callTool('execute_sql', {
  query: "SELECT 'Hello, Hologres!' AS greeting"
});

🔧 Technical Details

Unit Tests

Test Files

# Test the initialization of the connection
def test_01_initialize(self):
    response = self.send_message("initialize", {
        "clientInfo": {
            "name": "test-client",
            "version": "1.0.0"
        }
    })
    
    self.assertIn("result", response)
    self.assertIn("protocolVersion", response["result"])

# Test listing available tools
def test_02_list_tools(self):
    response = self.send_message("listTools", {})
    self.assertIn("tools", response)

Run Tests

python -m pytest tests/

📄 License

This project is licensed under the Apache License 2.0. For more information, please refer to the LICENSE file.

💪 Contribution

Community contributions are welcome! Please refer to CONTRIBUTING.md for detailed information.