What changed this week
Priya Sharma, head of data at Northwind, asked which dashboards changed this week. Memtro searched across projects sorted by last update and listed each dashboard with who created it, its space and its views.
Lightdash + Memtro
Which Lightdash dashboards changed this week, and what charts are in the Finance space?
Memtro reads your Lightdash projects. It searches charts, dashboards and spaces by name, with who created each, when it last changed and its views, and lists explores, including which have compile errors. When asked and once an administrator has granted the action by name, it can create or rename spaces, create or duplicate dashboards, roll back a chart, comment on a tile, pause, resume or send a scheduled delivery now, and refresh a project's dbt build. A send may email people outside the company and cannot be recalled. Deleting a space, dashboard, chart or schedule is permanent.
In Memtro
What you can do with Lightdash in Memtro
Ask in plain English from chat, your editor, a scheduled job or your own agent. The model picks the right Lightdash tool, reads what it needs, and answers with the source cited.
What it does
- 01Searches charts, dashboards and spaces by name across projects, sorted by last update to show what changed recently
- 02Lists a project's dashboards and saved charts with space, last updated, views and chart kind
- 03Lists spaces with their path and contents, and explores by name and group with which have compile errors
- 04When asked and granted, creates or renames spaces, creates or duplicates dashboards, rolls a chart back to an earlier version, and comments on a tile, notifying only people mentioned
- 05When asked and granted, sends a scheduled delivery now, which may reach people outside the company and cannot be recalled, pauses or resumes one, and refreshes a project's dbt build
- 06When asked and granted, permanently deletes a space with its contents, a dashboard, a saved chart or a scheduled delivery
Acts when asked
When you ask it to
These tools change something in Lightdash. The model is told to use them only when you ask for exactly that, and an administrator grants each one by name to the teams that may use it; a personal connection acts only after its owner allows it.
- 01Create a space in a project
- 02Rename a space
- 03Delete a space and what is in it, permanently
- 04Create an empty dashboard, or duplicate an existing one
- 05Delete a dashboard, permanently
- 06Delete a saved chart, permanently, which removes it from dashboards
- 07Roll a saved chart back to an earlier version
- 08Send a scheduled delivery now to all of its recipients
- 09Pause or resume a scheduled delivery
- 10Delete a scheduled delivery, permanently
- 11Refresh a project's dbt build so explores pick up model changes
- 12Comment on a dashboard tile, optionally mentioning people
In practice
Ask it like you would a colleague
Once Lightdash is connected, these are the kinds of things people ask. Plain questions, no syntax. If the answer lives partly in another system you have connected, Memtro looks there too.
Lightdash + MemtroWhich dashboards changed this week?
What charts are in the Finance space?
Which explores have compile errors?
Who created the churn dashboard, and how many views does it have?
Refresh the analytics project so the new orders model shows up.
Picking up a model change
Tom Reilly, an analytics engineer at Acme Ltd, merged a new orders model and asked Memtro to refresh the project. Memtro started the dbt refresh as a background job, then listed the explores once it finished and confirmed none had compile errors.
Teams
Where it fits
The teams that lean on Lightdash most, a question each of them asks, and what they connect beside it.
- Data and analyticsQuestions answered from the warehouse, with the SQL shownAnalyst, Data engineer, Anybody with a question, Head of data“Revenue by segment for Q3 from the warehouse, with the SQL you used”Used alongside Postgres, Stripe, Slack, Google Drive, Snowflake and 3 more.
- MarketingSpend, leads and reputation in one conversationMarketing lead, Performance marketer, Content and SEO, Brand and community“How did last week's LinkedIn and Google campaigns do, and which leads reached the pipeline?”Used alongside Google Ads, Meta Ads, HubSpot, Google Analytics 4, Brevo and 7 more.
- LeadershipOne question across the whole companyFounder, Chief executive, Department head, Board member“What happened with our top ten accounts this week, and is anything at risk?”Used alongside HubSpot, Help Scout, Xero, Stripe, Linear and 6 more.
Better together
Works with
A record in Lightdash is rarely the whole story. Connect the systems that hold the rest and Memtro checks them together, then remembers what it learned so the next question starts further along.
- Marketing automationLightdash with ActiveCampaignContacts, campaigns and automations from ActiveCampaign.
- Marketing automationLightdash with BrevoEmail and SMS campaign results from Brevo.
- Marketing automationLightdash with Customer.ioCampaign metrics and customer journeys from Customer.io.
- Databases and warehousesLightdash with PostgresRead-only SQL over your warehouse or application database, written by the model from the schema.
- Databases and warehousesLightdash with MySQL and MariaDBRead-only SQL over your MySQL or MariaDB database, directly or through an SSH tunnel.
- Databases and warehousesLightdash with SQL ServerAsk questions of SQL Server and Azure SQL, safely.
- CRM and salesLightdash with HubSpotContacts, companies, deals and tickets, with the rest of the company's memory attached.
- CRM and salesLightdash with SalesforceAsk your CRM questions in plain English, down to the SOQL.
- CRM and salesLightdash with Twenty CRMObjects, fields and records from the open-source CRM, and records it can create and change when you ask.
Also in Analytics
Using something else for the same job, or both? Each connector has its own tools; connect as many as you like.
- Google Analytics 4
- Plausible Analytics
- Umami
- Google Search Console
- Segment
- App Store Connect
- Google Play Console
- Power BI
- Metabase
- Mixpanel
- Amplitude
- PostHog
- Baremetrics
- ChartMogul
- Fathom Analytics
- Matomo
CallRail
Fullstory- Pendo
WhatConverts- Tableau
- Qualtrics
- Looker
- Redash
Microsoft Clarity- Chameleon
Eppo
Holistics
Mouseflow- Optimizely
- Sigma Computing
- VWO
Setup
How to connect
Connect withHost and Personal access token
- 1
In Lightdash, sign in as a dedicated user and open Settings → Personal access tokens → Generate new token. The viewer role keeps Memtro read-only, editor lets it change content and schedules, developer lets it refresh a project.
- 2
Copy the token. It acts with every permission of that user and stops working if they leave the organisation.
- 3
In Memtro, open Connections → Lightdash and paste Host (host name only, such as <name>.lightdash.cloud) and Personal access token.
- 4
Ask: "Which dashboards changed this week?"
Also works from
Chat in the dashboard, the OpenAI-compatible API, scheduled jobs, and any MCP client: Claude Code, OpenCode, Cursor, Claude Desktop. The Lightdash tools are the same everywhere.
FAQ
Questions
Can Memtro change anything in Lightdash?+
Only when you ask, and only what it has been granted: create a space in a project; rename a space; delete a space and what is in it, permanently; create an empty dashboard, or duplicate an existing one; delete a dashboard, permanently; delete a saved chart, permanently, which removes it from dashboards; roll a saved chart back to an earlier version; send a scheduled delivery now to all of its recipients; pause or resume a scheduled delivery; delete a scheduled delivery, permanently; refresh a project's dbt build so explores pick up model changes; comment on a dashboard tile, optionally mentioning people. Every other tool reads, searches or lists. The Connections page labels the tools that act, an administrator grants each one by name to the teams that may use it, and a personal connection acts only after its owner allows it.
Who can use a Lightdash connection?+
A personal connection serves only your own requests. A shared connection serves the organisation: everyone, or only the teams an admin chooses. Admins can always add shared connections; other members need the permission.
Does Memtro store my Lightdash data?+
Credentials are encrypted at rest. Tool results are cached briefly so agent loops do not repeat identical calls, and the facts the model extracts are saved to your organisation's memory with provenance (system, record and link) so they can be checked and superseded.
How do I connect Lightdash?+
Host and Personal access token. In Lightdash, sign in as a dedicated user and open Settings → Personal access tokens → Generate new token. The viewer role keeps Memtro read-only, editor lets it change content and schedules, developer lets it refresh a project.
Connect Lightdash in a few minutes
Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.