Teradata Mcp Server
What is Teradata Mcp Server
Teradata MCP Server is a template for building custom Teradata MCP servers, providing a base code that can be modified for developing various tools and applications.
Use cases
Use cases include developing custom analytics tools, integrating with ClearScape Analytics, and creating applications that interact with Teradata databases.
How to use
To use Teradata MCP Server, first set up the environment by installing the ‘uv’ package. Clone the repository, activate the virtual environment, and update the .env file with your database credentials and server settings.
Key features
Key features include customizable server code, support for ClearScape Analytics, and configuration options for server transport methods (SSE or stdio).
Where to use
Teradata MCP Server can be used in data analytics, business intelligence, and application development environments where Teradata databases are utilized.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Teradata Mcp Server
Teradata MCP Server is a template for building custom Teradata MCP servers, providing a base code that can be modified for developing various tools and applications.
Use cases
Use cases include developing custom analytics tools, integrating with ClearScape Analytics, and creating applications that interact with Teradata databases.
How to use
To use Teradata MCP Server, first set up the environment by installing the ‘uv’ package. Clone the repository, activate the virtual environment, and update the .env file with your database credentials and server settings.
Key features
Key features include customizable server code, support for ClearScape Analytics, and configuration options for server transport methods (SSE or stdio).
Where to use
Teradata MCP Server can be used in data analytics, business intelligence, and application development environments where Teradata databases are utilized.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
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:
- DBA tools, prompts and resources to facilitate your platform administration tasks:
- Data Quality tools, prompts and resources accelerate exploratory data analysis:
- Security tools, prompts and resources to resolve permissions:
- Feature Store tools, prompts and resources to manage the Enterprise Feature Store:
- RAG tools, prompts and resources to manage vector store creation and use
- 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
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
