run_sqlLABSCO SUMMARY
Read-only by default, and Kafka one call away.
Queries run readonly until you deliberately set TIMEPLUS_READ_ONLY to false, which makes it reasonable to point at a live cluster. The Kafka tools are the differentiator: look at what is actually on a topic, then decide to persist it, without switching tools.
What it is
An MCP server for Timeplus. It runs SQL on the cluster, lists databases and tables, and reaches Kafka directly to list topics, sample messages and set up a streaming ETL into Timeplus.
What you get
- SQL executed against the cluster, with queries run readonly = 1 unless TIMEPLUS_READ_ONLY is set to false (run_sql)
- Databases listed, and the tables inside one of them (list_databases, list_tables)
- Kafka topics listed, and a few messages from one shown without leaving the client (list_kafka_topics, explore_kafka_topic)
- A streaming ETL that saves a Kafka topic's messages into Timeplus (create_kafka_stream)
- An Apache Iceberg database on S3 connected as a source (connect_to_apache_iceberg)
- A generate_sql prompt that gives the model Timeplus-specific SQL knowledge
Requirements
uv, then uvx mcp-timeplus, with the Timeplus host, port, user and password in the client config. Iceberg is documented as available through Timeplus Enterprise.
Setup effort
One command plus credentials — uvx mcp-timeplus, then supply credentials
USE CASES
01
Answering a question about live data
Find the table, then run the SQL against the cluster.
02
Finding your way around an unfamiliar cluster
List the databases, then the tables in the one that looks right.
03
Checking what a Kafka topic actually carries
List the topics and read a couple of messages off one.
04
Getting a topic into something queryable
Set up the streaming ETL, then query what lands.
05
Querying an Iceberg dataset alongside streams
Connect the Iceberg database, then use the same SQL tool over both.
7 tools
Listed in project docs. Your client may show a different list.
list_databaseslist_tableslist_kafka_topicsexplore_kafka_topiccreate_kafka_streamconnect_to_apache_icebergBEFORE YOU INSTALL
What to know first
Tools you get
7 tools named in the project's documentation.
Requires
- uvx on PATH
- TIMEPLUS_USER in your environment
- TIMEPLUS_PASSWORD in your environment
- TIMEPLUS_HOST in your environment
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
Server setup
TERMINAL
uvx mcp-timeplusMCP Clients
Claude Desktop
CLAUDE DESKTOP · JSON
{
"mcpServers": {
"mcp-timeplus": {
"command": "uvx",
"args": [
"mcp-timeplus"
],
"env": {
"TIMEPLUS_HOST": "<YOUR_TIMEPLUS_HOST>",
"TIMEPLUS_PORT": "<YOUR_TIMEPLUS_PORT>",
"TIMEPLUS_USER": "<YOUR_TIMEPLUS_USER>",
"TIMEPLUS_PASSWORD": "<YOUR_TIMEPLUS_PASSWORD>"
}
}
}
}
