Skip to main content
Glama
arturborycki

Teradata MCP Server

by arturborycki
OverviewSchemaRelated ServersScoreDiscussions
Python
Remote

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MCP_HOSTNoHost address for MCP server (e.g., 0.0.0.0)
MCP_PATHNoPath for MCP server when using streamable-http transport (e.g., /mcp/)
MCP_PORTNoPort number for MCP server (e.g., 8000)
LOG_LEVELNoLogging level (e.g., DEBUG, INFO, WARNING, ERROR)
DATABASE_URIYesDatabase connection URI in format: teradatasql://username:password@hostname/database
KEYCLOAK_URLNoKeycloak server URL (e.g., https://keycloak.example.com)
MCP_TRANSPORTNoMCP transport method (sse, streamable-http, or stdio)
OAUTH_ENABLEDNoEnable OAuth authentication (true/false)
KEYCLOAK_REALMNoKeycloak realm name (e.g., teradata-realm)
KEYCLOAK_CLIENT_IDNoKeycloak client ID (e.g., teradata-mcp)
OAUTH_REQUIRE_HTTPSNoRequire HTTPS for OAuth endpoints (true/false)
OAUTH_REQUIRED_SCOPESNoOptional: Required scopes (comma-separated, e.g., teradata:read,teradata:query)
OAUTH_VALIDATE_SCOPESNoWhether to validate token scopes (true/false)
KEYCLOAK_CLIENT_SECRETNoKeycloak client secret
OAUTH_VALIDATE_AUDIENCENoWhether to validate token audience (true/false)
TOOL_RETRY_MAX_ATTEMPTSNoNumber of retry attempts for database connections (default: 1)1
TOOL_RETRY_DELAY_SECONDSNoDelay between retry attempts in seconds (default: 1.0)1.0
OAUTH_RESOURCE_SERVER_URLNoResource server identification URL (e.g., https://your-mcp-server.com)

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": false
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
queryC

Executes a SQL query against the Teradata database

list_dbB

List all databases in the Teradata system

list_tablesC

List tables in a database

show_tables_detailsC

Show detailed information about a database tables

list_missing_valuesC

What are the top features with missing values in a table

list_negative_valuesC

How many features have negative values in a table

list_distinct_valuesC

How many distinct categories are there for column in the table

standard_deviationC

What is the mean and standard deviation for column in table?

Prompts

Interactive templates invoked by user choice

NameDescription
Analyze_databaseA prompt demonstrate how to analyze objects in Teradata database
Analyze_tableA prompt demonstrate how to analyze objects in Teradata database
glmA prompt demonstrate how to train model with GLM in Teradata database

Resources

Contextual data attached and managed by the client

NameDescription
ErrorDatabase connection error: Failed to connect to database after 3 attempts: Connection health check failed

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/arturborycki/mcp-teradata'

If you have feedback or need assistance with the MCP directory API, please join our Discord server