Trino MCP Server in Go

Overview

Features

• MCP server implementation in Go

• Trino SQL query execution through MCP tools

• Catalog, schema, and table discovery

• Docker container support

• Supports both STDIO and HTTP transports

• Server-Sent Events (SSE) support for Cursor and other MCP clients

• Compatible with Cursor, Claude Desktop, Windsurf, ChatWise, and any MCP-compatible clients.

Installation

Homebrew (macOS and Linux)

Alternative Installation Methods

Manual Download

1. Download the appropriate binary for your platform from the GitHub Releases page.

2. Place the binary in a directory included in your PATH (e.g., /usr/local/bin on Linux/macOS)

3. Make it executable (chmod +x mcp-trino on Linux/macOS)

From Source

Downloads

MCP Integration

Using Docker Image

Note: The host.docker.internal special DNS name allows the container to connect to services running on the host machine. If your Trino server is running elsewhere, replace with the appropriate host.

Cursor

Claude Desktop

• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json

• Windows: %APPDATA%\Claude\claude_desktop_config.json

Windsurf

ChatWise

1. Open ChatWise and go to Settings

2. Navigate to the Tools section

3. Click the "+" icon to add a new tool

4. Select "Command Line MCP"

5. Configure with the following details:

1. Copy this JSON to your clipboard:

2. In ChatWise Settings > Tools, click the "+" icon

3. Select "Import JSON from Clipboard"

4. Toggle the switch next to the tool to enable it

Available MCP Tools

execute_query

"How many customers do we have per region? Can you show them in descending order?"

list_catalogs

"What databases do we have access to in our Trino environment?"

list_schemas

"What schemas or datasets are available in the tpch catalog?"

list_tables

"What tables are available in the tpch tiny schema? I need to know what data we can query."

get_table_schema

"What columns are in the customer table? I need to know the data types and structure before writing my query."

End-to-End Example

1. First, discover available catalogs

2. Then, find available schemas

3. Explore available tables

4. Check the customer table schema

5. Finally, execute the query

6. Returns the results to the user:

Configuration

Note: When TRINO_SCHEME is set to "https", TRINO_SSL is automatically set to true regardless of the provided value.

Important: The default connection mode is HTTPS. If you're using an HTTP-only Trino server, you must set TRINO_SCHEME=http in your environment variables.

Security Note: By default, only read-only queries (SELECT, SHOW, DESCRIBE, EXPLAIN) are allowed to prevent SQL injection. If you need to execute write operations or other non-read queries, set TRINO_ALLOW_WRITE_QUERIES=true, but be aware this bypasses this security protection.

For Cursor Integration: When using with Cursor, set MCP_TRANSPORT=http and connect to the /sse endpoint. The server will automatically handle SSE (Server-Sent Events) connections.

Contributing

License

CI/CD and Releases

Continuous Integration Checks

Code Quality

• Linting: Using golangci-lint to check for common code issues and style violations

• Go Module Verification: Ensuring go.mod and go.sum are properly maintained

• Formatting: Verifying code is properly formatted with gofmt

Security

• Vulnerability Scanning: Using govulncheck to check for known vulnerabilities in dependencies

• Dependency Scanning: Using Trivy to scan for vulnerabilities in dependencies (CRITICAL, HIGH, and MEDIUM)

• SBOM Generation: Creating a Software Bill of Materials for dependency tracking

• SLSA Provenance: Creating verifiable build provenance for supply chain security

Testing

• Unit Tests: Running tests with race detection and code coverage reporting

• Build Verification: Ensuring the codebase builds successfully

CI/CD Security

• Least Privilege: Workflows run with minimum required permissions

• Pinned Versions: All GitHub Actions use specific versions to prevent supply chain attacks

• Dependency Updates: Automated dependency updates via Dependabot

Release Process

1. CI checks are run to validate code quality and security

2. If successful, a new release is automatically created with:

Trino MCP Server in Go

Overview

Features

• MCP server implementation in Go

• Trino SQL query execution through MCP tools

• Catalog, schema, and table discovery

• Docker container support

• Supports both STDIO and HTTP transports

• Server-Sent Events (SSE) support for Cursor and other MCP clients

• Compatible with Cursor, Claude Desktop, Windsurf, ChatWise, and any MCP-compatible clients.

Installation

Homebrew (macOS and Linux)

Alternative Installation Methods

Manual Download

1. Download the appropriate binary for your platform from the GitHub Releases page.

2. Place the binary in a directory included in your PATH (e.g., /usr/local/bin on Linux/macOS)

3. Make it executable (chmod +x mcp-trino on Linux/macOS)

From Source

Downloads

MCP Integration

Using Docker Image

Note: The host.docker.internal special DNS name allows the container to connect to services running on the host machine. If your Trino server is running elsewhere, replace with the appropriate host.

Cursor

Claude Desktop

• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json

• Windows: %APPDATA%\Claude\claude_desktop_config.json

Windsurf

ChatWise

1. Open ChatWise and go to Settings

2. Navigate to the Tools section

3. Click the "+" icon to add a new tool

4. Select "Command Line MCP"

5. Configure with the following details:

1. Copy this JSON to your clipboard:

2. In ChatWise Settings > Tools, click the "+" icon

3. Select "Import JSON from Clipboard"

4. Toggle the switch next to the tool to enable it

Available MCP Tools

execute_query

"How many customers do we have per region? Can you show them in descending order?"

list_catalogs

"What databases do we have access to in our Trino environment?"

list_schemas

"What schemas or datasets are available in the tpch catalog?"

list_tables

"What tables are available in the tpch tiny schema? I need to know what data we can query."

get_table_schema

"What columns are in the customer table? I need to know the data types and structure before writing my query."

End-to-End Example

1. First, discover available catalogs

2. Then, find available schemas

3. Explore available tables

4. Check the customer table schema

5. Finally, execute the query

6. Returns the results to the user:

Configuration

Note: When TRINO_SCHEME is set to "https", TRINO_SSL is automatically set to true regardless of the provided value.

Important: The default connection mode is HTTPS. If you're using an HTTP-only Trino server, you must set TRINO_SCHEME=http in your environment variables.

Security Note: By default, only read-only queries (SELECT, SHOW, DESCRIBE, EXPLAIN) are allowed to prevent SQL injection. If you need to execute write operations or other non-read queries, set TRINO_ALLOW_WRITE_QUERIES=true, but be aware this bypasses this security protection.

For Cursor Integration: When using with Cursor, set MCP_TRANSPORT=http and connect to the /sse endpoint. The server will automatically handle SSE (Server-Sent Events) connections.

Contributing

License

CI/CD and Releases

Continuous Integration Checks

Code Quality

• Linting: Using golangci-lint to check for common code issues and style violations

• Go Module Verification: Ensuring go.mod and go.sum are properly maintained

• Formatting: Verifying code is properly formatted with gofmt

Security

• Vulnerability Scanning: Using govulncheck to check for known vulnerabilities in dependencies

• Dependency Scanning: Using Trivy to scan for vulnerabilities in dependencies (CRITICAL, HIGH, and MEDIUM)

• SBOM Generation: Creating a Software Bill of Materials for dependency tracking

• SLSA Provenance: Creating verifiable build provenance for supply chain security

Testing

• Unit Tests: Running tests with race detection and code coverage reporting

• Build Verification: Ensuring the codebase builds successfully

CI/CD Security

• Least Privilege: Workflows run with minimum required permissions

• Pinned Versions: All GitHub Actions use specific versions to prevent supply chain attacks

• Dependency Updates: Automated dependency updates via Dependabot

Release Process

1. CI checks are run to validate code quality and security

2. If successful, a new release is automatically created with: