Teradata MCP Server by CData
@CDataSoftware
About Teradata MCP Server by CData
This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free [CData MCP Server for Teradata (beta)](https://www.cdata.com/download/download.aspx?sku=OTZK-V&type=beta).
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"{classname_dash}": {
"command": "PATH\\TO\\java.exe",
"args": [
"-jar",
"PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
"PATH\\TO\\teradata.prp"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is Teradata MCP Server by CData?
Teradata MCP Server by CData is a read-only MCP server that allows large language models (such as Claude Desktop) to query live Teradata data using natural language, without writing SQL. It wraps the CData JDBC Driver for Teradata and exposes Teradata tables as SQL models through a simple MCP interface.
How to use Teradata MCP Server by CData?
Clone the repository, build the JAR with mvn clean install, install and license the CData JDBC Driver for Teradata, create a .prp file with your connection details (prefix, server name, driver path, JDBC URL), then configure the Claude Desktop client to launch the server. The server uses stdio transport, so the client must run on the same machine.
Key features of Teradata MCP Server by CData
- Read-only access to live Teradata data
- Natural language querying via LLMs
- Built-in MCP tools:
get_tables,get_columns,run_query - Simple JDBC connection string configuration
- Supports OAuth authentication when required
Use cases of Teradata MCP Server by CData
- Ask “How many open tickets do I have in the SUPPORT project?”
- Request “What is the correlation between my closed won opportunities and the account industry?”
- Inquire “Can you tell me what calendar events I have today?”
- Explore available tables and columns before querying
FAQ from Teradata MCP Server by CData
Is this MCP server read-only?
Yes, this MCP server is read-only. For full read, write, update, delete, and action capabilities, CData offers a free beta MCP Server for Teradata with a simplified setup.
What are the system requirements?
You need Java, Maven for building, and the CData JDBC Driver for Teradata (a trial is available). The server runs on Windows, Mac, or Linux.
How do I authenticate to Teradata?
Use the CData JDBC Driver’s connection string builder to create your JDBC URL. If the data source uses OAuth, you will authenticate in your browser during connection testing.
Where is the data stored?
Data remains in your Teradata database. The MCP server does not store any data locally; it queries live data on demand.
What transport does the server use?
The server uses stdio transport, so it can only be used with clients running on the same machine as the server (e.g., Claude Desktop).
More Other MCP servers
MCP Registry
modelcontextprotocolA community driven registry service for Model Context Protocol (MCP) servers.
Awesome-MCP-ZH
yzflyMCP 资源精选， MCP指南，Claude MCP，MCP Servers, MCP Clients
Maestro
mobile-dev-incPainless E2E Automation for Mobile and Web
🚀 Model Context Protocol (MCP) Curriculum for Beginners
microsoftThis open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,
MCP Toolbox for Databases
googleapisMCP Toolbox for Databases is an open source MCP server for databases.
Comments