Teradata Mcp Server

Teradata MCP Server

Connect AI agents directly to Teradata with enterprise security and extensibility.

Quick Start (Choose Your Path)

| Client | Best For | Setup Time | |---|---|---| | [Claude Desktop](docs/serverguide/QUICKSTART.md) | Exploratory analysis, platform admin | 5 min | | [VS Code + Copilot](docs/serverguide/QUICKSTARTVSCODE.md) | Data engineering, agent development | 5 min | | [Open WebUI](docs/serverguide/QUICKSTARTOPENWEBUI.md) | Testing new LLMs locally | 5 min | | [Code Examples](examples/README.md#client-applications) | Build your own client | varies | | [Flowise](docs/clientguide/FlowisewithteradatamcpGuide.md) | 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://:@:1025/"
      }
    }
  }
}

What You Can Do

| Use Case | Capabilities | Tools | |---|---|---| | Query & Analyze | Explore tables, profile data, explain results, visualize patterns—no SQL needed | [base](src/teradatamcpserver/tools/base/README.md), [dba](src/teradatamcpserver/tools/dba/README.md), [qlty](src/teradatamcpserver/tools/qlty/README.md), [plot](src/teradatamcpserver/tools/plot/README.md) | | AI & RAG Pipelines | Semantic search, retrieval-augmented generation, vector storage | [rag](src/teradatamcpserver/tools/rag/README.md), [tdvs](src/teradatamcpserver/tools/tdvs/README.md), [fs](src/teradatamcpserver/tools/fs/README.md) | | Database Admin | Manage security, monitor capacity, automate backups | [dba](src/teradatamcpserver/tools/dba/README.md), [sec](src/teradatamcpserver/tools/sec/README.md), [bar](src/teradatamcpserver/tools/bar/README.md) | | Custom Logic | Define domain tools, metrics, and semantic layers in YAML | [Learn more →](docs/server_guide/CUSTOMIZING.md) |

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](docs/developer_guide/HOOKS.md)

Define Semantic Layers Create domain-specific tools, prompts, and cubes in YAML → [Customization Guide](docs/server_guide/CUSTOMIZING.md)

Deploy Everywhere Run as CLI (uv), HTTP server, Docker container, or cloud service → [Installation Guide](docs/server_guide/INSTALLATION.md)

See It In Action

• [Voice Agent](examples/app-voice-agent/) — Real-time bidirectional audio with Amazon Nova Sonic
• [Web Agent](examples/app-adk-agent/) — Interactive chat UI with Google ADK framework
• [Flowise Builder](examples/app-flowise/) — Visual drag-and-drop workflows
• [Custom Middleware](examples/server-customisation/server-hooks/) — Performance monitoring patterns

Learn More

• [Full Documentation](docs/README.md) — Installation, configuration, architecture, security
• [Video Tutorials](docs/serverguide/VIDEOLIBRARY.md) — Step-by-step walkthroughs
• [Developer Guide](docs/developerguide/DEVELOPERGUIDE.md) — Extend and contribute
• [Architecture](docs/server_guide/ARCHITECTURE.md) — How components work together

Contributing

We welcome contributions! See our [Contributing Guide](docs/developerguide/CONTRIBUTING.md) and [Developer Guide](docs/developerguide/DEVELOPER_GUIDE.md) to get started.

Source & license

This open-source MCP server is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: Teradata
• Source: Teradata/teradata-mcp-server
• License: MIT

Install and usage instructions live in the source repository linked above.