Skip to main content
StarTree provides an ability to deploy a MCP server within the environment. This can be leveraged for various agentic workflows and conversational analytics use cases. StarTree MCP This MCP server is based off of OSS GitHub - startreedata/mcp-pinot: MCP Server for Apache Pinot and exposes several tools such as: list_tables, table_details, create_schema, read_query etc. It provides OAuth based authentication flow for the clients.
Once, deployed, MCP server will be available at https://mcp.<domain>/mcp
For installation - please reach out to your StarTree representative.

Conversational Queries on Startree

One common pattern we see is use of this MCP server in conversational analytics on top of Pinot and StarTree. You can hook up this MCP server to your favorite AI tool: Claude, Librechat and be able to simply ask natural language questions against the Pinot table.

Example: Claude Code

  • Install claude code: Quickstart - Claude Docs
  • Add mcp server and use it following: Connect Claude Code to tools via MCP - Claude Docs
    • Ex: claude mcp add --transport http pinot-mcp https://mcp.<domain>/mcp
  • In Claude code, use the command /mcp to authenticate with StarTree MCP server
  • Start asking questions. For example, in our demo clickstream Pinot table, we asked this question: “For clickstream table in Pinot, what’s the conversion rate ?” Here’s the output from Claude Code
Claude Code Output Pn

Limitations

  • At the moment (Nov, 2025) MCP server with OAuth does not seem to work with Claude desktop because of an existing bug.