by arturborycki
mcp-teradata is an MCP (Model Context Protocol) server that enables Large Language Models (LLMs) to interact with Teradata databases, facilitating data querying and business intelligence analysis.
mcp-teradata is a Model Context Protocol (MCP) server specifically designed to connect Large Language Models (LLMs) with Teradata databases. It provides a set of tools that allow LLMs to perform various operations on Teradata databases, including executing SQL queries, listing database objects, and performing data analysis.
mcp-teradata can be used in two primary ways: with Claude Desktop or as an API container.
To integrate with Claude Desktop, you need to add the server configuration to your claude_desktop_config.json
file. This involves specifying the command to run the server using uv
and setting the DATABASE_URI
environment variable to connect to your Teradata instance.
For containerized deployment, you can use Docker Compose. After editing the docker-compose.yml
file to update environment variables, you can build and run the containers using docker compose build
and docker compose up
.
mcp-teradata offers a range of tools categorized into Query Tools, Schema Tools, and Analysis Tools:
query
: Executes SELECT
SQL queries to retrieve data from the database, returning results as an array of objects.list_db
: Lists all databases available in the Teradata system.list_objects
: Lists objects within a specified database.show_tables
: Provides detailed information about tables in a database, including column names and data types.list_missing_values
: Identifies and lists the top features with missing values in a given table.list_negative_values
: Counts and lists features that contain negative values in a table.list_distinct_values
: Determines and lists the number of distinct categories for a specified column in a table.standard_deviation
: Calculates and returns the mean and standard deviation for a column in a table.Q: What is an MCP server? A: An MCP (Model Context Protocol) server is an implementation that allows AI models, such as LLMs, to interact with external systems and data sources, in this case, Teradata databases.
Q: What license is mcp-teradata released under? A: mcp-teradata is licensed under the MIT License, which permits free use, modification, and distribution of the software under specified terms and conditions.
A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through Teradata. This server enables running SQL queries, analyzing business data
The server offers six core tools:
query
query
(string): The SELECT SQL query to executelist_db
list_objects
db_name
(string): Database nameshow_tables
table_name
(string): Name of the tablelist_missing_values
list_negative_values
list_distinct_values
standard_deviation
# Add the server to your claude_desktop_config.json
{
"mcpServers": {
"teradata": {
"command": "uv",
"args": [
"--directory",
"/Users/MCP/mcp-teradata",
"run",
"teradata-mcp"
],
"env": {
"DATABASE_URI": "teradata://user:passwd@host"
}
}
}
}
Make sure to edit docker-compose.yml and update environment variable
docker compose build
docker compose up
UV:
uv build
This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.
Please log in to share your review and rating for this MCP.
Discover more MCP servers with similar functionality and use cases
by googleapis
Provides a configurable MCP server that abstracts connection pooling, authentication, observability, and tool management to accelerate development of database‑backed AI tools.
by bytebase
DBHub is a universal database gateway that implements the Model Context Protocol (MCP) server interface, enabling MCP-compatible clients to interact with various databases.
by neo4j-contrib
Provides Model Context Protocol servers for interacting with Neo4j databases, managing Aura instances, and handling personal knowledge graph memory through natural‑language interfaces.
by mongodb-js
Provides a Model Context Protocol server that connects to MongoDB databases and Atlas clusters, exposing a rich set of tools for querying, managing, and administering data and infrastructure.
by benborla
A Model Context Protocol (MCP) server that provides read-only access to MySQL databases, enabling Large Language Models (LLMs) to inspect database schemas and execute read-only queries.
by ClickHouse
Provides tools that let AI assistants run read‑only SQL queries against ClickHouse clusters or the embedded chDB engine, plus a health‑check endpoint for service monitoring.
by elastic
Provides direct, natural‑language access to Elasticsearch indices via the Model Context Protocol, allowing AI agents to query and explore data without writing DSL.
by motherduckdb
Provides an MCP server that enables SQL analytics on DuckDB and MotherDuck databases, allowing AI assistants and IDEs to execute queries via a unified interface.
by redis
Provides a natural language interface for agentic applications to manage and search data in Redis efficiently.