Timeplus MCP Server

Name: Timeplus MCP Server
Author: jovezhong

@jovezhong

关于 Timeplus MCP Server

Execute SQL queries and manage databases seamlessly with Timeplus. Leverage powerful tools to interact with your data, Kafka topics, and Iceberg tables efficiently. Enhance your data workflows with a user-friendly interface and robust backend capabilities.

#kafka #spark #clickhouse #flink #iceberg #mcp-server

基本信息

分类

其他

许可证

Apache-2.0

运行时

python

传输方式

stdio

发布者

jovezhong

提交者

Qianjie Zhong

配置

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

{
  "mcpServers": {
    "mcp-timeplus": {
      "command": "uvx",
      "args": [
        "mcp-timeplus"
      ],
      "env": {
        "TIMEPLUS_HOST": "<timeplus-host>",
        "TIMEPLUS_PORT": "<timeplus-port>",
        "TIMEPLUS_USER": "<timeplus-user>",
        "TIMEPLUS_PASSWORD": "<timeplus-password>",
        "TIMEPLUS_SECURE": "false",
        "TIMEPLUS_VERIFY": "true",
        "TIMEPLUS_CONNECT_TIMEOUT": "30",
        "TIMEPLUS_SEND_RECEIVE_TIMEOUT": "30",
        "TIMEPLUS_READ_ONLY": "false",
        "TIMEPLUS_KAFKA_CONFIG": "{\"bootstrap.servers\":\"a.aivencloud.com:28864\", \"sasl.mechanism\":\"SCRAM-SHA-256\",\"sasl.username\":\"avnadmin\", \"sasl.password\":\"thePassword\",\"security.protocol\":\"SASL_SSL\",\"enable.ssl.certificate.verification\":\"false\"}"
      }
    }
  }
}

工具

Execute SQL queries on your Timeplus cluster.

List all databases on your Timeplus cluster.

List all tables in a database.

List all topics in a Kafka cluster

Show some messages in the Kafka topic

Setup a streaming ETL in Timeplus to save the Kafka messages locally

Connect to a database based on Apache Iceberg. Currently this is only available via Timeplus Enterprise and it's planned to make it available for Timeplus Proton soon.

概览

What is Timeplus MCP Server?

An MCP server that enables LLMs to interact with Timeplus, a streaming analytics platform. It provides tools for executing SQL queries, managing databases and tables, and integrating with Kafka and Apache Iceberg.

How to use Timeplus MCP Server?

Install via uvx mcp-timeplus and configure environment variables for your Timeplus instance in the MCP client settings (e.g., Claude Desktop). After restarting the client, use the available prompts (generate_sql) and tools (run_sql, list_databases, etc.).

Key features of Timeplus MCP Server

Execute SQL queries on a Timeplus cluster.
List databases and tables in your cluster.
List and explore Kafka topics and messages.
Create Kafka streams to ingest data into Timeplus.
Connect to Apache Iceberg databases (Timeplus Enterprise only).
Prompt to generate SQL with Timeplus‑specific knowledge.

Use cases of Timeplus MCP Server

Ask an LLM to query streaming data and return results.
Automate database schema exploration via natural language.
Set up streaming ETL from Kafka to Timeplus with a single tool call.

FAQ from Timeplus MCP Server

What dependencies are required to run the server?

The server requires uv to be installed, and a running Timeplus instance (either Timeplus Proton or Timeplus Enterprise). Docker Compose is available for local development.

How do I configure read‑only mode?

By default, all queries run with readonly = 1. To allow DDL/DML queries, set the environment variable TIMEPLUS_READ_ONLY to "false".

What transport does the server use?

The server uses the standard MCP transport (stdio). It is launched as a subprocess by the MCP client (e.g., Claude Desktop or 5ire).

Where does data live?

All data remains on the Timeplus cluster. The MCP server only sends queries and receives results; it does not store data locally.

Can I connect to a Kafka cluster through the server?

Yes. Provide a Kafka configuration as a JSON string via the TIMEPLUS_KAFKA_CONFIG environment variable. Tools like list_kafka_topics, explore_kafka_topic, and create_kafka_stream are available.