clickhouse-mcp

clickhouse-mcp

0
databases

The project is an MCP-compatible server designed to interact with ClickHouse databases. It offers features such as database and table management, SQL execution, and supports multiple transport methods. It is configured to run in different environments, including Docker.

ClickHouse MCP Server

A MCP-compatible server for interacting with ClickHouse databases.

Features

  • Retrieve database lists
  • Retrieve table lists from a selected database
  • Retrieve schema of a selected table
  • Execute SQL queries and retrieve results
  • Supports different transports (stdio and SSE)

Usage

Build

  • Build the application using Go to create the executable.

Run

  • Run the server using stdio or SSE transport with appropriate parameters.

Run in Docker

  • Use Docker or Docker Compose to deploy the server with environment variables for configuration.

Command Line Parameters

  • Transport type, testing mode, URL, user credentials, database, and TLS usage can be specified via command line.

License

  • MIT License.