Teradata MCP Server

A collection of tools for managing the platform, addressing data quality and reading and writing to Teradata Database.

Local serverstdio

What is the Teradata MCP server?

If you want an AI assistant working directly with Teradata, the teradata mcp server is the bridge. A collection of tools for managing the platform, addressing data quality and reading and writing to Teradata Database.

What Teradata does

Connect AI agents directly to Teradata with enterprise security and extensibility.

Tools it exposes

Once connected, the assistant can call this tool directly:

  • ClientBest For

Installing the teradata mcp server

Setup follows the standard MCP pattern: clone or install the server, then register it in your client's configuration file and restart the client. The configuration snippets on this page cover Claude Desktop, Claude Code and Cursor.

Configuration

Before the server will start you need to supply 2 environment variables: DATABASE_URI, HOST_URL. Keep credentials in your client's env block or a secrets manager rather than committing them.

Where it fits

Database servers turn schema archaeology and ad-hoc reporting into conversation, which is why they tend to be the second or third server people install. Teradata sits in that group, and the shape of its toolset — Client — tells you what it is really for. Worth comparing against the other databases servers in this directory before you commit to one, since several overlap in scope but differ sharply in setup cost and permissions.

Practical notes

  • This server runs locally, so it operates with whatever access your machine and its credentials already have. Scope that deliberately rather than by default.
  • It will not start until its required credentials are present, so set those before wondering why the tools never appear.
  • MCP clients ask for confirmation before each tool call by default. Keep that on while you learn what the teradata mcp server actually does with your data.
  • Every entry in this directory is reviewed by hand before it goes live, and details are checked against the project's own documentation.

Available tools

ToolWhat it does
Client**Best For**

How to install the Teradata MCP server

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

Configuration as documented by the project. Restart the client after saving.

Configuration

VariableDescriptionRequired
DATABASE_URIConfiguration value read at startup.Optional
HOST_URLEndpoint or connection string the server talks to.Yes

Example prompts to try

  • Use Teradata to Client.

Frequently asked questions

It connects Teradata to MCP-compatible AI assistants such as Claude and Cursor, exposing 1 tool (Client) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with Teradata directly.