MCP.so
Sign In

Trino MCP Server

@Dataring-engineering

Basic information

Category

Other

Last updated

License

MIT

Transports

stdio

Author

Dataring-engineering

About Trino MCP Server

MCP Server for Trino

Trino MCP Server config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

Trino MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Trino MCP Server?

A Model Context Protocol (MCP) server that lists and queries tables via Trino using Python. It provides Trino tables as MCP resources, allows reading their contents, and includes a tool for executing arbitrary SQL queries against Trino. Designed for AI models that need to interact with Trino’s fast, distributed SQL query engine for big data analytics.

How to use Trino MCP Server?

Configure connection via environment variables (TRINO_HOST, TRINO_PORT, TRINO_USER, TRINO_PASSWORD, TRINO_CATALOG, TRINO_SCHEMA), then add the server to your MCP client configuration using uv as the command. The server reads these variables at startup and connects to the specified Trino host, catalog, and schema.

Key features of Trino MCP Server

  • Lists Trino tables as MCP resources.
  • Reads table contents through MCP.
  • Provides a tool for arbitrary SQL queries.
  • Connects to any Trino host, catalog, and schema.
  • Uses the official Trino Python driver (trino.dbapi).

Use cases of Trino MCP Server

  • Query big data analytics datasets via AI assistants.
  • Explore available tables and schemas in a Trino cluster.
  • Enable natural language querying of Trino data through MCP‑compatible clients.

Frequently asked questions

1

What Python version and dependencies are required?

Python 3.9+ and the packages `trino`, `mcp`, and `asyncio`.

2

How do I configure the connection to Trino?

Set the environment variables `TRINO_HOST`, `TRINO_PORT`, `TRINO_USER`, `TRINO_CATALOG`, and `TRINO_SCHEMA`. `TRINO_PASSWORD` is optional depending on your authentication setup.

3

Can I use authentication other than a password?

The server supports an optional password via the `TRINO_PASSWORD` variable, but the README does not describe other authentication methods.

4

What operations can the server perform?

It can list available Trino tables, read their contents, and execute arbitrary SQL queries through MCP.

5

Where do the environment variables default to?

`TRINO_HOST` defaults to `localhost`, `TRINO_PORT` defaults to `8080`. All other connection variables are required except `TRINO_PASSWORD`, which defaults to empty.

Comments

More Other MCP servers