Weekly event counts
Maya Okafor, growth analyst at Acme Ltd, asked how many events per day came in last week. Memtro checked the events data source's columns, then ran one count grouped by day on Acme's own Tinybird compute and returned seven rows.
Tinybird + Memtro
How many events per day did we get last week, straight from Tinybird?
Tinybird holds your real-time analytics data. Memtro lists your data sources with row counts, size and columns, and your pipes with whether each is published as an API endpoint. It fetches rows from a published endpoint, or runs one bounded SELECT query. When asked, and once an administrator has granted the action by name, it can run copy and sink pipes, which may overwrite a target or export to your bucket or Kafka topic, append events, permanently delete matching rows, and pause or resume copy schedules. Queries and jobs run on your own Tinybird compute and count towards your plan.
In Memtro
What you can do with Tinybird in Memtro
Ask in plain English from chat, your editor, a scheduled job or your own agent. The model picks the right Tinybird tool, reads what it needs, and answers with the source cited.
What it does
- 01List data sources with engine, sorting key, row count, size, and columns with their types, without running a query.
- 02List pipes with description, node names, which data sources they use and whether each is published as an API endpoint.
- 03Fetch rows from a published pipe endpoint with the pipe's own parameters, 20 by default and at most 100.
- 04Run one read-only SELECT or WITH query in ClickHouse SQL, answering with counts, sums and group by rather than raw rows, to spare your compute.
- 05When asked and granted, runs a copy pipe into its target, appending or overwriting, or a sink pipe that exports to your bucket or Kafka topic, on your own compute, and pauses or resumes copy schedules or cancels a waiting job.
- 06When asked and granted, appends up to 20 events to a data source, and permanently deletes rows whose column matches up to 100 values, with a dry run to count them first.
Acts when asked
When you ask it to
These tools change something in Tinybird. 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.
- 01Run a copy pipe now, appending to (or, if asked, replacing) its target data source
- 02Pause or resume a copy pipe's schedule
- 03Cancel a waiting or running job
- 04Append up to 20 events to a data source
- 05Delete the rows of a data source whose column matches up to 100 given values
- 06Run a sink pipe, exporting its result to the configured bucket or topic
In practice
Ask it like you would a colleague
Once Tinybird 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.
Tinybird + MemtroHow many events per day did we get last week?
Which Tinybird data sources are the largest by size?
What columns does the page_views data source have?
Run the top_pages endpoint for yesterday.
Run the daily_rollup copy pipe now
Removing a test account
Tom Reilly, data engineer at BigCo, asked Memtro to delete the events a load-test account had written. Memtro ran a dry run first and reported 48,210 matching rows, then on his go-ahead deleted them permanently on BigCo's Tinybird compute. Materialised views fed by those rows were left as they were.
Teams
Where it fits
The teams that lean on Tinybird 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.
- EngineeringKeep decisions from evaporatingEngineer, Tech lead, On call, New joiner“Who owns the billing migration, and what did we decide about retries?”Used alongside GitHub, Linear, Jira, Confluence, Slack and 5 more.
- FinanceAsk the ledger questions in plain EnglishFinance lead, Credit control, Management accountant, Founder or CFO“Which invoices over £5k are more than 30 days overdue?”Used alongside Xero, Stripe, Postgres, HubSpot, QuickBooks Online and 10 more.
Better together
Works with
A record in Tinybird 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.
- AnalyticsTinybird with Google Analytics 4Ask your traffic questions in plain English and get the numbers back.
- AnalyticsTinybird with Plausible AnalyticsAsk about your website traffic in plain English.
- AnalyticsTinybird with UmamiAsk about your website traffic in plain English, without sending anybody to a dashboard.
- Finance and commerceTinybird with XeroInvoices, bills, contacts and reports, answered in plain English with figures cited to Xero.
- Finance and commerceTinybird with StripeCustomers, charges, invoices and subscriptions through a restricted key.
- Finance and commerceTinybird with FellohBookings, payments, refunds, chargebacks, supplier payments and payouts from the travel payments platform.
- Work managementTinybird with JiraJQL search, issue details and projects from Jira Cloud.
- Work managementTinybird with Clio ManageAsk the matter: its client, its fee earner, the time on it and what is still unbilled.
- Work managementTinybird with LinearIssues, projects and teams, synced hourly into memory.
Also in Databases and warehouses
Using something else for the same job, or both? Each connector has its own tools; connect as many as you like.
- Postgres
- MySQL and MariaDB
- SQL Server
- BigQuery
- Snowflake
- AWS Athena
- MongoDB
- ClickHouse
- Amazon Redshift
- Databricks
- Elasticsearch
- dbt Cloud
- Fivetran
- Neon
- Appwrite
Grist- Hasura
- Meilisearch
NocoDB- Qdrant
Typesense
Weaviate
Hightouch
Census- Airbyte
- Budibase
- CockroachDB Cloud
- Cube Cloud
- DataHub
kintone
Monte Carlo
OpenMetadata- Pinecone
- PlanetScale
- Quickbase
Secoda
Softr
Teable- Turso
- Upstash
Vectara- Xata
- Zilliz Cloud
Setup
How to connect
Connect withStatic token and optional API host
- 1
In Tinybird, open your workspace → Tokens and create a static token for Memtro. Never use an ADMIN or TOKENS-scoped token.
- 2
Give it DATASOURCES:READ and PIPES:READ, for all data sources and pipes or only those Memtro may read. Only if Memtro should act, add DATASOURCES:APPEND on copy targets and event data sources, PIPES:CREATE to pause or resume copy schedules, and DATASOURCES:CREATE on data sources it may delete rows from. Copy it.
- 3
In Memtro, open Connections → Tinybird, paste it as Static token, and set API host (region) if your workspace is not on api.tinybird.co.
- 4
Ask: how many events per day did we get last 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 Tinybird tools are the same everywhere.
FAQ
Questions
Can Memtro change anything in Tinybird?+
Only when you ask, and only what it has been granted: run a copy pipe now, appending to (or, if asked, replacing) its target data source; pause or resume a copy pipe's schedule; cancel a waiting or running job; append up to 20 events to a data source; delete the rows of a data source whose column matches up to 100 given values; run a sink pipe, exporting its result to the configured bucket or topic. 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 Tinybird 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 Tinybird 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 Tinybird?+
Static token and optional API host. In Tinybird, open your workspace → Tokens and create a static token for Memtro. Never use an ADMIN or TOKENS-scoped token.
Connect Tinybird in a few minutes
Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.