Background decoration
Lemonado logo
Install

Log in if you already have an account.

Quick Info

  • Secure cloud hosting
  • Secure authentication
  • 1.0.0
  • Dec 09, 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).

search_google_ads_fields

Searches Google Ads API fields using natural language. Returns the most relevant fields based on semantic similarity to your search query.

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

AI-powered subscription intelligence. Unify customer data, track MRR/ARR, and manage your subscriber lifecycle across all billing systems for smarter growth decisions.
PubMed logo

PubMed

Search biomedical literature from MEDLINE, life science journals, and online books.
Data.gov logo

Data.gov

Instant access to thousands of U.S. government datasets. Find, understand, and leverage public data for research, development, and civic engagement through an intuitive AI.
Todoist logo

Todoist

Connect your Todoist account to manage tasks and projects with natural language.
Bria logo

Bria

Perform advanced image editing with AI, including background removal, background replacement, product placement, and HD text-to-image generation.
Nano Banana Pro logo

Nano Banana Pro

Generate and edit images using Google's Nano Banana 2; state-of-the-art image generation and editing model.

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