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
  • 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

• 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

• 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?

# 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.