Teradata MCP Server by CData
@CDataSoftware
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).
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).
