Skip to main content
Version: v1.7.0

Teradata MCP Server

Overview​

Teradata is an enterprise data warehouse platform. The Teradata MCP server enables Enterprise h2oGPTe agents to connect to Teradata databases, run SQL queries, explore schemas, and retrieve data for analytics and reporting.

For more information, visit Teradata.

When to use​

Use this MCP server when you want agents to:

  • Query Teradata tables and views using natural language
  • Explore database schemas and table metadata
  • Run analytical SQL queries as part of agent workflows
  • Combine Teradata data with other enterprise sources in a single conversation

Requirements​

Before configuring this MCP server, ensure you have:

  • Network access to your Teradata instance
  • A valid DATABASE_URI connection string
  • A Teradata user with appropriate permissions on the target databases

Key capabilities​

The Teradata MCP server provides tools to:

  • Run parameterized SQL queries against Teradata
  • List schemas, tables, and table details
  • Execute administrative or maintenance queries (subject to user permissions)

Configuration​

Add the following configuration in Agents > Tools > New Tool > Remote MCP Tools:

{
  "teradata": {
    "setup_commands": [
      "pip install uv",
      "uvx --help > /dev/null 2>&1 || pip install uv --upgrade"
    ],
    "command": "uvx",
    "args": ["teradata-mcp-server", "--profile", "all"],
    "env": {
      "DATABASE_URI": "os.environ/DATABASE_URI"
    }
  }
}

Authentication​

In Agents > Authentication, create a secret with:

  • DATABASE_URI: Teradata connection string (for example, teradata://user:password@host/database)

Notes​

  • This MCP server uses the STDIO transport via uvx.
  • Ensure the Teradata client libraries and network configuration are set up according to your organization’s standards.
Feedback