Back to Home
alaturqua icon

mcp-trino-python

Verified Safe

by alaturqua

Overview

The MCP Trino Server provides seamless integration with Trino and Iceberg for advanced data exploration, querying, and table maintenance capabilities through a standard interface.

Installation

Run Command
uv run src/server.py

Environment Variables

  • TRINO_HOST
  • TRINO_PORT
  • TRINO_USER
  • TRINO_CATALOG
  • TRINO_SCHEMA
  • TRINO_HTTP_SCHEME
  • TRINO_PASSWORD

Security Notes

The server executes SQL queries provided by tools or constructed using f-strings for identifiers (table/schema/catalog names). This design poses a SQL injection risk if the inputs to the MCP tools are not adequately sanitized by the calling client or AI model. Specifically, the `execute_query` tool accepts raw SQL, and other tools embed string parameters directly into queries. Environment variables are correctly used for sensitive configuration (e.g., TRINO_PASSWORD) via python-dotenv. HTTP transports expose network ports, requiring proper network security if deployed publicly. The server itself is not inherently malicious, but its interaction with Trino requires careful input validation from upstream consumers.

Similar Servers

Stats

Interest Score40
Security Score6
Cost ClassMedium
Avg Tokens1500
Stars20
Forks12
Last Update2025-12-01

Tags

TrinoIcebergData ExplorationData MaintenanceModel Context ProtocolSQL