Back to MCP Directory
Timeplus
Model Context Protocol moderate risk

Timeplus

The Timeplus MCP server enables LLMs to interact with Timeplus streaming analytics via SQL, offering tools for data exploration, querying, and Kafka integration.

Connections & Capabilities

Connects To

GitHubDockerAWSS3

Capabilities

readwriteexec

Quickstart

Config

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

Exposed MCP Tools (7)

moderate
run_sql

Executes SQL queries on the Timeplus cluster.

Can modify data if TIMEPLUS_READ_ONLY is set to false.

safe
list_databases

Lists all databases on the Timeplus cluster.

Read-only operation with no side effects.

safe
list_tables

Lists all tables in a specified database.

Read-only operation with no side effects.

safe
list_kafka_topics

Lists all topics in a Kafka cluster.

Read-only operation with no side effects.

safe
explore_kafka_topic

Shows messages in a Kafka topic.

Read-only operation with no side effects.

moderate
create_kafka_stream

Sets up a streaming ETL in Timeplus to save Kafka messages locally.

Creates a new stream, which can consume resources.

moderate
connect_to_apache_iceberg

Connects to a database based on Apache Iceberg.

Connects to external data source, potential data access risk.

Safety Assessment

This server provides a balance between functionality and security. It is safe for read-only operations and data exploration. However, enabling write operations and Kafka integration requires careful configuration and security considerations to mitigate potential risks.

  • Read-only mode is enabled by default for SQL queries.
  • Clear separation of read and write operations.
  • Environment variable configuration for sensitive information.
  • Supports SSL certificate verification.
  • Direct SQL execution poses a risk of injection if not carefully managed.
  • Write operations can be enabled by changing the TIMEPLUS_READ_ONLY environment variable.
  • Access to Kafka topics and creation of streams could lead to data exposure or manipulation.
  • Improperly configured Kafka connections can lead to security vulnerabilities.