Skip to main content
MCP server CX Codex

AKKO MCP server for Trino — Claude Code MCP server

AKKO MCP server for Trino is a Claude Code MCP server for read-only Trino queries. Each request reaches Trino under the acting user's identity.

Apache-2.0 ★ 7 updated 2026-11-14

Install into Claude Code · Platform CLI All methods and platforms ↓
claude mcp add akko-mcp-trino -e TRINO_HOST=<TRINO_HOST> -e TRINO_HTTP_SCHEME=<TRINO_HTTP_SCHEME> -e MCP_JWKS_URL=<MCP_JWKS_URL> -e MCP_OIDC_ISSUER=<MCP_OIDC_ISSUER> -e MCP_OIDC_AUDIENCE=<MCP_OIDC_AUDIENCE> -e TRINO_TOKEN_EXCHANGE_CLIENT_SECRET=<TRINO_TOKEN_EXCHANGE_CLIENT_SECRET> -e MCP_USER_TOKEN=<MCP_USER_TOKEN> -- uvx akko-mcp-trino
Open on GitHub

What AKKO MCP server for Trino does

AKKO MCP server for Trino gives an agent tools to find tables and columns, inspect schemas, list catalogs, and run permitted queries. It parses statements first and blocks write operations before they reach Trino.

The server checks a user token issued for this server, then obtains a separate Trino token through OAuth 2.0 Token Exchange. The original token stays inside the server. Trino policies, including OPA or Ranger rules, decide which data that identity may read.

Responses are bounded by row count and execution time, and each call produces an audit line. Running it requires Trino, uvx, an identity provider, and TRINO_HOST, TRINO_HTTP_SCHEME, MCP_JWKS_URL, MCP_OIDC_ISSUER, and MCP_OIDC_AUDIENCE; token exchange also uses TRINO_TOKEN_EXCHANGE_CLIENT_SECRET and MCP_USER_TOKEN.

What it helps with

  • find tables and columns in Trino
  • inspect a schema before writing a query
  • run a query while blocking writes
  • preserve each user's Trino permissions
  • limit an agent response by rows and time

Example prompts for the agent

  • Find the Trino tables and columns related to orders.
  • Describe the analytics schema and the customers table.
  • Run a read query with my current Trino permissions and return the result.

How to install AKKO MCP server for Trino

Platform CLI

claude mcp add akko-mcp-trino -e TRINO_HOST=<TRINO_HOST> -e TRINO_HTTP_SCHEME=<TRINO_HTTP_SCHEME> -e MCP_JWKS_URL=<MCP_JWKS_URL> -e MCP_OIDC_ISSUER=<MCP_OIDC_ISSUER> -e MCP_OIDC_AUDIENCE=<MCP_OIDC_AUDIENCE> -e TRINO_TOKEN_EXCHANGE_CLIENT_SECRET=<TRINO_TOKEN_EXCHANGE_CLIENT_SECRET> -e MCP_USER_TOKEN=<MCP_USER_TOKEN> -- uvx akko-mcp-trino

Replace <…> with your own values. 6 more environment variables are in the server README. uvx runs the command named after the package; if the README names another one, use uvx --from akko-mcp-trino <command>

Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more

Questions about AKKO MCP server for Trino

How do I install AKKO MCP server for Trino in Claude Code?

Run `claude mcp add akko-mcp-trino -e TRINO_HOST=<TRINO_HOST> -e TRINO_HTTP_SCHEME=<TRINO_HTTP_SCHEME> -e MCP_JWKS_URL=<MCP_JWKS_URL> -e MCP_OIDC_ISSUER=<MCP_OIDC_ISSUER> -e MCP_OIDC_AUDIENCE=<MCP_OIDC_AUDIENCE> -e TRINO_TOKEN_EXCHANGE_CLIENT_SECRET=<TRINO_TOKEN_EXCHANGE_CLIENT_SECRET> -e MCP_USER_TOKEN=<MCP_USER_TOKEN> -- uvx akko-mcp-trino`. This registers the server and passes its connection settings as environment variables.

What does AKKO MCP server for Trino do?

It gives an agent tools for discovering tables, reading schema details, and running allowed Trino queries. Write statements are rejected before submission, while Trino's own policies control data access.

What does AKKO MCP server for Trino need to run?

It requires Trino, uvx, an identity provider, and a user token issued for this server. Token exchange uses TRINO_TOKEN_EXCHANGE_CLIENT_SECRET together with MCP_JWKS_URL, MCP_OIDC_ISSUER, and MCP_OIDC_AUDIENCE.

Similar MCP servers

MCP servers catalog →

Project sponsors

Companies that keep this analytics open