Trino Server

Remote

Scanned

API Integration

Integrate this MCP server into your applications.

Get your API Key

You'll need to login and generate a Smithery API key to connect to this server.

Installation

Install the official MCP SDKs using npm:

bash

npm install @modelcontextprotocol/sdk @smithery/sdk

TypeScript SDK

typescript


import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp.js"
import { createSmitheryUrl } from "@smithery/sdk"

const config = {
  "trinoHost": "localhost",
  "trinoPort": 8080,
  "trinoUser": "trino",
  "trinoSchema": "",
  "trinoCatalog": "",
  "trinoPassword": "",
  "trinoHttpScheme": "http"
}
const serverUrl = createSmitheryUrl("https://server.smithery.ai/@alaturqua/mcp-trino-python", config, "your-smithery-api-key")

const transport = new StreamableHTTPClientTransport(serverUrl)

// Create MCP client
import { Client } from "@modelcontextprotocol/sdk/client/index.js"

const client = new Client({
	name: "Test client",
	version: "1.0.0"
})
await client.connect(transport)

// Use the server tools with your LLM application
const tools = await client.listTools()
console.log(`Available tools: ${tools.map(t => t.name).join(", ")}`)

Configuration Schema

Full JSON Schema for server configuration:

json

{
  "type": "object",
  "required": [
    "trinoHost",
    "trinoPort",
    "trinoUser"
  ],
  "properties": {
    "trinoHost": {
      "type": "string",
      "default": "localhost",
      "description": "Trino server hostname"
    },
    "trinoPort": {
      "type": "number",
      "default": 8080,
      "description": "Trino server port"
    },
    "trinoUser": {
      "type": "string",
      "default": "trino",
      "description": "Trino username"
    },
    "trinoSchema": {
      "type": "string",
      "default": "",
      "description": "Default Trino schema (optional)"
    },
    "trinoCatalog": {
      "type": "string",
      "default": "",
      "description": "Default Trino catalog (optional)"
    },
    "trinoPassword": {
      "type": "string",
      "default": "",
      "description": "Trino password for authentication (optional)"
    },
    "trinoHttpScheme": {
      "type": "string",
      "default": "http",
      "description": "HTTP scheme, e.g., http or https"
    }
  }
}