mcp-trino-python
Verified Safeby 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
uv run src/server.pyEnvironment 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
mcp-trino
Enables AI assistants to interact with Trino's distributed SQL query engine for data analytics, offering metadata discovery and query execution.
iceberg-mcp
Serves as an MCP server providing metadata about Apache Iceberg catalogs.
duckdb_mcp
Integrate SQL databases with Model Context Protocol (MCP) servers, enabling DuckDB to act as both an MCP client (consuming resources/tools) and an MCP server (publishing data/tools).
mcp-mysql-server
Provides an MCP-compliant interface for AI models to securely interact with a MySQL database for CRUD operations, schema inspection, and performance analysis.