Teradata MCP Server

by arturborycki

172 downloads

Not rated

GitHub

About

Interact with Teradata databases for data queries and business intelligence.

Details

Author: arturborycki
Downloads: 172
Categories: Database, Other

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below

Plugin Name Teradata MCP Server

Command (node, npx, python, etc.)

Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

From the repository

Configure the server in your Claude Desktop configuration file (claude_desktop_config.json) by specifying the uv command and environment variable DATABASE_URI pointing to your Teradata instance. Then you can invoke the provided tools (e.g., query, list_db, show_tables) through Claude.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "teradata mcp server": {
            "mcp-teradata": {
                "command": "uv",
                "args": [
                    "build"
                ]
            }
        }
    }
}

McpServers

{
    "mcp-teradata": {
        "command": "uv",
        "args": [
            "build"
        ]
    }
}

Interact with Teradata databases for data queries and business intelligence.

A Model Context Protocol (MCP) server for Teradata database with OAuth 2.1 authentication, multiple authentication mechanisms (TD2, LDAP, Kerberos), and interactive data visualization.

- Multiple Auth Mechanisms— TD2 (default), LDAP, Kerberos, JWT via TeradataLOGMECH
- OAuth 2.1with Keycloak integration, JWT validation, scope-based authorization
- Protected Resource Metadata(RFC 9728 compliant)
- Interactive Visualization— ECharts-based MCP App with 19 chart types
- Connection Resilience— automatic retry with exponential backoff
- Non-blocking I/O— all DB operations run viaasyncio.to_thread()
- Per-tool QueryBand— audit trail for Teradata workload management

- query— Execute SQL queries, return plain tabular results
- visualize_query— Execute SQL and render interactive ECharts charts via MCP App

- list_db— List all databases
- list_tables— List tables/views in a database
- show_tables_details— Show column names and types for a table

- list_missing_values— Columns with NULL value counts
- list_negative_values— Columns with negative value counts
- list_distinct_values— Distinct category counts per column
- standard_deviation— Mean and standard deviation for a column

Thevisualize_querytool renders results as interactive charts in the MCP client.

git clone https://github.com/arturborycki/mcp-teradata.git cd mcp-teradata uv sync

uv run teradata-mcp "teradatasql://user:password@host/database"

export DATABASE_URI="teradatasql://user:password@host/database" uv run teradata-mcp

Add to yourclaude_desktop_config.json:

{ "mcpServers": { "teradata": { "command": "uv", "args": [ "--directory", "/path/to/mcp-teradata", "run", "teradata-mcp" ], "env": { "DATABASE_URI": "teradatasql://user:password@host/database" } } } }

{ "mcpServers": { "teradata": { "command": "uv", "args": [ "--directory", "/path/to/mcp-teradata", "run", "teradata-mcp" ], "env": { "DATABASE_URI": "teradatasql://@host/database", "DB_LOGMECH": "LDAP", "DB_LOGDATA": "authcid=ldap_user password=ldap_password" } } } }

Theauthcidformat depends on the LDAP directory:

{ "mcpServers": { "teradata": { "command": "uv", "args": [ "--directory", "/path/to/mcp-teradata", "run", "teradata-mcp" ], "env": { "DATABASE_URI": "teradatasql://@host/database", "DB_LOGMECH": "KRB5" } } } }

{ "mcpServers": { "teradata": { "command": "uv", "args": [ "--directory", "/path/to/mcp-teradata", "run", "teradata-mcp" ], "env": { "DATABASE_URI": "teradatasql://user:password@host/database", "OAUTH_ENABLED": "true", "KEYCLOAK_URL": "https://your-keycloak.example.com", "KEYCLOAK_REALM": "teradata-realm", "KEYCLOAK_CLIENT_ID": "teradata-mcp", "KEYCLOAK_CLIENT_SECRET": "your-secret", "OAUTH_RESOURCE_SERVER_URL": "https://your-mcp-server.example.com" } } } }

Discovery endpoints (when OAuth enabled):

- /.well-known/oauth-protected-resource— RFC 9728 metadata
- /.well-known/mcp-server-info— MCP capabilities
- /health— Health check

docker compose -f docker-compose.oauth.yml up -d

- VerifyDATABASE_URIformat:teradatasql://user:pass@host/database
- Check network connectivity to Teradata server
- For LDAP: ensureDB_LOGMECH=LDAPandDB_LOGDATAare set correctly
- Connection issues are automatically retried (configurable viaDB_MAX_RETRIES)

- Verify the Teradata server has LDAP configured in TDGSS
- Checkauthcidformat matches your directory type
- Escape special characters in passwords (@→\@, spaces → use quotes)

- Verify user has required OAuth scopes
- Check Keycloak role assignments
- visualize_queryrequiresteradata:queryscope (not justteradata:read)

export LOG_LEVEL=DEBUG uv run teradata-mcp

- Model Context Protocol
- Keycloak
- Teradata
- FastMCP

Manage Apache Superset datasets, metrics, and SQL queries.

Official MCP server for dbt (data build tool) providing integration with dbt Core/Cloud CLI, project metadata discovery, model information, and semantic layer querying capabilities.

Query and analyze data with MotherDuck and local DuckDB

A collection of tools for managing the platform, addressing data quality and reading and writing to Teradata Database.

A read-only MCP server for Avro data sources, powered by the CData JDBC Driver.

Run SQL queries on data in Amazon S3 using AWS Athena.

Connect SAP Business One (SQL Server) to Claude AI Desktop via MCP. Query financials, inventory, sales, and purchasing with natural language.

Interact with Bauplan data tables and run queries.

Production-grade MCP server for Databricks: SQL Warehouses, Jobs API, multi-workspace support.

Visual no-code generator that turns any database into multiple scoped MCP servers — one per access group, with PII masking and fail-closed query scoping built in.

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

Teradata MCP Server

About

Details

Jump to

Setting up with Highlight

Setting up with Cursor

JSON

JSON

JSON

Setting up with Claude Desktop

JSON

JSON

JSON

Setting up with Windsurf

JSON

JSON

JSON

Setting up with Cline

JSON

JSON

JSON

Setting up with Goose

JSON

JSON

JSON

From the repository

Claude Desktop / Cursor

McpServers

Install

About

Details

Jump to

Setting up with Highlight

From the repository

Claude Desktop / Cursor

McpServers

Install

More like this

Sequential Thinking

Redis

Filesystem

EverArt

Google Drive

Sqlite