Read-only MCP server for Trino: six tools, writes refused on the SQL tree, one configured Trino identity, bounded rows and time. Any MCP host, any model.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add akko-server-for-trino --env TRINO_HOST='<TRINO_HOST>' --env MCP_JWKS_URL='<MCP_JWKS_URL>' --env MCP_OIDC_ISSUER='<MCP_OIDC_ISSUER>' --env MCP_USER_TOKEN='<MCP_USER_TOKEN>' -- uvx akko-mcp-trino~/.codex/config.toml
[mcp_servers.akko-server-for-trino]
command = "uvx"
args = ["akko-mcp-trino"]
env = { TRINO_HOST = "<TRINO_HOST>", MCP_JWKS_URL = "<MCP_JWKS_URL>", MCP_OIDC_ISSUER = "<MCP_OIDC_ISSUER>", MCP_USER_TOKEN = "<MCP_USER_TOKEN>" }
# codex mcp add akko-server-for-trino --env TRINO_HOST='<TRINO_HOST>' --env MCP_JWKS_URL='<MCP_JWKS_URL>' --env MCP_OIDC_ISSUER='<MCP_OIDC_ISSUER>' --env MCP_USER_TOKEN='<MCP_USER_TOKEN>' -- uvx akko-mcp-trino~/.cursor/mcp.json
{
"mcpServers": {
"akko-server-for-trino": {
"command": "uvx",
"args": [
"akko-mcp-trino"
],
"env": {
"TRINO_HOST": "<TRINO_HOST>",
"MCP_JWKS_URL": "<MCP_JWKS_URL>",
"MCP_OIDC_ISSUER": "<MCP_OIDC_ISSUER>",
"MCP_USER_TOKEN": "<MCP_USER_TOKEN>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"akko-server-for-trino": {
"type": "stdio",
"command": "uvx",
"args": [
"akko-mcp-trino"
],
"env": {
"TRINO_HOST": "<TRINO_HOST>",
"MCP_JWKS_URL": "<MCP_JWKS_URL>",
"MCP_OIDC_ISSUER": "<MCP_OIDC_ISSUER>",
"MCP_USER_TOKEN": "<MCP_USER_TOKEN>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"akko-server-for-trino": {
"command": "uvx",
"args": [
"akko-mcp-trino"
],
"env": {
"TRINO_HOST": "<TRINO_HOST>",
"MCP_JWKS_URL": "<MCP_JWKS_URL>",
"MCP_OIDC_ISSUER": "<MCP_OIDC_ISSUER>",
"MCP_USER_TOKEN": "<MCP_USER_TOKEN>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"akko-server-for-trino": {
"command": "uvx",
"args": [
"akko-mcp-trino"
],
"env": {
"TRINO_HOST": "<TRINO_HOST>",
"MCP_JWKS_URL": "<MCP_JWKS_URL>",
"MCP_OIDC_ISSUER": "<MCP_OIDC_ISSUER>",
"MCP_USER_TOKEN": "<MCP_USER_TOKEN>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"akko-server-for-trino": {
"command": "uvx",
"args": [
"akko-mcp-trino"
],
"env": {
"TRINO_HOST": "<TRINO_HOST>",
"MCP_JWKS_URL": "<MCP_JWKS_URL>",
"MCP_OIDC_ISSUER": "<MCP_OIDC_ISSUER>",
"MCP_USER_TOKEN": "<MCP_USER_TOKEN>"
}
}
}
}Environment variables
TRINO_HOSTMCP_JWKS_URLMCP_OIDC_ISSUERMCP_USER_TOKEN
Replace the placeholders with your own credentials and keep them out of version control.