Loading...

The Timeplus MCP server enables LLMs to interact with Timeplus streaming analytics via SQL, offering tools for data exploration, querying, and Kafka integration.
Boost this tool
Subscribe to listing upgrades or segmented pushes.
The Timeplus MCP server enables LLMs to interact with Timeplus streaming analytics via SQL, offering tools for data exploration, querying, and Kafka integration.
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.
Performance depends on the Timeplus cluster's resources and the complexity of the SQL queries. Consider optimizing queries for better performance.
Cost depends on Timeplus usage, including data storage, query execution, and Kafka stream processing. Monitor resource consumption to manage costs effectively.
{
"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_HOSTTIMEPLUS_PORTTIMEPLUS_USERTIMEPLUS_PASSWORDTIMEPLUS_SECURETIMEPLUS_VERIFYTIMEPLUS_CONNECT_TIMEOUTTIMEPLUS_SEND_RECEIVE_TIMEOUTTIMEPLUS_READ_ONLYTIMEPLUS_KAFKA_CONFIGrun_sqlExecutes SQL queries on the Timeplus cluster.
Can modify data if TIMEPLUS_READ_ONLY is set to false.
list_databasesLists all databases on the Timeplus cluster.
Read-only operation with no side effects.
list_tablesLists all tables in a specified database.
Read-only operation with no side effects.
list_kafka_topicsLists all topics in a Kafka cluster.
Read-only operation with no side effects.
explore_kafka_topicShows messages in a Kafka topic.
Read-only operation with no side effects.
create_kafka_streamSets up a streaming ETL in Timeplus to save Kafka messages locally.
Creates a new stream, which can consume resources.
connect_to_apache_icebergConnects to a database based on Apache Iceberg.
Connects to external data source, potential data access risk.
Environment Variable
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.
By default, the server operates in read-only mode, limiting the potential for unintended data modification. However, this can be changed via environment variables.
Production Tip
Ensure that the TIMEPLUS_READ_ONLY environment variable is set to 'true' in production unless write access is explicitly required.
The server defaults to read-only mode to prevent accidental data modification.
Set the TIMEPLUS_READ_ONLY environment variable to 'false'.
The TIMEPLUS_KAFKA_CONFIG environment variable accepts a JSON string with librdkafka configuration options.
Set TIMEPLUS_SECURE to 'true' to enable HTTPS and ensure TIMEPLUS_VERIFY is 'true' to verify the SSL certificate.
SQL injection, unauthorized data access, and unintended data modification are potential risks.
Yes, it can be used with other MCP clients like 5ire.
You need to set the environment variables TIMEPLUS_HOST, TIMEPLUS_PORT, TIMEPLUS_USER, and TIMEPLUS_PASSWORD.