How do I install the mcp trino python mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `TRINO_HOST`, `TRINO_PORT`, `TRINO_USER` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

MCP Trino Python MCP Server

The MCP Trino Server is a [Model Context Protocol (MCP)](https://modelcontextprotocol.io/introduction) server that provides seamless integration with

Local serverstdioPython

What is the MCP Trino Python MCP Server?

The MCP Trino Server is a Model Context Protocol (MCP) server that provides seamless integration with Trino and Iceberg, enabling advanced data exploration, querying, and table maintenance capabilities through a standard interface.

Requirements

A running Trino server (or Docker Compose for local development) 2. Python 3.12 or higher 3. Docker (optional, for containerized deployment)

Practical notes

Maintained by alaturqua, written in Python.

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
show_catalogs	List all available catalogs
show_schemas	List all schemas in a catalog
Parameters:	limit: Maximum number of queries to return (number, optional)
show_tables	List all tables in a schema
schema	Schema name (string, optional)
describe_table	Show detailed table structure and column information
catalog	Catalog name (string, optional)
execute_query	Execute a SQL query and return formatted results
show_catalog_tree	Show a hierarchical tree view of catalogs, schemas, and tables
show_create_table	Show the CREATE TABLE statement for a table
show_create_view	Show the CREATE VIEW statement for a view
show_stats	Show statistics for a table
optimize	Optimize an Iceberg table by compacting small files
optimize_manifests	Optimize manifest files for an Iceberg table
expire_snapshots	Remove old snapshots from an Iceberg table
retention_threshold	Age threshold (e.g., "7d") (string, optional)
show_table_properties	Show Iceberg table properties
show_table_history	Show Iceberg table history/changelog
show_metadata_log_entries	Show Iceberg table metadata log entries
show_snapshots	Show Iceberg table snapshots
show_manifests	Show Iceberg table manifests for current or all snapshots
all_snapshots	Include all snapshots (boolean, optional)
show_partitions	Show Iceberg table partitions
show_files	Show Iceberg table data files in current snapshot
show_entries	Show Iceberg table manifest entries for current or all snapshots
show_refs	Show Iceberg table references (branches and tags)
show_query_history	Get the history of executed queries

How to install the MCP Trino Python MCP Server

{
  "mcpServers": {
    "trino": {
      "command": "python",
      "args": [
        "./src/server.py"
      ],
      "env": {
        "TRINO_HOST": "your-trino-host",
        "TRINO_PORT": "8080",
        "TRINO_USER": "trino"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

A running Trino server (or Docker Compose for local development) 2. Python 3.12 or higher 3. Docker (optional, for containerized deployment)

Variable	Description	Required
TRINO_HOST	Declared in the maintainer’s client configuration.	Check documentation
TRINO_PORT	Declared in the maintainer’s client configuration.	Check documentation
TRINO_USER	Declared in the maintainer’s client configuration.	Check documentation

Example prompts to try

“Use MCP Trino Python to show catalogs.”
“Use MCP Trino Python to show schemas.”
“Use MCP Trino Python to Parameters.”

Frequently asked questions

The MCP Trino Server is a [Model Context Protocol (MCP)](https://modelcontextprotocol.io/introduction) server that provides seamless integration with Trino and Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.