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 through a standardized Model Context Protocol (MCP) server.
iceberg-mcp
Serves as an MCP server providing metadata about Apache Iceberg catalogs.
duckdb_mcp
Integrate SQL databases with AI assistants (e.g., Claude) using the Model Context Protocol (MCP) for data querying, tool execution, and resource management.
enhanced-postgres-mcp-server
This server acts as a Model Context Protocol interface for PostgreSQL, enabling LLMs to query data, modify records, and manage database schema objects with read and write capabilities.