Skip to content
MCP server

AKKO MCP server for Trino

Read-only Trino access for agents, run as the verified user so Trino policy decides

Runs locallyStatus and history
Pricing
Open source
Platforms
self-hosted, CLI
Runs
Locally
Version
0.8.1
Listing updated
3 days ago

About AKKO MCP server for Trino

AKKO MCP server for Trino is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.

The notable choice in akko-mcp-trino is that the server never decides who may read what. By default it verifies the user's token, trades it with the identity provider for a separate token issued for Trino (OAuth 2.0 Token Exchange), and runs the query as that person. Trino's own access control, whether OPA, Ranger or built-in rules, then applies row filters and column masks, and the user's token never leaves the server. A query without a verified identity is refused rather than run under another name. Four identity modes exist, from jwt as the default to service, which gives every caller one account.

Agents can find tables and columns, describe a schema or table, list catalogs, schemas and tables, and explain or run a query. Tables the user cannot see do not appear in searches. Read-only is enforced on the parsed syntax tree: more than one statement, any write anywhere in the tree, EXPLAIN ANALYZE, table functions and the system catalog are all refused. Results are capped in rows and time, and every call leaves one audit line.

It installs from PyPI as akko-mcp-trino and needs the Trino host, OIDC settings and a bearer token. The core is Apache-2.0, and AKKO and ARCHE ship a fuller enterprise version.

Install

Run in a terminal

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

Add to claude_desktop_config.json

{
  "mcpServers": {
    "akko-mcp-trino": {
      "command": "uvx",
      "args": [
        "akko-mcp-trino"
      ],
      "env": {
        "TRINO_HOST": "<TRINO_HOST>",
        "TRINO_HTTP_SCHEME": "<TRINO_HTTP_SCHEME>",
        "MCP_JWKS_URL": "<MCP_JWKS_URL>",
        "MCP_OIDC_ISSUER": "<MCP_OIDC_ISSUER>",
        "MCP_OIDC_AUDIENCE": "<MCP_OIDC_AUDIENCE>",
        "TRINO_TOKEN_EXCHANGE_CLIENT_SECRET": "<TRINO_TOKEN_EXCHANGE_CLIENT_SECRET>",
        "MCP_USER_TOKEN": "<MCP_USER_TOKEN>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "akko-mcp-trino": {
      "command": "uvx",
      "args": [
        "akko-mcp-trino"
      ],
      "env": {
        "TRINO_HOST": "<TRINO_HOST>",
        "TRINO_HTTP_SCHEME": "<TRINO_HTTP_SCHEME>",
        "MCP_JWKS_URL": "<MCP_JWKS_URL>",
        "MCP_OIDC_ISSUER": "<MCP_OIDC_ISSUER>",
        "MCP_OIDC_AUDIENCE": "<MCP_OIDC_AUDIENCE>",
        "TRINO_TOKEN_EXCHANGE_CLIENT_SECRET": "<TRINO_TOKEN_EXCHANGE_CLIENT_SECRET>",
        "MCP_USER_TOKEN": "<MCP_USER_TOKEN>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "akko-mcp-trino": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "akko-mcp-trino"
      ],
      "env": {
        "TRINO_HOST": "<TRINO_HOST>",
        "TRINO_HTTP_SCHEME": "<TRINO_HTTP_SCHEME>",
        "MCP_JWKS_URL": "<MCP_JWKS_URL>",
        "MCP_OIDC_ISSUER": "<MCP_OIDC_ISSUER>",
        "MCP_OIDC_AUDIENCE": "<MCP_OIDC_AUDIENCE>",
        "TRINO_TOKEN_EXCHANGE_CLIENT_SECRET": "<TRINO_TOKEN_EXCHANGE_CLIENT_SECRET>",
        "MCP_USER_TOKEN": "<MCP_USER_TOKEN>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "akko-mcp-trino": {
      "command": "uvx",
      "args": [
        "akko-mcp-trino"
      ],
      "env": {
        "TRINO_HOST": "<TRINO_HOST>",
        "TRINO_HTTP_SCHEME": "<TRINO_HTTP_SCHEME>",
        "MCP_JWKS_URL": "<MCP_JWKS_URL>",
        "MCP_OIDC_ISSUER": "<MCP_OIDC_ISSUER>",
        "MCP_OIDC_AUDIENCE": "<MCP_OIDC_AUDIENCE>",
        "TRINO_TOKEN_EXCHANGE_CLIENT_SECRET": "<TRINO_TOKEN_EXCHANGE_CLIENT_SECRET>",
        "MCP_USER_TOKEN": "<MCP_USER_TOKEN>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "akko-mcp-trino": {
      "command": "uvx",
      "args": [
        "akko-mcp-trino"
      ],
      "env": {
        "TRINO_HOST": "<TRINO_HOST>",
        "TRINO_HTTP_SCHEME": "<TRINO_HTTP_SCHEME>",
        "MCP_JWKS_URL": "<MCP_JWKS_URL>",
        "MCP_OIDC_ISSUER": "<MCP_OIDC_ISSUER>",
        "MCP_OIDC_AUDIENCE": "<MCP_OIDC_AUDIENCE>",
        "TRINO_TOKEN_EXCHANGE_CLIENT_SECRET": "<TRINO_TOKEN_EXCHANGE_CLIENT_SECRET>",
        "MCP_USER_TOKEN": "<MCP_USER_TOKEN>"
      }
    }
  }
}

Configuration

  • TRINO_HOSTTrino coordinator hostRequired
  • TRINO_HTTP_SCHEMEhttps (required by the default identity mode)Required
  • MCP_JWKS_URLJWKS endpoint of the OIDC providerRequired
  • MCP_OIDC_ISSUERExpected token issuerRequired
  • MCP_OIDC_AUDIENCEThe audience of tokens issued for this server (never Trino's)Required
  • TRINO_TOKEN_EXCHANGE_URLToken endpoint for OAuth 2.0 Token Exchange (jwt mode)
  • TRINO_TOKEN_EXCHANGE_CLIENT_IDThis server's client at the provider (jwt mode)
  • TRINO_TOKEN_EXCHANGE_CLIENT_SECRETIts secret (jwt mode)
  • TRINO_TOKEN_EXCHANGE_AUDIENCEThe audience Trino accepts (jwt mode)
  • TRINO_IDENTITY_MODEjwt (default), impersonation, oauth2 (Trino browser login, stdio only; needs the door open, MCP_AUTH_REQUIRED=false, or a verified MCP_USER_TOKEN), or service
  • MCP_USER_TOKENThe user's bearer token, issued for this server (stdio transport)Required

Tools this server provides (3)

Taken from the project documentation; the running server may differ.

search_columns
Finds tables and columns by words in their names or comments.
execute_query
Runs a read-only query as the verified user.
profile_table
Profiles a table; added in version 0.8.0.

What it does

User identity to Trino
Runs each query as the verified user via token exchange.
Policy stays in Trino
OPA, Ranger or Trino rules decide access; the server copies none.
Syntax-tree read-only check
Rejects writes anywhere in the parsed query.
Schema discovery
Finds tables and columns and describes schemas and tables.
Limits and audit
Row and time caps, plus one audit line per call.
Four identity modes
Choose jwt, impersonation, oauth2 or service.

Good for

  • Let an analyst's agent query a lakehouse with that analyst's permissions
  • Find which tables hold a given kind of data
  • Check a SQL query before running it
  • Audit which agent tool calls touched which data

Pricing

Open source

Apache-2.0 core; enterprise version via AKKO and ARCHE

Prices change. Check akko-ai.com before you buy.

AKKO MCP server for Trino FAQ

Can the agent write data?

No. Any write statement, multiple statements, EXPLAIN ANALYZE and table functions are refused.

Whose permissions does a query use?

By default the verified user's, through token exchange with your identity provider.

Which tools are exposed?

The README names `search_columns`, `execute_query` and a ninth tool, `profile_table`, added in 0.8.0.

What is open source?

The core under Apache 2.0; AKKO and ARCHE ship the full enterprise version.

Is AKKO MCP server for Trino free?

Yes. AKKO MCP server for Trino is open source, so you can use and self-host it for free.

How do I add AKKO MCP server for Trino to Claude Code?

Run this command in your terminal: claude mcp add akko-mcp-trino --env TRINO_HOST='<TRINO_HOST>' --env TRINO_HTTP_SCHEME='<TRINO_HTTP_SCHEME>' --env MCP_JWKS_URL='<MCP_JWKS_URL>' --env MCP_OIDC_ISSUER='<MCP_OIDC_ISSUER>' --env MCP_OIDC_AUDIENCE='<MCP_OIDC_AUDIENCE>' --env TRINO_TOKEN_EXCHANGE_CLIENT_SECRET='<TRINO_TOKEN_EXCHANGE_CLIENT_SECRET>' --env MCP_USER_TOKEN='<MCP_USER_TOKEN>' -- uvx akko-mcp-trino

What are the best alternatives to AKKO MCP server for Trino?

The closest alternatives to AKKO MCP server for Trino are REA, Agent Roast, Midplane, Leash and Tinplate Edge AI Safety, Security & EU Compliance.

Alternatives to AKKO MCP server for Trino

  1. REA

    MCP server

    CLI and MCP server that lets coding agents reverse engineer apps and binaries

    Runs locally
    • Open source
    • 464K GitHub stars
    • Developer tools
  2. Agent Roast

    MCP server

    Offline review that flags agent changes which weaken tests, assertions or CI

    Runs locally
    • Open source
    • 4 Hacker News points
    • Developer tools
  3. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  4. Leash

    MCP server

    Review what your AI touched, approve risky actions and undo supported changes

    • 1 tool
    • Remote
    • Free
    • 1 GitHub star
    • Security
  5. SecureCloud

    MCP server

    SentinelOne and IT security catalog, prices, quotes and checkout links for Israel

    • 7 tools
    • Remote
    • Free
    • Security