teradata-mcp-server
Verified Safeby Teradata
Overview
A comprehensive Model Context Protocol (MCP) server for Teradata, exposing a rich suite of database administration, data quality, security, SQL optimization, vector store, plotting, backup/restore, feature store, and LLM chat/RAG capabilities as MCP tools for client applications like AI agents.
Installation
uv run python -m teradata_mcp_server.server --mcp_transport streamable-http --mcp_port 8001 --auth_mode noneEnvironment Variables
- DATABASE_URI
- MCP_TRANSPORT
- MCP_PORT
- TD_VS_BASE_URL
- DSA_BASE_URL
- DSA_USERNAME
- DSA_PASSWORD
- CHAT_API_KEY
Security Notes
The `eval` function in `src/teradata_mcp_server/utils.py` is used with a restricted namespace, limiting direct arbitrary code execution risk. However, `src/teradata_mcp_server/tools/bar/dsa_client.py` sets default `DSA_USERNAME='admin'` and `DSA_PASSWORD='admin'` if not overridden by environment variables, posing a critical security vulnerability if deployed in production. The `chat_tools.py` can be configured with `ignore_https_verification=True` for external LLM calls, which is an insecure option. Authentication attempts are rate-limited.
Similar Servers
dbhub
A database gateway that exposes SQL data sources via a RESTful API and the Model Context Protocol (MCP), enabling structured interaction with multiple database types.
tiger-cli
Tiger CLI provides a Model Context Protocol (MCP) server that enables AI assistants to interact with Tiger Cloud database services, manage service lifecycles, execute SQL queries, and access documentation via proxied tools.
mcp_ohmy_sql-project
A Model Context Protocol (MCP) server that connects AI assistants to various SQL databases, providing intelligent query optimization, schema introspection, and secure, token-efficient data interaction.
teradata-qg-mcp-server
The Teradata QueryGrid MCP Server provides a Model Context Protocol (MCP) interface, built with FastMCP, to programmatically interact with and manage Teradata QueryGrid Manager resources. It enables AI assistants and other MCP clients to perform comprehensive CRUD and operational tasks on QueryGrid resources.