Trino MCP Server
Expose Trino tables and querying via the Model Context Protocol.
Key Features
Use Cases
README
Trino MCP Server
This repository provides an MCP (Model-Control-Protocol) server that allows you to list and query tables via Trino using Python.
Overview
- MCP: MCP is a protocol for bridging AI models, data, and tools. This example MCP server provides:
- A list of Trino tables as MCP resources
- Ability to read table contents through MCP
- A tool for executing arbitrary SQL queries against Trino
- Trino: A fast, distributed SQL query engine for big data analytics. This server makes use of Trino’s Python client (trino.dbapi) to connect to a Trino host, catalog, and schema.
Requirements
- Python 3.9+ (or a version compatible with mcp, trino, and asyncio)
- trino (the Python driver for Trino)
- mcp (the Model-Control-Protocol Python library)
Configuration
The server reads Trino connection details from environment variables:
| Variable | Description | Default |
|---|---|---|
TRINO_HOST |
Trino server hostname or IP | localhost |
TRINO_PORT |
Trino server port | 8080 |
TRINO_USER |
Trino user name | required |
TRINO_PASSWORD |
Trino password (optional, depends on your authentication setup) | (empty) |
TRINO_CATALOG |
Default catalog to use (e.g., hive, tpch, postgresql, etc.) |
required |
TRINO_SCHEMA |
Default schema to use (e.g., default, public, etc.) |
required |
Usage
{
"mcpServers": {
"trino": {
"command": "uv",
"args": [
"--directory",
"<path_to_mcp_server_trino>",
"run",
"mcp_server_trino"
],
"env": {
"TRINO_HOST": "<host>",
"TRINO_PORT": "<port>",
"TRINO_USER": "<user>",
"TRINO_PASSWORD": "<password>",
"TRINO_CATALOG": "<catalog>",
"TRINO_SCHEMA": "<schema>"
}
}
}
}
Star History
Repository Owner
Organization
Repository Details
Programming Languages
Tags
Join Our Newsletter
Stay updated with the latest AI tools, news, and offers by subscribing to our weekly newsletter.
Related MCPs
Discover similar Model Context Protocol servers
mcp-trino
A fast Go-based MCP server for seamless Trino SQL access.
mcp-trino is a Model Context Protocol (MCP) server implemented in Go, designed for high-performance integration with Trino's distributed SQL engine. It enables AI assistants and clients to issue SQL queries, discover catalogs, schemas, and tables, and fetch schema information through standardized MCP tools over HTTP and STDIO transports. The solution supports optional OAuth2 authentication, connects to a variety of data sources through Trino, and is available as a Docker container.
- ⭐ 79
- MCP
- tuannvm/mcp-trino
Hydrolix MCP Server
MCP server for secure, efficient SQL access to Hydrolix clusters.
Hydrolix MCP Server provides a Model Context Protocol (MCP) interface for executing SQL queries, listing databases, and listing tables on Hydrolix clusters. It ensures safe, read-only data access and includes a standardized health-check endpoint. The server integrates easily with various MCP-compatible clients, supporting multiple authentication methods using either credentials or service account tokens.
- ⭐ 5
- MCP
- hydrolix/mcp-hydrolix
Snowflake MCP Server
MCP server enabling secure and structured Snowflake database interaction with AI tools.
Snowflake MCP Server provides a Model Context Protocol-conformant interface to interact programmatically with Snowflake databases. It exposes SQL execution, schema exploration, and insight aggregation as standardized resources and tools accessible by AI assistants. The server offers read/write capabilities, structured resource summaries, and insight memoization suitable for contextual AI workflows. Integration is supported with popular AI platforms such as Claude Desktop via Smithery or UVX configurations.
- ⭐ 170
- MCP
- isaacwasserman/mcp-snowflake-server
Databricks MCP Server
Expose Databricks data and jobs securely with Model Context Protocol for LLMs.
Databricks MCP Server implements the Model Context Protocol (MCP) to provide a bridge between Databricks APIs and large language models. It enables LLMs to run SQL queries, list Databricks jobs, retrieve job statuses, and fetch detailed job information via a standardized MCP interface. The server handles authentication, secure environment configuration, and provides accessible endpoints for interaction with Databricks workspaces.
- ⭐ 42
- MCP
- JordiNeil/mcp-databricks-server
Multi-Database MCP Server (by Legion AI)
Unified multi-database access and AI interaction server with MCP integration.
Multi-Database MCP Server enables seamless access and querying of diverse databases via a unified API, with native support for the Model Context Protocol (MCP). It supports popular databases such as PostgreSQL, MySQL, SQL Server, and more, and is built for integration with AI assistants and agents. Leveraging the MCP Python SDK, it exposes databases as resources, tools, and prompts for intelligent, context-aware interactions, while delivering zero-configuration schema discovery and secure credential management.
- ⭐ 76
- MCP
- TheRaLabs/legion-mcp
TeslaMate MCP Server
Query your TeslaMate data using the Model Context Protocol
TeslaMate MCP Server implements the Model Context Protocol to enable AI assistants and clients to securely access and query Tesla vehicle data, statistics, and analytics from a TeslaMate PostgreSQL database. The server exposes a suite of tools for retrieving vehicle status, driving history, charging sessions, battery health, and more using standardized MCP endpoints. It supports local and Docker deployments, includes bearer token authentication, and is intended for integration with MCP-compatible AI systems like Claude Desktop.
- ⭐ 106
- MCP
- cobanov/teslamate-mcp
Didn't find tool you were looking for?