TDengine Query MCP Server

Name: TDengine Query MCP Server
Author: Abeautifulsnow

@Abeautifulsnow

代码仓库

关于 TDengine Query MCP Server

TDengine MCP Server.

#tdengine

基本信息

分类

其他

许可证

MIT

运行时

python

传输方式

stdio

发布者

Abeautifulsnow

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "tdengine": {
      "command": "uvx",
      "args": [
        "tdengine-mcp-server",
        "-th",
        "YOUR_TDengine_HOST",
        "-tu",
        "YOUR_TDengine_USERNAME",
        "-pwd",
        "YOUR_TDengine_PASSWORD",
        "-db",
        "YOUR_TDengine_DATABASE",
        "-ll",
        "debug",
        "-trans",
        "stdio"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is TDengine Query MCP Server?

A Model Context Protocol (MCP) server that provides read-only TDengine database queries for AI assistants. It allows users to execute queries, explore database structures, and investigate data directly from their AI-powered tools.

How to use TDengine Query MCP Server?

Install via pip install tdengine_mcp_server, uvx tdengine-mcp-server, or run directly from source with uv run src/tdengine_mcp_server. Configure connection using command-line arguments (e.g., -th <host> -db <database>) or a .env file (which takes priority). The server works with any MCP-compatible client, including Cursor IDE and Anthropic Claude.

Key features of TDengine Query MCP Server

Executes only read‑only SQL queries (SELECT, SHOW, DESCRIBE)
Returns database/stable metadata and structure info
Lists available databases and stables
Compatible with all MCP‑supporting AI assistants
Supports both stdio and SSE transports
Configurable via environment variables or CLI arguments

Use cases of TDengine Query MCP Server

Query the first 10 records of a database from an AI assistant
Analyze sales data per region for a given month
Inspect table schemas and metadata without writing access
List all available databases on a TDengine instance

FAQ from TDengine Query MCP Server

What SQL operations are allowed?

Only read‑only queries: SELECT, SHOW, and DESCRIBE. INSERT, UPDATE, DELETE, CREATE, ALTER, and other write operations are blocked.

How do I configure the connection to my TDengine instance?

Set environment variables (host, port, username, password, database, timeout) in a .env file, or pass them via command‑line flags like -th, -tp, -db, etc. The .env file takes precedence.

Which AI tools can use this MCP server?

Any tool that supports the Model Context Protocol, such as Cursor IDE, Anthropic Claude, and other MCP‑compatible assistants.

Is the server secure for production use?

Yes – it enforces read‑only operations, preventing accidental or malicious data modifications. Only SELECT, SHOW, and DESCRIBE statements are allowed.

What should I do if I get a connection error?

Verify your database credentials, ensure the TDengine server is running and accessible, check firewall rules, and set LOG_LEVEL to DEBUG for more details.