Teradata

by Teradata

51 stars

191 downloads

Not rated

GitHub

About

A collection of tools for managing the platform, addressing data quality and reading and writing to [Teradata](https://www.teradata.com/) Database.

Details

Author: Teradata
GitHub stars: 51
Downloads: 191
Categories: Developer Tools, Database, Other

- Query and analyze tables without writing SQL
- Create custom semantic layers from YAML files
- Semantic search and retrieval-augmented generation
- Database administration including security and backup tools
- Configurable row limit protection against token overflow
- Hooks capability for custom monitoring and audit trails

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below

Plugin Name Teradata

Command (node, npx, python, etc.)

Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

From the repository

Install via uvx and configure with a DATABASE_URI environment variable in your client’s MCP settings (e.g., Claude Desktop claude_desktop_config.json). No local installation is required—just add the JSON entry with "command": "uvx" and "args": ["teradata-mcp-server"]. You can also run it as an HTTP server, Docker container, or cloud service.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "teradata": {
            "teradata": {
                "command": "uvx",
                "args": [
                    "teradata-mcp-server"
                ],
                "env": {
                    "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
                }
            }
        }
    }
}

McpServers

{
    "teradata": {
        "command": "uvx",
        "args": [
            "teradata-mcp-server"
        ],
        "env": {
            "DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
        }
    }
}

<p align="center">
<h1>Teradata MCP Server</h1>

<a href="https://github.com/Teradata/teradata-mcp-server/blob/main/docs/README.md">

</a>
<a href="https://github.com/Teradata/teradata-mcp-server/releases">
release
</a>
<a href="https://pypi.org/project/teradata-mcp-server/">
PyPI
</a>
<a href="https://pypi.org/project/teradata-mcp-server/">
downloads
</a>

<p>Connect AI agents directly to Teradata with enterprise security and extensibility.</p>
</p>

Teradata MCP Server architecture

Quick Start (Choose Your Path)

| Client | Best For | Setup Time |
|---|---|---|
| Claude Desktop | Exploratory analysis, platform admin | 5 min |
| VS Code + Copilot | Data engineering, agent development | 5 min |
| Open WebUI | Testing new LLMs locally | 5 min |
| Code Examples | Build your own client | varies |
| Flowise | 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>"
      }
    }
  }
}

What You Can Do

| Use Case | Capabilities | Tools |
|---|---|---|
| Query & Analyze | Explore tables, profile data, explain results, visualize patterns—no SQL needed | base, dba, qlty, plot |
| Semantic Layer | Generate custom semantic layers and tools from YAML or with our Agent Skill | Learn more → |
| AI & RAG Pipelines | Semantic search, retrieval-augmented generation, vector storage | rag, tdvs, fs |
| Database Admin | Manage security, monitor capacity, automate backups | dba, sec, bar |

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 overflow
- Enhanced 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.

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

About

Details

Jump to

Setting up with Highlight

From the repository

Claude Desktop / Cursor

McpServers

Quick Start (Choose Your Path)

Claude Desktop Setup (No Installation)

What You Can Do

What's New (Latest Release)

Extend & Deploy

See It In Action

Learn More

Contributing

Install

More like this

Sequential Thinking

Redis

Sentry

Github

Filesystem

EverArt