What is Mcp Teradata

mcp-teradata is a Model Context Protocol (MCP) server designed for Teradata databases, providing capabilities for database interaction and business intelligence.

Use cases

Use cases include generating reports from SQL queries, analyzing business data for insights, and ensuring data quality by identifying missing or negative values in datasets.

How to use

To use mcp-teradata, add the server configuration to your ‘claude_desktop_config.json’ file, specifying the command and database URI. Then, you can run queries and utilize various tools for data analysis.

Key features

Key features include executing SQL queries, listing databases and objects, showing table details, and performing data analysis such as identifying missing values, negative values, distinct values, and calculating standard deviation.

Where to use

mcp-teradata can be used in various fields that require data analysis and business intelligence, such as finance, marketing, healthcare, and any industry relying on Teradata databases.

Teradata MCP Server

Overview

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

Components

Tools

The server offers six core tools:

Query Tools

• query
  • Execute SELECT queries to read data from the database
  • Input:
    • query (string): The SELECT SQL query to execute
  • Returns: Query results as array of objects

Schema Tools

• list_db

  • Lists all databases in the Teradata system
  • Returns: List of databases

• list_objects

  • Lists objects in a database
  • Input:
    • db_name (string): Database name
  • Returns: List of database objects under provided or user defaul database

• show_tables

  • Show detailed information about a database tables
  • Input:
  • table_name (string): Name of the table
  • Returns: Array of column names and data types

Analysis Tools

• list_missing_values
  • Lists the top features with missing values in a table
• list_negative_values
  • Lists how many features have negative values in a table
• list_distinct_values
  • Lists how many distinct categories are there for column in the table
• standard_deviation
  • What is the mean and standard deviation for column in table?

Usage with Claude Desktop

uv

# 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"
      }
    }
  }
}

Usage as API container

Make sure to edit docker-compose.yml and update environment variable

docker compose build
docker compose up

Building

UV:

uv build

License

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.