Teradata Database
The community development of a MCP server for a Teradata database
What is Teradata Database?
Teradata Database is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to community development of a mcp server for a teradata database
The community development of a MCP server for a Teradata database
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- The community development of a MCP server for a Teradata dat
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx teradataConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Teradata Database
The Teradata MCP Server connects AI agents like Claude directly to Teradata databases, enabling natural-language querying, data quality analysis, and administrative tasks without writing raw SQL. It organises capabilities into focused modules — Query, Search (RAG/vector), Table, Data Quality, DBA, and Data Scientist — so teams can use AI for everything from routine database navigation to ML model workflows. If you manage large-scale Teradata environments and want to ask questions in plain English rather than T-SQL, this server bridges that gap in under five minutes using the `uv` package manager.
Prerequisites
- Python 3.10+ and the `uv` package manager (brew install uv on macOS, pip install uv elsewhere)
- A running Teradata database instance with a valid hostname, username, and password
- Network access from your machine to the Teradata host on port 1025
- Claude Desktop (or another MCP-compatible client) installed and configured
- Teradata credentials with sufficient privileges for the operations you want to perform
Install the uv package manager
The Teradata MCP Server is distributed as a Python package and uses `uv` for fast, isolated execution. Install it before anything else.
# macOS
brew install uv
# Windows / Linux
pip install uvTest the server runs
Run the server once with `uvx` to confirm the package installs correctly. You should see it start and wait for a connection; press Ctrl+C to stop.
uvx teradata-mcp-serverGather your DATABASE_URI connection string
The server uses a single `DATABASE_URI` environment variable to connect to Teradata. Build your URI from your credentials.
# Format
teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<DATABASE>
# Example
teradata://myuser:[email protected]:1025/mydbAdd the server to Claude Desktop
Open Claude Desktop and navigate to Settings > Developer > Edit Config. Add the server block below, replacing the DATABASE_URI value with your actual connection string.
{
"mcpServers": {
"teradata": {
"command": "uvx",
"args": ["teradata-mcp-server"],
"env": {
"DATABASE_URI": "teradata://myuser:[email protected]:1025/mydb"
}
}
}
}Restart Claude Desktop and verify
Save the config file and fully quit and relaunch Claude Desktop. Open a new conversation — you should see the Teradata tools available in the tools panel.
Run your first query
Start a conversation in Claude and ask a natural-language question about your Teradata database to confirm everything works end-to-end.
Teradata Database Examples
Client configuration
Complete claude_desktop_config.json block for the Teradata MCP Server using uvx.
{
"mcpServers": {
"teradata": {
"command": "uvx",
"args": ["teradata-mcp-server"],
"env": {
"DATABASE_URI": "teradata://myuser:[email protected]:1025/mydb"
}
}
}
}Prompts to try
Example questions to ask Claude once the Teradata MCP Server is connected.
- "List all tables in the sales database and describe their schemas."
- "Run a data quality check on the customer_orders table and flag any nulls in required columns."
- "What are the top 10 products by revenue this quarter? Query the transactions table."
- "Show me the current DBA users and their roles on this Teradata system."
- "Create a vector store from the product_descriptions table so I can run semantic search on it."Troubleshooting Teradata Database
Connection refused or timeout when the server starts
Double-check the host, port (1025), username, and password in your DATABASE_URI. Ensure your network allows outbound TCP to port 1025 on the Teradata host — firewalls often block this by default.
`uvx` command not found after installation
Ensure `uv` is installed correctly and its bin directory is on your PATH. Run `which uv` (macOS/Linux) or `where uv` (Windows) to confirm. If missing, reinstall via `pip install uv` or via Homebrew, then open a new terminal session.
Claude does not show Teradata tools after editing the config
Confirm the JSON in claude_desktop_config.json is valid (no trailing commas, properly quoted strings). Fully quit Claude Desktop (not just close the window) and relaunch. Check Claude's developer logs for startup errors.
Frequently Asked Questions about Teradata Database
What is Teradata Database?
Teradata Database is a Model Context Protocol (MCP) server that community development of a mcp server for a teradata database It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Teradata Database?
Follow the installation instructions on the Teradata Database GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with Teradata Database?
Teradata Database works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Teradata Database free to use?
Yes, Teradata Database is open source and available under the MIT license. You can use it freely in both personal and commercial projects.
Teradata Database Alternatives — Similar Databases Servers
Looking for alternatives to Teradata Database? 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 Database 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 Database?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.