Alerts at stand-up
Maya Okafor, operations lead at BigCo, asked which alerts were firing. Memtro listed the triggered alerts with the query each watches, its condition and when it last triggered.
Redash + Memtro
What did the signups query last return, and which Redash alerts are triggered?
Memtro reads your self-hosted Redash. It shows which alerts are triggered and what they watch, reads the last cached result of a saved query, searches queries by name, SQL or tag, and reads dashboards with the query behind each widget. When asked and once an administrator has granted the action by name, it can save, edit, copy and publish queries, run a query now, which costs database compute and replaces the shared cached result, manage dashboards, and create, edit or mute alerts. Archiving a query permanently deletes its dashboard widgets and alerts, and deleting an alert is permanent.
In Memtro
What you can do with Redash in Memtro
Ask in plain English from chat, your editor, a scheduled job or your own agent. The model picks the right Redash tool, reads what it needs, and answers with the source cited.
What it does
- 01Lists alerts with their state, the query each watches, its condition and when it last triggered
- 02Reads the last cached result of a query, 50 rows by default and at most 200, and says when it was retrieved
- 03Searches saved queries by name, description, SQL or tag, and reads one query's SQL, parameters, visualisations and schedule
- 04Searches dashboards and reads their widgets with the query behind each, and lists data sources, never their connection settings
- 05When asked and granted, saves, edits, copies or publishes queries, runs a query now on its database, which costs compute and replaces the cached result, and archives a query, which permanently deletes its widgets and alerts
- 06When asked and granted, creates, renames, publishes, archives or restores dashboards, creates, edits, mutes or unmutes alerts, and permanently deletes an alert
Acts when asked
When you ask it to
These tools change something in Redash. 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.
- 01Save a new query (as a draft) on a data source
- 02Edit a query's name, SQL, description, data source or tags, or publish it
- 03Copy a query to a new one owned by Memtro's Redash user
- 04Run a saved query now on its database, replacing its cached result
- 05Archive a query, which also deletes its dashboard widgets and alerts
- 06Create an empty draft dashboard
- 07Rename, tag, publish or restore a dashboard
- 08Archive a dashboard
- 09Create an alert on a query's result
- 10Edit an alert's name, query, condition or re-arm time
- 11Mute or unmute an alert's notifications
- 12Delete an alert, permanently
Events
When it happens
Turn events on in the connection's Events tab on the Connections page, then add the address it shows as a webhook in Redash, choosing the same kinds; the tab shows Redash's own steps. Each event can start a job, with the event as its input. Redash sends a secret with every delivery, and one without it is refused.
Events and webhooks- 01An alert changed state (triggered, back to OK, or unknown)
In practice
Ask it like you would a colleague
Once Redash 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.
Redash + Memtro
Which Redash alerts are triggered?
What did the signups query last return?
Which queries mention the orders table?
What widgets are on the growth dashboard?
Run the signups query now and tell me this week's total.
Quietening a noisy alert
Dan Fletcher, growth analyst at Northwind, asked Memtro to mute the signups alert during a planned migration and raise its threshold to 50. Memtro muted the alert, so it kept evaluating without notifying subscribers, and changed its condition. Dan unmuted it the next morning through Memtro.
Teams
Where it fits
The teams that lean on Redash 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 Redash 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 automationRedash with ActiveCampaignContacts, campaigns and automations from ActiveCampaign.
- Marketing automationRedash with BrevoEmail and SMS campaign results from Brevo.
- Marketing automationRedash with Customer.ioCampaign metrics and customer journeys from Customer.io.
- Databases and warehousesRedash with PostgresRead-only SQL over your warehouse or application database, written by the model from the schema.
- Databases and warehousesRedash with MySQL and MariaDBRead-only SQL over your MySQL or MariaDB database, directly or through an SSH tunnel.
- Databases and warehousesRedash with SQL ServerAsk questions of SQL Server and Azure SQL, safely.
- CRM and salesRedash with HubSpotContacts, companies, deals and tickets, with the rest of the company's memory attached.
- CRM and salesRedash with SalesforceAsk your CRM questions in plain English, down to the SOQL.
- CRM and salesRedash 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
Lightdash
Microsoft Clarity- Chameleon
Eppo
Holistics
Mouseflow- Optimizely
- Sigma Computing
- VWO
Setup
How to connect
Connect withHost and User API key
- 1
In Redash, sign in as a dedicated user. A view-only group keeps Memtro read-only, and full access to a data source lets it save and run queries there.
- 2
Open your name (top right) → Profile → API Key and copy the key. A per-query API key will not work.
- 3
In Memtro, open Connections → Redash and paste Host (host name only) and User API key. Fill Organisation slug only if your URLs carry one, such as /acme/queries.
- 4
Ask: "Which Redash alerts are triggered?"
Also works from
Chat in the dashboard, the OpenAI-compatible API, scheduled jobs, and any MCP client: Claude Code, OpenCode, Cursor, Claude Desktop. The Redash tools are the same everywhere.
FAQ
Questions
Can Memtro change anything in Redash?+
Only when you ask, and only what it has been granted: save a new query (as a draft) on a data source; edit a query's name, SQL, description, data source or tags, or publish it; copy a query to a new one owned by Memtro's Redash user; run a saved query now on its database, replacing its cached result; archive a query, which also deletes its dashboard widgets and alerts; create an empty draft dashboard; rename, tag, publish or restore a dashboard; archive a dashboard; create an alert on a query's result; edit an alert's name, query, condition or re-arm time; mute or unmute an alert's notifications; delete an alert, permanently. 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 Redash 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 Redash 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 Redash?+
Host and User API key. In Redash, sign in as a dedicated user. A view-only group keeps Memtro read-only, and full access to a data source lets it save and run queries there.
Can Redash start a job?+
Yes. Turn events on in the connection's Events tab on the Connections page, then add the address it shows as a webhook in Redash, choosing the same kinds; the tab shows Redash's own steps. A job set to start "When an event arrives" then runs once for each matching event, with the event as its input. The run treats the event as outside data, never as instructions, and anything the run remembers is kept as unverified.
Connect Redash in a few minutes
Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.