T

Trino (SQL Query Engine)

Connects AI systems to Trino/Iceberg databases for SQL execution, data exploration, and table optimi...

87 views
0 installs
Updated Nov 21, 2025
Not audited
Connects AI systems to Trino/Iceberg databases for SQL execution, data exploration, and table optimization with seamless connection management and catalog navigation.
  1. Prepare Your Trino Server Connection Information
    Gather the following details for your Trino server:

    • TRINO_HOST: The hostname or IP address of your Trino server (e.g., localhost if running locally).
    • TRINO_PORT: The port Trino listens on (default is 8080).
    • TRINO_USER: The username to use for connecting (e.g., trino).
    • (Optional but recommended for full functionality):
      • TRINO_PASSWORD: The password for your Trino user (if set up).
      • TRINO_CATALOG: The default catalog to use.
      • TRINO_SCHEMA: The default schema to use.
      • TRINO_HTTP_SCHEME: The protocol to use, usually http or https (http by default).
  2. Open the FastMCP Connection Interface

    • Use the “Install Now” button in your system to begin adding the integration.
    • Navigate to the FastMCP connection or environment variable setup prompt that appears once you start the installation.
  3. Fill in the Environment Values

    • Enter the required fields in the FastMCP form using your Trino server’s information:
      • TRINO_HOST → your Trino server hostname (e.g., localhost)
      • TRINO_PORT → your Trino port (e.g., 8080)
      • TRINO_USER → your username (e.g., trino)
      • (Optional, if your server requires authentication or more context):
        • TRINO_PASSWORD → your password (leave empty if not needed)
        • TRINO_CATALOG → your catalog (leave empty for default)
        • TRINO_SCHEMA → your schema (leave empty for default)
        • TRINO_HTTP_SCHEMEhttp or https (typically http)
  4. Save and Complete the Installation

    • After entering all the values, click to save or continue.
    • Confirm the connection in FastMCP; it will test to ensure the credentials are correct.
  5. Access and Use the Integration

    • Once installed, you can use the provided tools to query and explore your Trino database via the integration.

Tip: If you have not yet set up your Trino server, you can run a local instance using Docker Compose by running docker-compose up -d in a directory with the correct docker-compose.yml for Trino.

No special token or API key is needed beyond your Trino login credentials.

Quick Start

View on GitHub

More for Database

View All →

More for Analytics and Data

View All →

Similar MCP Servers

T

Turso SQLite

Provides a bridge between AI assistants and Turso SQLite databases, enabling organization-level management and database-level queries with persistent context, schema exploration, and vector similarity search capabilities.

Database AI and Machine Learning
176
0

Report Issue

Thank you! Your issue report has been submitted successfully.