What is Teradata Enterprise MCP - Teradata Enterprise MCP

Teradata Enterprise MCP is an implementation of the Model Context Protocol that connects MCP clients to Teradata databases through a standardized interface. It allows the MCP clients to query data, run analytics, and perform database operations using natural language, with no SQL expertise required.

Enterprise MCP provides the following capabilities:

• Database Connectivity

  Teradata Enterprise MCP looks at one database host. It allows efficient use of connections, while reducing overhead and providing predictable behavior for operations performed through the server.

• Multi-User Connectivity
  • Multiple users can simultaneously connect to the same MCP server.
  • Each user interaction is handled independently.
  • Every request to the MCP server requires an authorization token.
• Secure Database Access
  • Enterprise authentication and authorization: Supports JWT tokens, TD2 (username/password), and LDAP integration for verifying user identity (see Authentication Methods for Enterprise MCP)
  • Role-Based Access Control (RBAC) for fine-grained permissions based on database roles, ensuring users only access tools appropriate for their responsibilities (see Role-based access control (RBAC))
  • Encrypted connections to Teradata systems: MCP server runs in streamable HTTP mode. Users can enable SSL/TLS encryption for client-to-MCP communication by setting MCP_SSL_ENABLED=true (see Environment Variable Configuration (not for AI Studio & AI Studio Lite)). Communication between MCP server and Teradata database uses encrypted connections.
• Comprehensive Tool Library
  To determine which MCP tools are supported for your Enterprise MCP version, see MCP Tools Compatibility Matrix.
  • Base Tools: Execute SQL queries, retrieve metadata, explore database objects, and perform fundamental database operations (see Base MCP Tools)
  • DBA Tools: Tools for database administrators (see DBA MCP Tools)
  • Security Tools: Audit user permissions, review role assignments, and analyze access rights (see Security Tools)
  • Teradata Analytics Tools: Leverage Teradata's advanced machine learning and statistical analysis functions for data science workflows (see Teradata Analytics Tools)
  • Vector Store Tools: Create, manage, and query vector stores for AI-powered semantic search and retrieval-augmented generation (RAG) (see Teradata Vector Store MCP Tools)
• Flexible Integration
  • Compatibility with MCP-compatible clients.
  • Support for common AI frameworks.