T

Timeplus

Integrates with Timeplus to enable SQL query execution and database information retrieval for real-t...

162 views
0 installs
Updated Nov 22, 2025
Not audited
Integrates with Timeplus to enable SQL query execution and database information retrieval for real-time analytics and data exploration.
  1. Identify Your ClickHouse Server Details

    • Collect the following information for your ClickHouse service:
      • Hostname (CLICKHOUSE_HOST)
      • Username (CLICKHOUSE_USER)
      • Password (CLICKHOUSE_PASSWORD)
    • (Optional) If you want to connect to a specific database, also collect the database name (CLICKHOUSE_DATABASE).
  2. Default/Public/Cloud/Playground Settings

    • For ClickHouse Cloud, obtain your credentials from your ClickHouse Cloud dashboard.
    • For the ClickHouse SQL Playground, use:
      • CLICKHOUSE_HOST: sql-clickhouse.clickhouse.com
      • CLICKHOUSE_USER: demo
      • CLICKHOUSE_PASSWORD: (leave empty)
  3. Add ENV Values in FastMCP

    • Click the "Install Now" button for the ClickHouse MCP server in your FastMCP interface.
    • In the FastMCP connection interface, you will see fields for environment variables.
  4. Fill in the Required Environment Variables

    • Enter your ClickHouse connection details in the interface:

      • CLICKHOUSE_HOST: (your ClickHouse server host or use sql-clickhouse.clickhouse.com for playground)
      • CLICKHOUSE_USER: (your ClickHouse username or demo for playground)
      • CLICKHOUSE_PASSWORD: (your password, or leave blank for playground)
    • (Optional) Fill in additional fields if you want to override defaults:

      • CLICKHOUSE_PORT (typically 8443 for secure connections, 8123 for non-secure)
      • CLICKHOUSE_SECURE (true for HTTPS, false otherwise)
      • CLICKHOUSE_VERIFY (true to verify SSL certificates)
      • CLICKHOUSE_CONNECT_TIMEOUT, CLICKHOUSE_SEND_RECEIVE_TIMEOUT, CLICKHOUSE_DATABASE as needed
  5. Complete the Installation

    • Save your changes in the FastMCP connection interface.
    • The MCP server will use these environment variables to connect to your ClickHouse server.

Tip: For ClickHouse Cloud, get your credentials from the cloud provider. For local development, use your local Docker or default credentials as shown above. For playground/testing, you can use the public playground settings (demo user, no password).

Quick Start

View on GitHub

More for Database

View All →

Report Issue

Thank you! Your issue report has been submitted successfully.