mcp-server-trino

3.4

If you are the rightful owner of mcp-server-trino and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The Trino MCP Server allows users to list and query tables via Trino using Python, leveraging the Model-Control-Protocol.

The Trino MCP Server is designed to facilitate the interaction between AI models, data, and tools using the Model-Control-Protocol (MCP). It provides a mechanism to list Trino tables as MCP resources and enables reading table contents through MCP. Additionally, it offers a tool for executing arbitrary SQL queries against Trino. Trino is a fast, distributed SQL query engine ideal for big data analytics, and this server utilizes Trino's Python client (trino.dbapi) to connect to a specified Trino host, catalog, and schema. The server requires Python 3.9+ and the necessary libraries such as trino and mcp. Configuration is managed through environment variables that specify connection details to the Trino server, including host, port, user credentials, and default catalog and schema.

Features

Lists Trino tables as MCP resources.
Reads table contents through MCP.
Executes arbitrary SQL queries against Trino.
Utilizes Trino's Python client for connectivity.
Configurable via environment variables.

Related MCP Servers

View all databases servers →

mysql_mcp_server

by designcomputer

MySQL MCP Server is a Model Context Protocol implementation that facilitates secure interaction between AI applications and MySQL databases.

mindsdb

by mindsdb

MindsDB is an open-source server that enables seamless interaction with large-scale federated data using the Model Context Protocol (MCP).

pg-mcp-server

by stuzero

unknown

mcp-server-neon

by neondatabase-labs

Neon MCP Server is an open-source tool that enables natural language interaction with Neon Postgres databases.

postgres-mcp

by crystaldba

Postgres MCP Pro is an open-source Model Context Protocol server designed to enhance database performance and management through advanced tools and features.

supabase-mcp

by supabase-community

Connect your Supabase projects to AI assistants using the Model Context Protocol (MCP) server.

notion-mcp-server

by makenotion

This project implements an MCP server for the Notion API, allowing integration with LLMs.

mcp-server-mysql

by benborla

A Model Context Protocol server for MySQL databases using NodeJS, enabling LLMs to inspect schemas and execute SQL queries.

supabase-mcp-server

by alexander-zuev

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

mcp-clickhouse

by ClickHouse

An MCP server for ClickHouse that allows executing SQL queries and managing databases and tables.

chroma-mcp

by chroma-core

Chroma MCP Server is an open-source embedding database server that facilitates the integration of LLM applications with external data sources using the Model Context Protocol.

mcp-kql-server

by 4R9UN

A Model Context Protocol (MCP) server for executing Kusto Query Language (KQL) queries against Azure Data Explorer clusters.

mcp-proxy

by TBXark

An MCP proxy server that aggregates and serves multiple MCP resource servers through a single HTTP server.

mongodb-mcp-server

by mongodb-js

A Model Context Protocol server for interacting with MongoDB Databases and MongoDB Atlas.

atlas-mcp-server

by cyanheads

ATLAS (Adaptive Task & Logic Automation System) is a project, knowledge, and task management system for LLM Agents, implemented as a Model Context Protocol (MCP) server.

developer_tools

mcp-google-sheets

by xing5

mcp-google-sheets is a Python-based MCP server that connects MCP-compatible clients to Google Sheets API for automation and data manipulation.

cloud_platforms

postg-mem

by dariogriffo

PostgMem is a .NET-based MCP server that provides vector memory storage using PostgreSQL and pgvector for AI applications.

xiyan_mcp_server

by XGenerationLab

XiYan MCP Server is a Model Context Protocol server that enables natural language queries to databases, powered by XiYan-SQL, a state-of-the-art text-to-SQL model.

mcp-alchemy

by runekaagaard

MCP Alchemy is a model context protocol server that connects Claude Desktop to various databases, enabling advanced database exploration and query execution.

mcp-server-weaviate

by weaviate

Weaviate MCP Server is a protocol server designed to interact with the Weaviate vector database, providing functionalities for inserting and querying data.

prometheus-mcp-server

by pab1it0

A Model Context Protocol (MCP) server for Prometheus, enabling access to Prometheus metrics and queries through standardized MCP interfaces.

elasticsearch-mcp-server

by cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction. This server enables searching documents, analyzing indices, and managing cluster through a set of tools.

MCPServerForMSSQL

by shakunvohradeltek

This repository contains the SQL Server MCP (Model Context Protocol) integration for Claude, allowing direct querying and analysis of SQL Server databases using natural language.

meilisearch-mcp

by meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces like Claude.

mcp-server-bigquery

by LucasHild

A Model Context Protocol server that provides access to BigQuery, enabling LLMs to inspect database schemas and execute queries.

mcp-server-aws

by rishikavikondala

AWS MCP Server is a Model Context Protocol server implementation for AWS operations, supporting S3 and DynamoDB services.

cloud_platforms

mcp-snowflake-server

by isaacwasserman

A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake.