Skip to main content
Glama

Teradata MCP Server

Official
by Teradata

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.

alt text

  • Search tools, prompts and resources to search and manage vector stores.
  • Query tools, prompts and resources to query and navigate your Teradata platform:
  • Table tools, to efficiently and predictably access structured data models:
  • Data Quality tools, prompts and resources accelerate exploratory data analysis:
  • DBA tools, prompts and resources to facilitate your platform administration tasks:

Getting Started

Getting Started

Step 1. - Identify the running Teradata System, you need username, password and host details to populate "teradata://username@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.

Quick start with Claude desktop

If you want to quickly evaluate the tool, we recommend using Claude desktop, the uv package manager and Teradata Clearscape Experience.

  1. Get your Teradata database credentials or create a free sandbox at Teradata Clearscape Experience.
  2. Install uv. If you are on macOS, use Homebrew: brew install uv
  3. Clone this repository with git clone https://github.com/Teradata/teradata-mcp-server.git
  4. Install Claude Desktop
  5. Configure the claude_desktop_config.json (Settings>Developer>Edit Config) by adding the code below, updating the PATH_TO_DIRECTORY (where you cloned the repo in step 2) and database username, password and URL.
{ "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

Deploy Server
A
security – no known vulnerabilities
A
license - permissive license
A
quality - confirmed to work

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

A server providing tools for querying and analyzing Teradata databases, including database management, data quality assessment, and SQL execution capabilities through an MCP interface.

  1. Overview
    1. Environment Set Up
      1. Testing your server with MCP Inspector
        1. Running the server
          1. Adding your sever to an Agent using stdio
            1. Option 1 - pydanticai chatbot
            2. Option 2 - ADK Chatbot
            3. Option 3 - mcp_chatbot
          2. Adding tools using stdio to Visual Studio Code Co-pilot
            1. Adding tools using SSE to Visual Studio Code Co-pilot
              1. Adding the MCP server to Claude Desktop
                1. Exposing tools as REST endpoints with mcpo
                  1. Using the server with Open WebUI
                    1. Certification

                      Related MCP Servers

                      • A
                        security
                        A
                        license
                        A
                        quality
                        An MCP server that provides tools for interacting with Supabase databases, storage, and edge functions.
                        Last updated -
                        14
                        43
                        MIT License
                      • -
                        security
                        A
                        license
                        -
                        quality
                        An MCP server that connects to Supabase PostgreSQL databases, exposing table schemas as resources and providing tools for data analysis through SQL queries.
                        Last updated -
                        1
                        MIT License
                      • -
                        security
                        F
                        license
                        -
                        quality
                        An MCP server that allows working with MySQL databases by providing tools for executing read-only SQL queries, getting table schemas, and listing database tables.
                        Last updated -
                        704
                        2
                      • -
                        security
                        F
                        license
                        -
                        quality
                        An MCP server for interacting with Treasure Data API, allowing users to retrieve database information and check server status through natural language queries.
                        Last updated -
                        • Linux
                        • Apple

                      View all related MCP servers

                      MCP directory API

                      We provide all the information about MCP servers via our MCP API.

                      curl -X GET 'https://glama.ai/api/mcp/v1/servers/Teradata/teradata-mcp-server'

                      If you have feedback or need assistance with the MCP directory API, please join our Discord server