# HiveServer2 MCP
A MCP server for HiveServer2.
## Installation
1. **Clone the repository:**
```bash
git clone https://github.com/your-username/hiveserver2-mcp.git
cd hiveserver2-mcp
```
2. **Create a virtual environment:**
```bash
python3 -m venv venv
source venv/bin/activate
```
3. **Install the dependencies:**
```bash
pip install -r requirements.txt
```
## 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:**
```bash
hiveserver2-mcp
```
3. **Interact with the server:**
You can use `curl` to interact with the server.
**Query:**
```bash
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:**
```bash
sudo apt-get install -y libsasl2-dev
pip install sasl
```
**macOS:**
```bash
brew install sasl
pip install sasl
```
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/xiexiajiao/HIVE-MCP'
If you have feedback or need assistance with the MCP directory API, please join our Discord server