AI导哈

数据访问MCP服务器

Lemonado MCP服务器将外部AI应用安全地连接到Lemonado中已接入的企业数据，通过对象发现、只读SQL查询和连接器操作，支持AI辅助的数据分析与洞察。

  • by lemonadolabs
  • 云端部署
  • 2 星标
  • 更新于
在 GitHub 查看 lemonadolabs/lemonado-mcp-server

使用说明

Lemonado MCP server

Connect an external AI app to the data you have connected to Lemonado. Your connection determines which companies, sources, and tools the app can access.

Connect

  1. Open your company in Lemonado.
  2. Click the gear beside its name and choose External access.
  3. Turn the connection on, select your AI app, and follow the setup instructions.
  4. Ask the app to list the sources or accounts available through the connection.

A workspace owner or admin enables access. Follow the guide for OAuth or, where offered, a generated bearer token. Check the token's selected expiry and keep it private.

MCP server address

For a custom MCP connection, use:

https://mcp.lemonado.io/mcp

Configure a remote Streamable HTTP server in your client.

For ChatGPT or Claude, select your app in Lemonado's External access settings and follow its guide. Directory connections are available once Lemonado is published in the app's directory.

Tools

The general /mcp address provides:

  • list_objects, get_object_details, and execute_sql for discovering and querying data.
  • get_google_ads_resource_metadata for Google Ads schema discovery.
  • Company discovery and connector-action tools where the connection's scope and features allow them.

See the MCP reference for inputs, aliases, execution policies, and result limitations. Your client's tool list reflects the tools available to your connection; clients may add a prefix to their displayed names.

AI, memory, and permissions

  • SQL calls: Lemonado executes the query and returns data. The external AI app interprets it.
  • Dedicated integrations: The ChatGPT and Claude integrations offer read-only analysis tools that run AI inside Lemonado. See integration details for their separate tool catalog and technical addresses.
  • Memory: These tools do not load or edit the memory files or instructions saved in Lemonado. Give the external AI app the relevant context separately, and include it in analysis questions when needed.
  • Writes: SQL queries are read-only. The general MCP connection can also expose execute_action, which may perform writes allowed by a connector's policy. Actions requiring approval return an error instead of running through an external MCP client.
  • Scope: Requests remain subject to the connection's allowed companies, sources, and permissions. A supplied account ID does not grant access.

To stop access, turn off the connection in the company's External access settings.

Troubleshooting and support

For missing tools, verify the server address and refresh tool discovery. For missing data, check the selected company, account, dates, and returned warnings. A partial result or query failure is not a measured zero.

See access and troubleshooting, or contact support@lemonado.io. Include the server address, tool name, and error message, but never your token.

相关 MCP