HiveServer2 MCP

A MCP server for HiveServer2.

Installation

1. Clone the repository:

   git clone https://github.com/your-username/hiveserver2-mcp.git
   cd hiveserver2-mcp

2. Create a virtual environment:

   python3 -m venv venv
   source venv/bin/activate

3. Install the dependencies:

   pip install -r requirements.txt

Related MCP server: MCP-OpenAPI

Usage

1. Create a .env file:

   Create a .env file in the root of the project and add the following environment variables:

   HIVESERVER2_HOST=<your_hiveserver2_host>
   HIVESERVER2_PORT=<your_hiveserver2_port>
   HIVESERVER2_USER=<your_hiveserver2_user>
   HIVESERVER2_PASSWORD=<your_hiveserver2_password>

2. Run the server:

   hiveserver2-mcp

3. Interact with the server:

   You can use curl to interact with the server.

   Query:

   curl -X POST -H "Content-Type: application/json" -d '{"query": "SELECT * FROM my_table"}' http://localhost:5000/query

Note on sasl

This project does not include the sasl package as a direct dependency, as it can be difficult to install on some systems. If you are connecting to a Hive instance that requires SASL authentication, you may need to install it manually.

Ubuntu/Debian:

sudo apt-get install -y libsasl2-dev
pip install sasl

macOS:

brew install sasl
pip install sasl