FastMCP FastMCP
Sign In
A

Apache Doris

Integrates with Apache Doris analytical database system through MySQL protocol, enabling data queryi...

31 views
0 installs
Updated Jan 4, 2026
Not audited
Database Developer Tools
Integrates with Apache Doris analytical database system through MySQL protocol, enabling data querying and interaction for business intelligence and data analysis workflows.

  1. Open the FastMCP connection form

    • In the FastMCP UI click the "Install Now" button to open the connection / environment variables form.

  2. Prepare the four required ENV names

    • FastMCP expects these environment variable names for this MCP:
      • DORIS_HOST
      • DORIS_PORT
      • DORIS_USER
      • DORIS_PASSWORD

  3. Obtain DORIS_HOST (hostname or IP)

    • If you run Apache Doris yourself: get the Frontend (FE) node host/IP from your inventory or the FE server (the machine/container where the FE process runs).
    • If using a managed/hosted Doris service: get the endpoint/hostname from your cloud provider or the service console.
    • If unsure, ask your DBA or check the FE configuration on the server for the advertised host.

  4. Obtain DORIS_PORT (client connection port)

    • Find the Doris FE client port used for client connections in the FE configuration (look for mysql_port, query_port or similar in fe.conf) or in your cloud/hosting console.
    • If an application already connects to Doris, inspect that application’s connection string for the port.
    • If you don’t know and have admin access, log into the FE host and inspect FE config or running service to see which port accepts client connections.

  5. Obtain or create DORIS_USER and DORIS_PASSWORD

    • Option A — Get existing credentials: ask your DBA or the team that manages Doris for a user account with read/select access for the databases/tables you need.
    • Option B — Create a dedicated service user (recommended for least privilege):
      • Connect to the Doris FE as an administrative user (via the MySQL-compatible client or FE admin tools).
      • Create a new user account and set a strong password, and grant only the minimal privileges required (e.g., SELECT on needed databases).
      • Keep the new password stored securely and note the username/password for the next steps.
    • Important: use a dedicated service account with minimal privileges for FastMCP access.

  6. Test the connection locally (optional but recommended)

    • On a terminal that can reach the Doris host, run the same environment settings used by the MCP to validate connectivity. Example pattern from the README (replace placeholder values):
      • DORIS_HOST= DORIS_PORT= DORIS_USER= DORIS_PASSWORD= uv run --with mcp-doris --python 3.13 mcp-doris
    • If you prefer the development test from the README:
      • env DORIS_HOST= DORIS_PORT= DORIS_USER= DORIS_PASSWORD= mcp dev mcp_doris/mcp_server.py
    • Fix host/port/credentials if the test fails (network, firewall, user privileges).

  7. Fill the values into the FastMCP connection interface

    • In the Install Now / connection form, enter:
      • DORIS_HOST: (hostname or IP)
      • DORIS_PORT: (port number)
      • DORIS_USER: (service username)
      • DORIS_PASSWORD: (service password)
    • Mark DORIS_PASSWORD (and any sensitive fields) as a secret/hidden value if the interface supports it.
    • Save the connection.

  8. Security and operational notes

    • Use least-privilege credentials (only the necessary SELECT/READ rights).
    • Store the password as a secret or environment variable, not in plaintext in code or logs.
    • Rotate the DORIS_PASSWORD periodically and when personnel change.
    • If the FastMCP tester reports connection errors, confirm network reachability (firewall, VPC rules), correct host/port, and that the user has required privileges.

  9. If you need more details

    • If you don’t have access to server configs or admin rights, ask your Doris administrator or cloud provider for the FE endpoint, client port, and a service account with appropriate permissions before completing the Install Now form.

Quick Start

View on GitHub

More for Database

View All →

More for Developer Tools

View All →

Report Issue

Thank you! Your issue report has been submitted successfully.