Teradata
A collection of tools for managing the platform, addressing data quality and reading and writing to Teradata Database.
Ads
Overview
Pre-requisites: Teradata database (or free sandbox) + uv Add this to claude_desktop_config.json (Settings > Developer > Edit Config): - 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 Add Custom Logic Use hooks to intercept tool calls for monitoring, audit trails, or validation → Hooks Guide
Installation
uvx teradata-mcp-server
Configuration
{
"mcpServers": {
"teradata": {
"command": "uvx",
"args": [
"teradata-mcp-server"
],
"env": {
"DATABASE_URI": "teradata://<USERNAME>:<PASSWORD>@<HOST_URL>:1025/<USERNAME>"
}
}
}
}Capabilities
- Explore and profile database tables
Ask the AI to list tables, describe schemas, and summarize data distributions using `base` and `qlty` tools.
- Run analytical queries in plain English
Describe the insight you need and let the assistant generate and execute SQL via `base` tools.
- Visualize query results as charts
Request bar charts, line plots, or other visualizations directly from query output with `plot` tools.
- Manage database security and access
Use `sec` and `dba` tools to review roles, permissions, and row-level security policies.
- Build semantic search and RAG pipelines
Store and query vector embeddings for retrieval-augmented generation using `rag` and `tdvs` tools.
Tags
- database
- sql
- data-analysis
Related MCP servers
InstantDB
OfficialCreate, manage, and update applications on InstantDB, the modern Firebase.
Jitsu
OfficialManage Jitsu data pipelines from your AI assistant — destinations, streams, connections, syncs, functions, and live events.
PostgreSQL MCP Server
OfficialRun read-only SQL queries and inspect PostgreSQL schemas from your MCP client.
Financial Datasets
OfficialStock market API made for AI agents