optimize
How to use it
optimize is exposed by the MCP Trino Python MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the optimize tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install MCP Trino Python
$
npx -y @smithery/cli install @alaturqua/mcp-trino-python --client claudeOther tools in MCP Trino Python (29)
all_snapshots
Include all snapshots (boolean, optional)
catalog
Catalog name (string, required)
describe_table
execute_query
expire_snapshots
limit
Maximum number of queries to return (number, optional)
optimize_manifests
query
SQL query to execute (string, required)
retention_threshold
Age threshold (e.g., "7d") (string, optional)
schema
Schema name (string, required)
show_catalog_tree
show_catalogs
show_create_table
show_create_view
show_entries
show_files
show_manifests
show_metadata_log_entries
show_partitions
show_query_history
show_refs
show_schemas
show_snapshots
show_stats
show_table_history
show_table_properties
show_tables
table
Table name (string, required)
view
View name (string, required)