Background decoration
Lemonado logo
Install

Log in if you already have an account.

Quick Info

  • Secure cloud hosting
  • Secure authentication
  • 1.0.0
  • Nov 16, 2025

Lemonado

By: Lemonado Analytics

Access and query all your business data — connect your apps, CRM, ad accounts, databases, spreadsheets, and more.

Description

Connect Lemonado to your AI assistant for seamless, AI-native access to your company’s data. Lemonado unifies databases, SaaS tools, files, and spreadsheets into a single context layer so you can query, analyze, and generate insights instantly.

What can this MCP do?

execute_sql

Executes a ClickHouse SQL query and returns the results

get_object_details

Gets details for a specific view. For regular views (type='table'), returns column details. For parameterized views (type='function'), returns parameter documentation.

list_objects

Lists views from Lemonado. Lemonado is a data platform that allows you to query and analyze data from multiple sources. Each view is a table in the database, and can be queried using the execute_sql tool. Views can be either 'table' (regular views) or 'function' (parameterized views that require parameters).

Example prompts:

Show this week’s ad performance across Google, Meta, and LinkedIn
Compare revenue from Stripe to total ad spend over the last 30 days
Find campaigns with the highest ROI based on conversions and spend
Summarize top-performing traffic sources from Google Analytics
Pull a combined report of sales, spend, and engagement from Google Sheets

Copy these prompts to get started quickly with Lemonado in your Simtheory workspace.

How It Works

1. Install the MCP

Install Lemonado from your Simtheory workspace with one click.

2. Connect Your Account

Securely authorize access to your Lemonado account.

3. Start Using

Your AI can now interact with Lemonado on your behalf.

Users also installed these MCPs

ChartMogul logo

ChartMogul

Connect to ChartMogul for subscription analytics, revenue reporting, and customer management.
Google Search logo

Google Search

Search the web with Google grounded search
Solcast logo

Solcast

Access global solar resource assessment and forecasting data for irradiance and PV power, powered by a global fleet of weather satellites.
WAN 2.2 Media Suite logo

WAN 2.2 Media Suite

Generate high-quality images and videos from text or images using WAN 2.2. Features a standard model for detailed control and a turbo model for ultra-fast video generation.
CoinGecko logo

CoinGecko

Access real-time crypto prices, DeFi pools, NFT collections, and market data.
Workspace manager logo

Workspace manager

Tools for workspace administrators to manage their workspace.

Ready to use Lemonado MCP Server?

Sign up for Simtheory and install this MCP directly into your workspace to start leveraging its capabilities.

Get Started with Simtheory