Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MCP_HOST | No | Host address for MCP server (e.g., 0.0.0.0) | |
| MCP_PATH | No | Path for MCP server when using streamable-http transport (e.g., /mcp/) | |
| MCP_PORT | No | Port number for MCP server (e.g., 8000) | |
| LOG_LEVEL | No | Logging level (e.g., DEBUG, INFO, WARNING, ERROR) | |
| DATABASE_URI | Yes | Database connection URI in format: teradatasql://username:password@hostname/database | |
| KEYCLOAK_URL | No | Keycloak server URL (e.g., https://keycloak.example.com) | |
| MCP_TRANSPORT | No | MCP transport method (sse, streamable-http, or stdio) | |
| OAUTH_ENABLED | No | Enable OAuth authentication (true/false) | |
| KEYCLOAK_REALM | No | Keycloak realm name (e.g., teradata-realm) | |
| KEYCLOAK_CLIENT_ID | No | Keycloak client ID (e.g., teradata-mcp) | |
| OAUTH_REQUIRE_HTTPS | No | Require HTTPS for OAuth endpoints (true/false) | |
| OAUTH_REQUIRED_SCOPES | No | Optional: Required scopes (comma-separated, e.g., teradata:read,teradata:query) | |
| OAUTH_VALIDATE_SCOPES | No | Whether to validate token scopes (true/false) | |
| KEYCLOAK_CLIENT_SECRET | No | Keycloak client secret | |
| OAUTH_VALIDATE_AUDIENCE | No | Whether to validate token audience (true/false) | |
| TOOL_RETRY_MAX_ATTEMPTS | No | Number of retry attempts for database connections (default: 1) | 1 |
| TOOL_RETRY_DELAY_SECONDS | No | Delay between retry attempts in seconds (default: 1.0) | 1.0 |
| OAUTH_RESOURCE_SERVER_URL | No | Resource server identification URL (e.g., https://your-mcp-server.com) |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| query | Executes a SQL query against the Teradata database |
| list_db | List all databases in the Teradata system |
| list_tables | List tables in a database |
| show_tables_details | Show detailed information about a database tables |
| list_missing_values | What are the top features with missing values in a table |
| list_negative_values | How many features have negative values in a table |
| list_distinct_values | How many distinct categories are there for column in the table |
| standard_deviation | What is the mean and standard deviation for column in table? |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| Analyze_database | A prompt demonstrate how to analyze objects in Teradata database |
| Analyze_table | A prompt demonstrate how to analyze objects in Teradata database |
| glm | A prompt demonstrate how to train model with GLM in Teradata database |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| Error | Database connection error: Failed to connect to database after 3 attempts: Connection health check failed |