MCP.so
Sign In

Timeplus MCP Server

@jovezhong

Basic information

Category

Other

License

Apache-2.0

Transports

stdio

Author

jovezhong

Submitted by

Qianjie Zhong

About 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.

Timeplus MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "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\"}"
      }
    }
  }
}

Timeplus MCP Server tools

7

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.

Overview

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.

Frequently asked questions

1

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.

2

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"`.

3

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).

4

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.

5

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.

Comments

More Other MCP servers