Teradata MCP Server

What is Teradata MCP Server about?

Teradata MCP Server offers a set of MCP‑compatible tools that let users run SELECT statements, explore databases and tables, and perform common data‑quality and statistical analyses directly against a Teradata instance.

How to use Teradata MCP Server?

Add the server configuration to claude_desktop_config.json (or run it as a Docker container). The core command uses uv to start the MCP server and requires the DATABASE_URI environment variable pointing to the Teradata connection string. For Docker, update docker‑compose.yml with the same environment variables and launch with docker compose up.

Key features of Teradata MCP Server

• Query Tools: query – execute arbitrary SELECT statements and receive results as JSON objects.
• Schema Tools: list_db, list_tables, show_tables_details – discover databases, list objects, and retrieve column metadata.
• Analysis Tools: list_missing_values, list_negative_values, list_distinct_values, standard_deviation – quick data‑quality checks and basic statistics.
• Keycloak Integration: optional authentication via Keycloak (environment‑driven configuration).
• Docker & UV Support: ready‑to‑run container image and lightweight Python‑based build system.

Use cases of Teradata MCP Server

• Ad‑hoc BI queries for analysts needing fast access to Teradata data without writing full‑stack applications.
• Data profiling during ETL design to surface missing or out‑of‑range values.
• Automated monitoring of data health by invoking analysis tools from scripts or Claude Desktop workflows.
• Secure enterprise deployment leveraging Keycloak for role‑based access control.

FAQ

Q: Which command starts the server? A: Use uv run teradata-mcp (or the Docker compose workflow). The configuration expects a DATABASE_URI like teradata://user:passwd@host.

Q: Do I need to install anything manually? A: Install the UV tool (pip install uv) and ensure the Python environment can reach the Teradata driver. Docker users only need Docker.

Q: How is authentication handled? A: Set KEYCLOAK_ENABLED=true and provide the Keycloak server URL, realm, client ID, and secret as environment variables.

Q: Can I add custom tools? A: Yes, MCP servers are extensible; additional Python modules can be added to the repository and referenced in the tools directory.

Q: What output format do the tools return? A: All tools return JSON‑serializable structures (arrays of objects, simple lists, or key‑value maps).

Teradata MCP Server

Overview

A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through Teradata. This server enables running SQL queries, analyzing business data

Components

Tools

The server offers six core tools:

Query Tools

• query
  • Execute SELECT queries to read data from the database
  • Input:
    • query (string): The SELECT SQL query to execute
  • Returns: Query results as array of objects

Schema Tools

• list_db

  • Lists all databases in the Teradata system
  • Returns: List of databases

• list_tables

  • Lists objects in a database
  • Input:
    • db_name (string): Database name
  • Returns: List of database objects under provided or user defaul database

• show_tables_details

  • Show detailed information about a database tables
  • Input:
  • table_name (string): Name of the table
  • db_name (string): Name of the database
  • Returns: Array of column names and data types

Analysis Tools

• list_missing_values
  • Lists the top features with missing values in a table
• list_negative_values
  • Lists how many features have negative values in a table
• list_distinct_values
  • Lists how many distinct categories are there for column in the table
• standard_deviation
  • What is the mean and standard deviation for column in table?

Usage with Claude Desktop

uv

# Add the server to your claude_desktop_config.json
{
  "mcpServers": {
    "teradata": {
      "command": "uv",
      "args": [
        "--directory",
        "/Users/MCP/mcp-teradata",
        "run",
        "teradata-mcp"
      ],
      "env": {
        "DATABASE_URI": "teradata://user:passwd@host"
      }
    }
  }
}

Usage as API container

Make sure to edit docker-compose.yml and update environment variable

docker compose build
docker compose up

Building

UV:

uv build

License

This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.

Keycloak Authentication Setup

1. Keycloak Configuration

• Create a new realm for MCP
• Create a client for the Teradata MCP server
• Configure client roles and user roles
• Set up proper redirect URIs

2. Environment Variables

KEYCLOAK_ENABLED=true
KEYCLOAK_SERVER_URL=https://your-keycloak-server.com
KEYCLOAK_REALM=mcp-realm
KEYCLOAK_CLIENT_ID=teradata-mcp-client
KEYCLOAK_CLIENT_SECRET=your-client-secret