teradata-mcp-server 0.1.2

Model Context Protocol (MCP) server for Teradata, Community edition

Teradata MCP Server

Overview

The Teradata MCP server provides sets of tools and prompts, grouped as modules for interacting with Teradata databases. Enabling AI agents and users to query, analyze, and manage their data efficiently.

Key features

Available tools and prompts

We are providing groupings of tools and associated helpful prompts to support all type of agentic applications on the data platform.

• Search tools, prompts and resources to search and manage vector stores.
  • RAG Tools rapidly build RAG applications.
• Query tools, prompts and resources to query and navigate your Teradata platform:
  • Base Tools
• Table tools, to efficiently and predictably access structured data models:
  • Feature Store Tools to access and manage the Teradata Enterprise Feature Store.
  • Semantic layer definitions to easily implement domain-specific tools, prompts and resources for your own business data models.
• Data Quality tools, prompts and resources accelerate exploratory data analysis:
  • Data Quality Tools
• DBA tools, prompts and resources to facilitate your platform administration tasks:
  • DBA Tools
  • Security Tools

Getting Started

Step 1. - Identify the running Teradata System, you need username, password and host details to populate "teradata://username:password@host:1025". If you do not have a Teradata system to conect to, then leverage Teradata Clearscape Experience

Step 2. - To cofigure and run the MCP server, refer to the Getting started guide.

Step 3. - There are many client options availale, the Client Guide explains how to configure and run a sample of different clients.

A Video Library has been curated to assist.

Installation

PyPI Installation (Recommended)

The easiest way to get started is to install from PyPI:

pip install teradata-mcp-server

Quick start with Claude desktop

Once installed, you can use the MCP server with Claude Desktop:

1. Get your Teradata database credentials or create a free sandbox at Teradata Clearscape Experience.
2. Install Claude Desktop
3. Configure the claude_desktop_config.json (Settings>Developer>Edit Config) by adding the configuration below, updating the database username, password and URL:

{
  "mcpServers": {
    "teradata": {
      "command": "teradata-mcp-server",
      "args": ["--profile", "all"],
      "env": {
        "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
      }
    }
  }
}

Build from Source (Development)

For development or customization, you can build from source:

1. Install uv. If you are on macOS, use Homebrew: brew install uv
2. Clone this repository: git clone https://github.com/Teradata/teradata-mcp-server.git
3. Navigate to the directory: cd teradata-mcp-server
4. Run the server: uv run teradata-mcp-server

For Claude Desktop with development build, use this configuration:

{
  "mcpServers": {
    "teradata": {
      "command": "uv",
      "args": [
        "--directory",
        "<PATH_TO_DIRECTORY>/teradata-mcp-server",
        "run",
        "teradata-mcp-server"
      ],
      "env": {
        "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>",
        "MCP_TRANSPORT": "stdio"
      }
    }
  }
}

Contributing

Please refer to the Contributing guide and the Developer Guide.

---

Certification