Altinity Mcp

@Altinity

About Altinity Mcp

**Altinity MCP Server** is a production-ready MCP server designed to empower AI agents and LLMs to interact seamlessly with ClickHouse. It exposes your ClickHouse database as a set of standardized tools and resources that adhere to the MCP protocol, making it easy for agents buil

#clickhouse #databases #openapi #dynamic-tools

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "altinity-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "JWE_SECRET_KEY=<string-for-decrypt-auth-tokens>",
        "ghcr.io/altinity/altinity-mcp"
      ],
      "env": {
        "JWE_SECRET_KEY": "<string-for-decrypt-auth-tokens>"
      }
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Altinity Mcp?

Altinity Mcp is a production-ready MCP (Model Context Protocol) server that enables AI agents and LLMs to interact seamlessly with ClickHouse databases. It exposes ClickHouse as standardized tools and resources, allowing agents built on OpenAI, Claude, or other platforms to query, explore, and analyze data without direct database access.

How to use Altinity Mcp?

Configure the server via environment variables, a YAML/JSON configuration file, or CLI flags, with hot-reload support for dynamic adjustments. Run it locally using STDIO transport for embedded agents, or via HTTP/SSE for remote, streaming, or REST-style access.

Key features of Altinity Mcp

Transport Options: STDIO, HTTP, and SSE (Server-Sent Events) for streaming.
OpenAPI Integration: Generates full OpenAPI v3 spec in HTTP/SSE mode.
Security & Authentication: Optional JWE/JWT authentication and TLS support.
Dynamic Resource Discovery: Auto-introspects ClickHouse schema and generates MCP resources.
Flexible Configuration: Environment variables, YAML/JSON, CLI flags, with hot-reload.

Use cases of Altinity Mcp

AI assistant integrated with OpenAI using OpenAPI spec for tool discovery and calls.
Streaming analytics with progressive results via SSE for responsive UIs or agents.
Secure enterprise access: expose ClickHouse through fine-grained auth, TLS, and tool-level controls.
Schema-aware LLM workflows: agents reason about data structure using exposed metadata and sample rows.

FAQ from Altinity Mcp

What transport modes does Altinity Mcp support?

It supports STDIO for local workflows, HTTP for REST-style calls, and SSE for streaming responses.

How does authentication work in Altinity Mcp?

The server supports optional JWE token authentication, JWT signing, and TLS for both the MCP server and the underlying ClickHouse connection.

Does Altinity Mcp support dynamic schema discovery?

Yes, it introspects the ClickHouse schema and automatically generates MCP resources such as tables, views, and sample data, so agents understand your data context.

Can I change configuration without restarting the server?

Yes, Altinity Mcp includes hot-reload support, allowing you to adjust configuration without a full restart.

Does Altinity Mcp integrate with OpenAPI?

When HTTP or SSE mode is enabled, the server generates a full OpenAPI v3 specification describing all tools and endpoints, making it easy for platforms like OpenAI to discover and call your tools.

Frequently asked questions