TDengine Query MCP Server
About
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.
Details
- License
- MIT
Explore
- 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
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
TDengine Query MCP ServerCommand (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
From the repository
pip install tdengine_mcp_server
and then run:
python -m tdengine_mcp_server -h
uvx tdengine-mcp-server -h
npx -y @smithery/cli@latest install @Abeautifulsnow/tdengine-mcp --client cursor --config '"{}"'
You can change the client after the --client option with alternatives claude, 'windsurf' and so on. Also you can refer to this: smithery/tdengine-mcp-server
$ python3 -m tdengine_mcp_server -h
usage: __main__.py [-h] [-th TAOS_HOST] [-tp TAOS_PORT] [-tu TAOS_USERNAME] [-pwd TAOS_PASSWORD] [-db TAOS_DATABASE] [-to TAOS_TIMEOUT] [-ll LOG_LEVEL]
TDengine MCP Server
options:
-h, --help show this help message and exit
-th, --taos-host TAOS_HOST
TDengine host address. Default: localhost
-tp, --taos-port TAOS_PORT
TDengine port number. Default: 6041
-tu, --taos-username TAOS_USERNAME
TDengine username. Default: root
-pwd, --taos-password TAOS_PASSWORD
TDengine password. Default: taosdata
-db, --taos-database TAOS_DATABASE
TDengine database name. Default: default
-to, --taos-timeout TAOS_TIMEOUT
TDengine connection timeout. Default: 30
-ll, --log-level LOG_LEVEL
Log level. Default: INFO
-trans, --transport {sse,stdio}
The transport to use. Default: sse
This MCP server works with any tool that supports the Model Context Protocol, including:
- Cursor IDE: Set up in .cursor/mcp.json
- Anthropic Claude: Use with a compatible MCP client
- Other MCP-compatible AI assistants: Follow the tool's MCP configuration instructions
The TDengine Query MCP server provides three main tools that your AI assistant can use:
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"tdengine query mcp server": {
"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"
]
}
}
}
}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"
]
}
}
A Model Context Protocol (MCP) server that provides read-only TDengine database queries for AI assistants. Execute queries, explore database structures, and investigate your data directly from your AI-powered tools.
Supported AI Tools
This MCP server works with any tool that supports the Model Context Protocol, including:
- Cursor IDE: Set up in .cursor/mcp.json
- Anthropic Claude: Use with a compatible MCP client
- Other MCP-compatible AI assistants: Follow the tool's MCP configuration instructions
Features & Limitations
What It Does
- ✅ Execute read-only TDengine queries (SELECT, SHOW, DESCRIBE only)
- ✅ Provide database/stable information and metadata
- ✅ List available database and stables
What It Doesn't Do
- ❌ Execute write operations (INSERT, UPDATE, DELETE, CREATE, ALTER, etc.)
- ❌ Provide database design or schema generation capabilities
- ❌ Function as a full database management tool
This tool is designed specifically for data investigation and exploration through read-only queries. It is not intended for database administration, schema management, or data modification.
How to use
Run from source code
The recommended way to use this MCP server is to run it directly with uv without installation. This is how both Claude Desktop and Cursor are configured to use it in the examples below.
If you want to clone the repository:
git clone https://github.com/Abeautifulsnow/tdengine-mcp.git
cd tdengine-mcp
Then you can run the server directly:
uv run src/tdengine_mcp_server -th 192.100.8.22 -db log -ll debug
Alternatively you can change the .env file in the src/tdengine_mcp_server/ directory to set the environment variables and run the server with the following command:
uv run src/tdengine_mcp_server
> Important: the .env file will have higher priority than the command line arguments.
Install From Pypi by pip command
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
