MCP.so
Sign In

Teradata MCP Server Template

@Teradata

Repository

About Teradata MCP Server Template

The community development of a MCP server for a Teradata database

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Teradata MCP Server?

Teradata MCP Server connects AI agents directly to Teradata databases with enterprise security and extensibility. It enables natural language querying, semantic layers, AI and RAG pipelines, and database administration. This server is for data engineers, analysts, and developers who want to interact with Teradata using AI assistants.

How to use Teradata MCP Server?

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.

Key features of Teradata MCP Server

  • 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

Use cases of Teradata MCP Server

  • Exploratory data analysis via natural language chat (Claude Desktop)
  • Data engineering and agent development with VS Code + Copilot
  • Testing new LLMs locally using Open WebUI
  • Building custom client applications with provided code examples
  • Visual agent building with Flowise drag-and-drop workflows

FAQ from Teradata MCP Server

What is Teradata MCP Server?

It is an MCP server that connects AI agents to Teradata databases, providing tools for querying, semantic layers, AI/RAG pipelines, and database administration.

How do I install Teradata MCP Server?

No local installation is needed—use uvx with a DATABASE_URI environment variable in your client’s MCP configuration. You can also run it via Docker, HTTP server, or as a cloud service.

What are the prerequisites?

A Teradata database (a free sandbox is available) and uv (see uv installation guide). The DATABASE_URI must be set to teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>.

What tools does it include?

It includes tool categories: base (query and analyze), dba (database admin), qlty (data quality), plot (visualization), rag (retrieval-augmented generation), tdvs (vector storage), fs (file system), sec (security), and bar (backup/restore).

Can I extend the server?

Yes. You can add custom logic using hooks (monitoring, audit, validation), define domain-specific semantic layers in YAML, or deploy custom middleware (e.g., performance monitoring patterns).

Frequently asked questions

What is Teradata MCP Server?

It is an MCP server that connects AI agents to Teradata databases, providing tools for querying, semantic layers, AI/RAG pipelines, and database administration.

How do I install Teradata MCP Server?

No local installation is needed—use `uvx` with a `DATABASE_URI` environment variable in your client’s MCP configuration. You can also run it via Docker, HTTP server, or as a cloud service.

What are the prerequisites?

A Teradata database (a free sandbox is available) and `uv` (see uv installation guide). The `DATABASE_URI` must be set to `teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>`.

What tools does it include?

It includes tool categories: **base** (query and analyze), **dba** (database admin), **qlty** (data quality), **plot** (visualization), **rag** (retrieval-augmented generation), **tdvs** (vector storage), **fs** (file system), **sec** (security), and **bar** (backup/restore).

Can I extend the server?

Yes. You can add custom logic using hooks (monitoring, audit, validation), define domain-specific semantic layers in YAML, or deploy custom middleware (e.g., performance monitoring patterns).

Comments

Basic information

Category

Developer Tools

License

MIT

Transports

stdio

Author

Teradata

More Developer Tools MCP servers

TaskerArmy Agent

TaskerArmy

Ask Claude or ChatGPT what Shopify theme optimization tasks are pending on your store, a remote MCP server for TaskerArmy Agent accounts.

DevDocs by CyberAGI 🚀

cyberagiinc

Completely free, private, UI based Tech Documentation MCP server. Designed for coders and software developers in mind. Easily integrate into Cursor, Windsurf, Cline, Roo Code, Claude Desktop App

2.1K

Reelier

Maxime Houle

Agents make claims. Reelier writes receipts — record an agent's tool-call workflow once, replay it deterministically at 0 tokens, and diff runs to catch drift.

mcp-excalidraw

yctimlin

MCP server and Claude Code skill for Excalidraw — programmatic canvas toolkit to create, edit, and export diagrams via AI agents with real-time canvas sync.

2.1K

MCP Containers

metorial

Connect any AI model to 1200+ integrations (MCP, CLI, API)

3.3K