Teradata MCP Server
OfficialThe Teradata MCP Server is a comprehensive tool for managing, querying, and analyzing Teradata databases. Key capabilities include:
Query Execution: Run both
Enables configuration management through environment variables stored in .env files, supporting database connection parameters, LLM credentials, and server settings.
Supports integration with OpenAI models through API key configuration, enabling LLM capabilities within the server environment.
Provides database interaction capabilities with Teradata systems, offering tools for querying, data quality assessment, and database administration tasks such as executing queries, retrieving table structures, analyzing space usage, and performing data quality checks.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Teradata MCP Servershow me the top 10 customers by total sales this month"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Quick Start (Choose Your Path)
Client | Best For | Setup Time |
Exploratory analysis, platform admin | 5 min | |
Data engineering, agent development | 5 min | |
Testing new LLMs locally | 5 min | |
Build your own client | varies | |
Visual agent builder | 10 min |
Pre-requisites: Teradata database (or free sandbox) + uv
Claude Desktop Setup (No Installation)
Add this to claude_desktop_config.json (Settings > Developer > Edit Config):
{
"mcpServers": {
"teradata": {
"command": "uvx",
"args": ["teradata-mcp-server"],
"env": {
"DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
}
}
}
}Related MCP server: Teradata Workload Management (WLM) MCP Server
What You Can Do
Use Case | Capabilities | Tools |
Query & Analyze | Explore tables, profile data, explain results, visualize patterns—no SQL needed | |
AI & RAG Pipelines | Semantic search, retrieval-augmented generation, vector storage | |
Database Admin | Manage security, monitor capacity, automate backups | |
Custom Logic | Define domain tools, metrics, and semantic layers in YAML |
What's New (Latest Release)
FastMCP v3 — Guaranteed resource cleanup with improved lifespan management
Hooks Capability — Intercept tool calls for custom monitoring, audit, or rate-limiting
Row Limit Protection — Configurable caps (
DEFAULT_ROW_LIMIT,MAX_ROW_LIMIT) prevent LLM token overflowEnhanced Security — VX views for fine-grained row-level access control
Extend & Deploy
Add Custom Logic
Use hooks to intercept tool calls for monitoring, audit trails, or validation → Hooks Guide
Define Semantic Layers
Create domain-specific tools, prompts, and cubes in YAML → Customization Guide
Deploy Everywhere
Run as CLI (uv), HTTP server, Docker container, or cloud service → Installation Guide
See It In Action
Voice Agent — Real-time bidirectional audio with Amazon Nova Sonic
Web Agent — Interactive chat UI with Google ADK framework
Flowise Builder — Visual drag-and-drop workflows
Custom Middleware — Performance monitoring patterns
Learn More
Full Documentation — Installation, configuration, architecture, security
Video Tutorials — Step-by-step walkthroughs
Developer Guide — Extend and contribute
Architecture — How components work together
Contributing
We welcome contributions! See our Contributing Guide and Developer Guide to get started.
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/Teradata/teradata-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server