Teradata MCP Server for Claude

Overview

The Teradata MCP Server is the official Model Context Protocol server from Teradata, giving Claude structured access to Teradata databases. It covers database and table discovery, DDL inspection, SQL execution, data previewing, DBA diagnostics, column quality analysis, and session monitoring. Install the optional teradataml Python package to unlock ~89 additional ML tools for statistical modeling and machine learning workflows. Licensed under MIT.

Key capabilities

• Database discovery — list all databases and their tables/views.
• Schema inspection — retrieve full DDL for any table or view.
• SQL execution — run arbitrary SQL queries with configurable row limits.
• Data preview — preview rows from tables quickly without writing SQL.
• Column quality — statistical summaries and missing value analysis.
• DBA diagnostics — session info, system space, and user/permission queries.
• ML tools (optional) — teradataml adds ~89 dynamic tools: KMeans, XGBoost, AutoML, etc.

Tools (key selection)

Configuration options

How it compares

Teradata MCP is the only data warehouse MCP with built-in column quality analysis and optional ML model tools via teradataml.

Installation

Claude Code

claude mcp add teradata \
  -e DATABASE_URI="teradata://username:password@host:1025/databasename" \
  -- uvx teradata-mcp-server

Claude Desktop

{
  "mcpServers": {
    "teradata": {
      "command": "uvx",
      "args": ["teradata-mcp-server"],
      "env": {
        "DATABASE_URI": "teradata://username:password@host:1025/databasename"
      }
    }
  }
}

For LDAP authentication, add "LOGMECH": "LDAP" to the env block.

Requirements

• Teradata database instance (on-premises or Teradata VantageCloud).
• Python with uvx (from uv).
• An MCP client (Claude Code or Claude Desktop).
• Optional: pip install teradataml for ML tools.

Security

• Use credentials scoped to least privilege — read-only if SQL execution isn't needed.
• base_query runs arbitrary SQL; ensure the Teradata user does not have destructive permissions.
• Keep the DATABASE_URI secret; it contains your username and password.

Source Verification Notes

Verified on 2026-06-18:

• Official repository Teradata/teradata-mcp-server (MIT) on PyPI as teradata-mcp-server documents the DATABASE_URI connection URI format, all tool categories (base, dba, sec, qlty), optional teradataml ML tools, connection pool and row limit configuration, and multiple transport modes.
• Claude Code MCP documentation at code.claude.com/docs/en/mcp describes the stdio connector pattern used above.