Teradata MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| LOGMECH | No | Authentication mechanism (TD2 or LDAP) | TD2 |
| MCP_HOST | No | Host for HTTP transport | localhost |
| MCP_PORT | No | Port for HTTP transport | 8001 |
| DATABASE_URI | Yes | Connection URI: teradata://user:password@host:1025/database | |
| TD_POOL_SIZE | No | Connection pool size | 5 |
| LOGGING_LEVEL | No | Log level (DEBUG, INFO, WARNING, ERROR) | WARNING |
| MAX_ROW_LIMIT | No | Hard ceiling — callers cannot exceed this | 50000 |
| MCP_TRANSPORT | No | MCP transport (stdio or streamable-http) | stdio |
| TD_MAX_OVERFLOW | No | Extra connections allowed above pool size | 10 |
| TD_POOL_TIMEOUT | No | Timeout to acquire a connection (seconds) | 30 |
| DEFAULT_ROW_LIMIT | No | Default row limit for read_query | 1000 |
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
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| logging | {} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| extensions | {
"io.modelcontextprotocol/ui": {}
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| pingA | Testa a conexão com o servidor Teradata. Executa um SELECT simples e retorna a versão do banco, confirmando que a conexão está ativa e configurada corretamente. |
| read_queryB | Executa uma consulta SQL no Teradata e retorna os resultados. |
| list_tablesA | Lista as tabelas e views de um banco de dados Teradata. |
| table_previewB | Retorna uma amostra das primeiras linhas de uma tabela. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 4 tools
Each tool has a distinct purpose: listing tables, testing connectivity, executing arbitrary queries, and previewing table data. No overlap or ambiguity.
All names use snake_case, but patterns vary: 'ping' is a bare verb, while others combine verb_noun (list_tables, read_query) or noun_verb (table_preview). Minor inconsistency, but still clear.
Only 4 tools for a database server is too few. Essential operations like write, DDL, and transaction control are missing, making the set feel incomplete for the domain.
Covers read-only operations (list, query, preview, test), but lacks write operations, schema manipulation, and more advanced query support. Notable gaps for a full database server.