# Cloudera Mcp

> MCP server to integrate with Cloudera data warehouse

- **Type:** MCP server
- **Install:** `agentstack add mcp-genai-works-org-cloudera-mcp`
- **Verified:** Pending review
- **Seller:** [genai-works-org](https://agentstack.voostack.com/s/genai-works-org)
- **Installs:** 0
- **Category:** [Data & Analytics](https://agentstack.voostack.com/c/data-and-analytics)
- **Latest version:** 0.1.0
- **License:** Apache-2.0
- **Upstream author:** [genai-works-org](https://github.com/genai-works-org)
- **Source:** https://github.com/genai-works-org/cloudera-mcp

## Install

```sh
agentstack add mcp-genai-works-org-cloudera-mcp
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# Iceberg MCP Server - Setup Guide

Complete setup instructions for the Iceberg MCP Server with HTTP transport support.

## Prerequisites

- **Python 3.10+** 
- **Access to Cloudera Data Platform** with Impala
- **Valid Cloudera credentials**
- **uv** package manager (recommended) or pip

### Install UV (if not already installed)
```bash
# macOS/Linux
curl -LsSf https://astral.sh/uv/install.sh | sh

# Windows
powershell -c "irm https://astral.sh/uv/install.ps1 | iex"

# Or via pip
pip install uv
```

## Installation

### Step 1: Clone the Repository
```bash
git clone https://github.com/genai-works-org/cloudera-mcp
cd cloudera-mcp
```

### Step 2: Install Dependencies
```bash
# Sync existing project dependencies
uv sync

# Install project in editable mode
uv pip install -e .
```

## Configuration

### Step 3: Create Environment Configuration
Create a `.env` file in the project root directory:

```bash
# Create .env file with your Cloudera credentials
cat > .env << EOF
# Cloudera Impala Configuration
IMPALA_HOST=your-coordinator-host.cloudera.site
IMPALA_PORT=443
IMPALA_USER=your-username
IMPALA_PASSWORD=your-password
IMPALA_DATABASE=default
IMPALA_AUTH_MECHANISM=LDAP
IMPALA_USE_HTTP_TRANSPORT=true
IMPALA_HTTP_PATH=cliservice
IMPALA_USE_SSL=true

EOF
```

### Step 4: Update Configuration Values
Edit the `.env` file with your actual credentials:

**For Cloudera Data Platform:**
- **IMPALA_HOST**: Your Cloudera coordinator hostname
- **IMPALA_USER**: Your Cloudera username  
- **IMPALA_PASSWORD**: Your Cloudera password
- **IMPALA_AUTH_MECHANISM**: Usually `LDAP` for CDP

**Example from JDBC connection string:**
```
jdbc:impala://coordinator-xyz123.dw-xyz123.cloudera.site:443/default;AuthMech=3;transportMode=http;httpPath=cliservice;ssl=1;UID=myuser;PWD=mypass
```
Converts to:
```bash
IMPALA_HOST=coordinator-xyz123.dw-xyz123.cloudera.site
IMPALA_PORT=443
IMPALA_USER=myuser
IMPALA_PASSWORD=mypass
IMPALA_AUTH_MECHANISM=LDAP 
```

## Verification

### Step 6: Test Database Connection
```bash
# Test database connectivity
uv run python -c "
import os
from dotenv import load_dotenv
load_dotenv()
from cloudera_mcp.tools.impala_tools import get_db_connection

try:
    conn = get_db_connection()
    print('Database connection successful')
    conn.close()
except Exception as e:
    print(f'Database connection failed: {e}')
"
```

### Step 7: Start the MCP Server
```bash
# Start the server
uv run python src/cloudera_mcp/server.py
```

**Expected output:**
```
Starting Iceberg MCP Server via Impala on port 8888
Server will be available at: http://localhost:8888/
INFO:     Started server process [46517]
INFO:     Waiting for application startup.
[07/09/25 01:23:53] INFO     StreamableHTTP session manager started                                                                                                   streamable_http_manager.py:112
INFO:     Application startup complete.
INFO:     Uvicorn running on http://127.0.0.1:8888 (Press CTRL+C to quit)
```

## Source & license

This open-source MCP server is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [genai-works-org](https://github.com/genai-works-org)
- **Source:** [genai-works-org/cloudera-mcp](https://github.com/genai-works-org/cloudera-mcp)
- **License:** Apache-2.0

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** yes
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** yes
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: flagged — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/mcp-genai-works-org-cloudera-mcp
- Seller: https://agentstack.voostack.com/s/genai-works-org
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.