Altinity MCP Server v1.4.2

Release Notes

v1.4.2

IMPROVEMENTS

• helm: add sessionAffinity and sessionAffinityConfig support to service template for sticky sessions (PR #78)
• helm: add liveness probe handler
• fix description of resources

DEPENDENCY UPDATES

• bump github.com/ClickHouse/clickhouse-go/v2 from 2.44.0 to 2.45.0
• bump github.com/modelcontextprotocol/go-sdk from 1.4.1 to 1.5.0

Docker

docker run --rm ghcr.io/altinity/altinity-mcp:1.4.2 altinity-mcp --help

Helm

helm install altinity-mcp oci://ghcr.io/altinity/altinity-mcp/helm/altinity-mcp -n <your-namespace> -f <your-values.yaml>

Altinity MCP Server v1.4.1

Release Notes

v1.4.1

IMPROVEMENTS

• helm: add env support for container secrets (e.g. CLICKHOUSE_PASSWORD) (PR #77)

Docker

docker run --rm ghcr.io/altinity/altinity-mcp:1.4.1 altinity-mcp --help

Helm

helm install altinity-mcp oci://ghcr.io/altinity/altinity-mcp/helm/altinity-mcp -n <your-namespace> -f <your-values.yaml>

Altinity MCP Server v1.4.0

Release Notes

v1.4.0

FEATURES

• add OAuth 2.0 authentication with two modes (PR #68):
  • forward mode — MCP server acts as OAuth broker, forwards access tokens to ClickHouse via HTTP (port 8123)
  • gating mode — MCP server validates tokens and connects to ClickHouse with its own credentials via native protocol (port 9000)
  • browser-based OAuth flow with configurable URLs and paths
  • refresh token support with stateless token limitations documented
  • combined JWE + OAuth authentication: JWE with credentials skips OAuth, otherwise falls through
  • in-memory OAuth state store capped to prevent memory exhaustion
  • 10s timeout on upstream OAuth token exchange
  • misconfiguration warnings for forward mode
  • comprehensive E2E tests with Keycloak + ClickHouse Antalya containers
• add tool_input_settings for per-request ClickHouse settings via tool arguments (PR #67), fix #48
  • allows clients to pass ClickHouse settings (e.g. max_threads, max_execution_time) as tool input parameters
• add blocked_query_clauses to prevent SQL clause injection (PR #67)
  • configurable list of SQL clauses that are blocked from query execution
• add MCP safety hints for tools — readOnlyHint, destructiveHint, openWorldHint (PR #66), fix #48
  • openWorldHint computed from effective ClickHouse grants
  • safety hints applied to both static and dynamic tools
• enforce read-only mode by blocking write SQL in execute_query (PR #57), fix #56

IMPROVEMENTS

• replace regex-based SQL clause detection with AST parser for more reliable query analysis (PR #67)
• refactor: remove forward_http_headers and header_to_settings features (PRs #63/#65 superseded by #67)
• remove forward_to_clickhouse, forward_access_token, clear_clickhouse_credentials flags — replaced by OAuth modes
• skip startup ClickHouse ping in OAuth forward mode when credentials are per-request
• move development and testing docs out of README
• rewrite OAuth documentation with ASCII diagrams for both modes
• improve test coverage from 84.6% to 87.6% with unit and E2E tests
• add t.Parallel() to all tests and container startup timing logs
• refactor server tests to use official MCP Go SDK
• increase server test coverage to 91% and fix race conditions
• fix GitHub Actions CI to avoid deprecated Node 20 runners

BUG FIXES

• fix sqlLiteral string escaping and isSelectQuery comment stripping
• fix nil pointer panic, route conflict, and test assertions in OAuth flow
• fix dynamic tool discovery when JWE is enabled
• fix refresh token policy bypass
• avoid max_execution_time during ClickHouse HTTP handshake
• fix JWE validation running unconditionally when startup ping is skipped
• fix OpenAPI OAuth token forwarding in forward mode

DEPENDENCY UPDATES

• bump github.com/go-jose/go-jose/v4 from 4.1.3 to 4.1.4
• bump google.golang.org/grpc from 1.78.0 to 1.79.3
• bump github.com/modelcontextprotocol/go-sdk to 1.4.1
• bump github.com/testcontainers/testcontainers-go from 0.40.0 to 0.41.0
• bump github.com/urfave/cli/v3 from 3.6.1 to 3.7.0
• bump github.com/ClickHouse/clickhouse-go/v2 from 2.41.0 to 2.42.0
• bump github.com/mark3labs/mcp-go from 0.43.1 to 0.43.2

Docker

docker run --rm ghcr.io/altinity/altinity-mcp:1.4.0 altinity-mcp --help

Helm

helm install altinity-mcp oci://ghcr.io/altinity/altinity-mcp/helm/altinity-mcp -n <your-namespace> -f <your-values.yaml>

Altinity MCP Server v1.3.4

Release Notes

v1.3.4

FEATURES

• dynamic tools are now refreshed on every schema request (OpenAPI) or tools/list (MCP) call
• dynamic tools are now per-connection: different ClickHouse connections (user@host:port/database) have independent tool sets
• views deleted from ClickHouse are automatically removed from the tool list on next refresh

Docker

docker run --rm ghcr.io/altinity/altinity-mcp:1.3.4 altinity-mcp --help

Helm

helm install altinity-mcp oci://ghcr.io/altinity/altinity-mcp/helm/altinity-mcp -n <your-namespace> -f <your-values.yaml>

Altinity MCP Server v1.3.3

Release Notes

v1.3.3

IMPROVEMENTS

• change dynamic tools JSON comment format to {"name":"tool_name", "description":"tool description", "params": {"param1":"param1 description","param2":"description"}}

Docker

docker run --rm ghcr.io/altinity/altinity-mcp:1.3.3 altinity-mcp --help

Helm

helm install altinity-mcp oci://ghcr.io/altinity/altinity-mcp/helm/altinity-mcp -n <your-namespace> -f <your-values.yaml>

Altinity MCP Server v1.3.2

Release Notes

v1.3.2

FEATURES

• support JSON comments for rich dynamic tool descriptions
• append custom description to ClickHouse type in parameter details

TESTING

• add test for dynamic tools JSON comment parsing

Docker

docker run --rm ghcr.io/altinity/altinity-mcp:1.3.2 altinity-mcp --help

Helm

helm install altinity-mcp oci://ghcr.io/altinity/altinity-mcp/helm/altinity-mcp -n <your-namespace> -f <your-values.yaml>

Altinity MCP Server v1.3.1

Release Notes

v1.3.1

IMPROVEMENTS

• implement lazy loading for dynamic tools to improve startup time and reliability

BUG FIXES

• ensure dynamic tools are properly initialized when using JWE authentication by loading them upon first request with valid token

Docker

docker run --rm ghcr.io/altinity/altinity-mcp:1.3.1 altinity-mcp --help

Helm

helm install altinity-mcp oci://ghcr.io/altinity/altinity-mcp/helm/altinity-mcp -n <your-namespace> -f <your-values.yaml>

Altinity MCP Server v1.3.0

Release Notes

v1.3.0

FEATURES

• add dynamic tools support - automatically generate MCP tools from ClickHouse views, fix #27
  • configure rules to match views using regexp patterns against system.tables
  • optionally specify explicit tool names with name field (requires regexp to match exactly one view)
  • automatic parameter detection from view definitions {param: Type}
  • support for both MCP and OpenAPI endpoints
  • comprehensive documentation in docs/dynamic_tools.md

IMPROVEMENTS

• add Microsoft Copilot Studio compatibility by handling trailing slashes in HTTP paths (contribution by @derFunk)
• update dependencies:
  • bump github.com/mark3labs/mcp-go from 0.41.1 to 0.42.0
  • bump github.com/urfave/cli/v3 from 3.4.1 to 3.5.0
• update Helm chart values.yaml

Docker

docker run --rm ghcr.io/altinity/altinity-mcp:1.3.0 altinity-mcp --help

Helm

helm install altinity-mcp oci://ghcr.io/altinity/altinity-mcp/helm/altinity-mcp -n <your-namespace> -f <your-values.yaml>

Altinity MCP Server v1.2.1

Release Notes

v1.2.1

IMPROVEMENTS

• remove default limit behavior - LIMIT clause is now only added when explicitly specified by the user
• change --clickhouse-limit default from 1000 to 0 (no limit)
• --clickhouse-limit now acts as a maximum cap rather than a default value
• update OpenAPI documentation to clarify optional limit parameter behavior

BUG FIXES

• fix test expectations to match new limit behavior (expect 0 instead of 1000)

Docker

docker run --rm ghcr.io/altinity/altinity-mcp:1.2.1 altinity-mcp --help

Helm

helm install altinity-mcp oci://ghcr.io/altinity/altinity-mcp/helm/altinity-mcp -n <your-namespace> -f <your-values.yaml>

Altinity MCP Server v1.2.0

Release Notes

v1.2.0

IMPROVEMENTS

• remove list_tables and describe_table tools and resources
• remove all prompt capabilities

BUG FIXES

• fix OpenAPI schema generation to exclude removed endpoints
• remove references to deleted tools in documentation and tests
• extend isSelectQuery to support DESC, EXISTS, and EXPLAIN queries, fix #26

Docker

docker run --rm ghcr.io/altinity/altinity-mcp:1.2.0 altinity-mcp --help

Helm

helm install altinity-mcp oci://ghcr.io/altinity/altinity-mcp/helm/altinity-mcp -n <your-namespace> -f <your-values.yaml>