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

• Base tools, prompts and resources to interact with your Teradata platform:
  • Base Tools
• DBA tools, prompts and resources to facilitate your platform administration tasks:
  • DBA Tools
• Data Quality tools, prompts and resources accelerate exploratory data analysis:
  • Data Quality Tools
• Security tools, prompts and resources to resolve permissions:
  • Security Tools
• Feature Store tools, prompts and resources to manage the Enterprise Feature Store:
  • Feature Store Tools
• RAG tools, prompts and resources to manage vector store creation and use
  • RAG Tools
• Custom Tools to easily implement tools for custom actions based on your data and business context.

Adding custom tools

You may add define custom "query" tools in the custom_tools.yaml file or in any file ending with _tools.yaml. Simply specify the tool name, description and SQL query to be executed. No parameters are supported at this point.

---

TLDR; I want to try it locally now

If you have Docker and a client that can connect MCP servers via SSE, copy the code below, update the connection string set in DATABASE_URI with your database connection details and run it:

export DATABASE_URI=teradata://username:password@host:1025
git clone https://github.com/Teradata/teradata-mcp-server.git
cd teradata-mcp-server
docker compose up

You can now use it with clients supporting SSE such as Visual Studio Code.

---

Certification