The MCP Trino Server is a [Model Context Protocol (MCP)](https://modelcontextprotocol.io/introduction) server that provides seamless integration with
If you want an AI assistant working directly with MCP Trino Python, the mcp trino python mcp server is the bridge. 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.
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.
Once connected, the assistant can call these 12 tools directly:
show_catalogs — List all available catalogsshow_schemas — List all schemas in a catalogParameters — - catalog: Catalog name (string, required)show_tables — List all tables in a schemaschema — Schema name (string, required)describe_table — Show detailed table structure and column informationcatalog — Catalog name (string, optional)execute_query — Execute a SQL query and return formatted resultsshow_catalog_tree — Show a hierarchical tree view of catalogs, schemas, and tablesshow_create_table — Show the CREATE TABLE statement for a tableshow_create_view — Show the CREATE VIEW statement for a viewshow_stats — Show statistics for a tableThe server is distributed via npm as @smithery/cli, so most clients can run it without a manual build step. Add it to your MCP client's configuration and restart the client to pick it up — the copy-paste configs for Claude Desktop, Claude Code and Cursor are on this page.
The server reads 3 environment variables: TRINO_HOST, TRINO_PORT, TRINO_USER. Keep credentials in your client's env block or a secrets manager rather than committing them.
Database servers turn schema archaeology and ad-hoc reporting into conversation, which is why they tend to be the second or third server people install. MCP Trino Python sits in that group, and the shape of its toolset — show_catalogs, show_schemas, Parameters among others — tells you what it is really for. Worth comparing against the other databases servers in this directory before you commit to one, since several overlap in scope but differ sharply in setup cost and permissions.
| Tool | What it does |
|---|---|
| show_catalogs | List all available catalogs |
| show_schemas | List all schemas in a catalog |
| Parameters | - catalog: Catalog name (string, required) |
| show_tables | List all tables in a schema |
| schema | Schema name (string, required) |
| 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 |
{
"mcpServers": {
"trino-python": {
"command": "npx",
"args": ["-y", "@smithery/cli"],
"env": {
"TRINO_HOST": "your-value",
"TRINO_PORT": "your-value",
"TRINO_USER": "your-value"
}
}
}
}Add to claude_desktop_config.json, then restart Claude Desktop.
| Variable | Description | Required |
|---|---|---|
| TRINO_HOST | Endpoint or connection string the server talks to. | Optional |
| TRINO_PORT | Configuration value read at startup. | Optional |
| TRINO_USER | Configuration value read at startup. | Optional |
Read-only SQL access to Postgres — let your assistant inspect schemas and answer questions from real data.
Manage your whole Supabase project in conversation — database, auth, storage, Edge Functions and branches.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.
Serverless Postgres with database branching — point your assistant at Neon and let it work on disposable copies.