Frequently Asked Questions about the Teradata MCP Server on UBOS

Q: What is an MCP Server? A: MCP (Model Context Protocol) is an open protocol that standardizes how applications provide context to Large Language Models (LLMs). An MCP server acts as a bridge, enabling AI models to access and interact with external data sources and tools, such as a Teradata database.

Q: What is the Teradata MCP Server used for? A: The Teradata MCP Server allows AI agents and LLMs to interact with a Teradata database. It enables executing SQL queries, analyzing business data, and integrating Teradata data into AI-powered workflows.

Q: What tools are included with the Teradata MCP Server? A: The server includes tools for querying (query), schema exploration (list_db, list_objects, show_tables), and basic data analysis (list_missing_values, list_negative_values, list_distinct_values, standard_deviation).

Q: How do I integrate the Teradata MCP Server with UBOS? A: You configure the server in your claude_desktop_config.json file, build the server using uv build, and then develop AI agents that utilize the server’s tools to interact with your Teradata database. See the ‘Integrating with the UBOS Platform’ section in the overview for full instructions.

Q: What are the benefits of using the Teradata MCP Server with UBOS? A: Benefits include seamless integration with the UBOS platform, secure data access, scalability, cost-effectiveness, simplified AI agent development, and enhanced data governance.

Q: What kind of data analysis can I perform with the analysis tools? A: The analysis tools provide basic descriptive statistics such as identifying missing values, negative values, the count of distinct values per column, and standard deviations. These are all useful steps to perform during the data cleaning and preprocessing stages.

Q: What license is the Teradata MCP Server released under? A: The Teradata MCP Server is licensed under the MIT License, meaning it is free to use, modify, and distribute, subject to the terms and conditions of that license.

Q: How does the Teradata MCP server ensure data security? A: The server relies on the security measures implemented by Teradata and the UBOS platform. Configure secure connections (e.g., using SSL) and manage access control within Teradata. The MCP server itself provides a controlled interface and only executes queries that the connected user has permissions for.

Q: Can I use the Teradata MCP server with other databases besides Teradata? A: No, this specific MCP server is designed exclusively for Teradata databases. UBOS may offer other MCP servers for different database systems.