How to Connect Lemonado MCP to ChatGPT

OpenAI’s recently launched Developer Mode in ChatGPT. The new beta feature introduces full Model Context Protocol (MCP) client support, enabling AI models to connect to external tools and data sources through remote MCP servers. Within ChatGPT, these appear as custom connectors.

Many MCP servers support both read and write functions, allowing models to query data and perform actions within connected systems. While this opens up powerful new capabilities, it also introduces potential risks — such as unverified connectors that could alter or delete data.

Lemonado, by contrast, operates as a remote read-only MCP server. It can securely access and analyze your connected data sources (like Stripe, Google Ads, Sheets, or Postgres) without ever modifying them. This design ensures data integrity and safety while still giving ChatGPT advanced analytical power and SQL translation through natural language queries.

This guide walks you through enabling Developer Mode, adding Lemonado as a custom connector, and starting your first query. It assumes you’ve already created your Lemonado account and connected one or more data sources in your workspace.

Step 1 — Enable Developer Mode

1. Go to chatgpt.com in your browser.

2. In ChatGPT, click your profile picture → Settings

3. Navigate to Connectors → Advanced

4. Toggle on Developer Mode (beta)

Eligibility: Developer Mode is currently available in beta for Plus, Pro, Business, Enterprise, and Education accounts on the web.

Step 2 — Add the Lemonado MCP Connector

1. Go to the Connectors tab in ChatGPT settings.

2. Click Create in the top right corner.

3. Enter the following details:

(These are also available in your Lemonado workspace under AI Connectors)

• Name: Lemonado

• Remote MCP Server URL: https://mcp.lemonado.io/mcp

• Authentication: Select OAuth (recommended).

1. Click Create. You’ll be redirected to Lemonado to log in and authorize access to your chosen AI Connector.

2. After successful authentication, Lemonado will appear as a connected tool under Developer Mode.

Technical details: ChatGPT supports SSE and streaming HTTP connector protocols. Authentication options include OAuth or none (for public endpoints).

Step 3 — Test Your Connection

1. Start a new chat in ChatGPT.

2. Click the paperclip or Connectors icon in the message box.

3. Select Lemonado from the list of available connectors.

4. Try a test query, for example:

If successful, ChatGPT will retrieve data directly from your connected Lemonado workspace.

Next Steps: Start Querying Your Data

Once connected, ChatGPT can use Lemonado as a read-only data layer for natural-language analysis. Try prompts such as:

• “Show this week’s revenue compared to last month.”

• "Which Instagram campaigns drove the most Stripe subscriptions last month?”

• “Find Google Ads campaigns with the highest ROI.”

All queries run through Lemonado’s unified SQL engine, allowing you to combine and analyze data from multiple sources in one request — securely and in real time.

Best Practices

• Keep each connector scoped to the specific data it needs.

• Review Lemonado’s audit logs regularly to track data access.

• Rotate or revoke OAuth tokens periodically for security.

That’s it! You’ve now connected ChatGPT Developer Mode with Lemonado MCP, enabling secure, real-time access to your business data through natural language.

Lemonado ensures every connection remains read-only, audited, and secure, so you can explore insights confidently without ever exposing or modifying your underlying data.