Teradata
Enables AI agents and users to query, analyze, and manage Teradata databases through modular tools for search, data quality, administration, and data science operations. Provides comprehensive database interaction capabilities including RAG applicati
What is Teradata?
Teradata is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to enables ai agents and users to query, analyze, and manage teradata databases through modular tools for search, data quality, administration, and data science operations. provides comprehensive databas...
Enables AI agents and users to query, analyze, and manage Teradata databases through modular tools for search, data quality, administration, and data science operations. Provides comprehensive database interaction capabilities including RAG applicati
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- Enables AI agents and users to query, analyze, and manage Te
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx teradata-mcp-serverConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Teradata
The Teradata MCP Server enables AI agents and users to query, analyse, and manage Teradata databases through a rich set of modular tools covering search, data quality, administration, and data science operations including vector stores and ML functions. It provides comprehensive database interaction — from browsing schemas and running ad-hoc SQL to executing data quality checks and managing RAG (Retrieval-Augmented Generation) pipelines — all through natural language via an MCP-compatible client. Built by Teradata's own team and packaged for `uv`, it connects in under five minutes and exposes a consistent interface whether you are a DBA, data scientist, or analyst.
Prerequisites
- Python 3.10+ and the `uv` package manager (brew install uv on macOS, pip install uv on other platforms)
- A running Teradata database with a hostname, port 1025, username, and password
- Network connectivity from your machine to the Teradata host on port 1025
- Claude Desktop or another MCP-compatible AI client
- Sufficient database permissions for the operations you intend to perform (read-only for queries, admin role for DBA tools)
Install the uv package manager
The server is distributed via PyPI and best run with `uv` for fast, isolated package management. Install it before proceeding.
# macOS
brew install uv
# Windows / Linux
pip install uvVerify the server package is available
Run the server once with `uvx` to trigger a package download and confirm it starts without errors. Press Ctrl+C to stop.
uvx teradata-mcp-serverBuild your DATABASE_URI
The server requires a single DATABASE_URI environment variable. Construct it from your Teradata credentials using the standard format.
# Format
teradata://<USERNAME>:<PASSWORD>@<HOST>:1025/<DATABASE>
# Example
teradata://analyst:[email protected]:1025/analytics_dbConfigure Claude Desktop
Open Settings > Developer > Edit Config in Claude Desktop and add the Teradata server block. Set the DATABASE_URI to your actual connection string.
{
"mcpServers": {
"teradata-mcp-server": {
"command": "uvx",
"args": ["teradata-mcp-server"],
"env": {
"DATABASE_URI": "teradata://analyst:[email protected]:1025/analytics_db"
}
}
}
}Restart Claude Desktop and explore tools
Fully quit and relaunch Claude Desktop. Open a new conversation and verify the Teradata tools are listed in the tools panel — you should see tools grouped across Query, Search, Table, Data Quality, DBA, and Data Scientist categories.
Run a data quality check
Test the integration by asking Claude to perform a data quality analysis on a table you know exists in the database.
Teradata Examples
Client configuration
Complete claude_desktop_config.json block for the Teradata MCP Server using uvx.
{
"mcpServers": {
"teradata-mcp-server": {
"command": "uvx",
"args": ["teradata-mcp-server"],
"env": {
"DATABASE_URI": "teradata://myuser:[email protected]:1025/mydb"
}
}
}
}Prompts to try
Example queries covering the full range of Teradata MCP Server capabilities.
- "List all tables in the analytics schema and show their row counts."
- "Run a data quality report on the customer_master table — identify nulls, duplicates, and outliers."
- "Create a vector store from the product_descriptions column so I can run semantic search queries."
- "Who are the current database users and what are their access privileges?"
- "Find all tables related to 'sales' using semantic search across the schema."
- "Run the backup status check using the BAR tools and summarise the last 7 days of backup jobs."Troubleshooting Teradata
Server starts but immediately exits with a connection error
Verify the DATABASE_URI format is exactly 'teradata://user:pass@host:1025/database' — the port 1025 and the protocol prefix are both required. Test network connectivity with 'telnet <host> 1025' or a Teradata client before debugging the MCP config.
DBA tools return permission denied errors
The Teradata user in your DATABASE_URI needs appropriate database permissions. For DBA tools, the user typically needs SYSADMIN or equivalent role. Use a read-only user for query-only access and a privileged user when administrative tools are needed.
Claude Desktop shows no Teradata tools after configuration
Validate the JSON syntax in claude_desktop_config.json using a JSON linter. Fully quit Claude (not just close the window) via the system tray or Activity Monitor, then relaunch. Check Claude's developer console for startup errors from uvx.
Frequently Asked Questions about Teradata
What is Teradata?
Teradata is a Model Context Protocol (MCP) server that enables ai agents and users to query, analyze, and manage teradata databases through modular tools for search, data quality, administration, and data science operations. provides comprehensive database interaction capabilities including rag applicati It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Teradata?
Follow the installation instructions on the Teradata GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Teradata?
Teradata works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Teradata free to use?
Yes, Teradata is open source and available under the MIT License license. You can use it freely in both personal and commercial projects.
Teradata Alternatives — Similar Databases Servers
Looking for alternatives to Teradata? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Teradata in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Teradata?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.