Server Details
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
- Status
- Healthy
- Last Tested
- Transport
- Streamable HTTP
- URL
Available Tools
6 toolsexecute_sqlTry in Inspector
Executes a ClickHouse SQL query and returns the results
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes |
find_google_ads_resourceTry in Inspector
Finds the best matching Google Ads resource using natural language search. Returns complete resource schemas including native attributes, attributed resources, metrics, and segments. Use this to understand what fields and metrics are available for a specific Google Ads resource like campaigns, ad groups, ads, etc.
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Number of results to return (default: 5, max: 10) | |
| query | Yes | Natural language search term for Google Ads resources (e.g. 'campaign', 'ad group', 'customer', 'ad', 'keyword') |
get_client_detailsTry in Inspector
Retrieve detailed information about a client, including source bindings and identifiers.
| Name | Required | Description | Default |
|---|---|---|---|
| clientId | Yes |
get_object_detailsTry in Inspector
Gets details for a specific view. For regular views (type='table'), returns column details. For parameterized views (type='function'), returns parameter documentation.
| Name | Required | Description | Default |
|---|---|---|---|
| viewName | Yes |
list_clientsTry in Inspector
List clients configured in this Lemonado workspace along with their linked data sources and identifier bindings.
| Name | Required | Description | Default |
|---|---|---|---|
No parameters | |||
list_objectsTry in Inspector
Lists data sources already connected to Lemonado. Use this to find existing tables/views before querying; do not use it to see what integrations can be connected.
| Name | Required | Description | Default |
|---|---|---|---|
No parameters | |||
FAQ
How do I claim this server?
To claim this server, publish a /.well-known/glama.json file on your server's domain with the following structure:
The email address must match the email associated with your Glama account. Once verified, the server will appear as claimed by you.
What are the benefits of claiming a server?
- Control your server's listing on Glama, including description and metadata
- Receive usage reports showing how your server is being used
- Get monitoring and health status updates for your server