A quick count
The operations lead asks how many returns are waiting for inspection. Memtro counts rows in the Returns table where status is Received and answers 23, with the oldest from Brightwave Ltd logged on 28 October.
NocoDB + Memtro
Ask how many rows in a NocoDB table match a condition, or read one record.
Connect NocoDB with an API token and Memtro reads your workspaces, bases, tables and fields, and rows filtered, sorted and counted with NocoDB's where syntax. The token acts as you, with your access to every workspace and base, and there is no hourly sync. When you ask, and once an administrator has granted them by name, it can add, change, upsert and link rows, comment, create bases, tables and fields, and run button actions or manual workflows, which may send messages or call outside services. Deleting rows, fields or tables is permanent.
In Memtro
What you can do with NocoDB in Memtro
Ask in plain English from chat, your editor, a scheduled job or your own agent. The model picks the right NocoDB tool, reads what it needs, and answers with the source cited.
What it does
- 01Workspaces and their bases, and the tables in each base
- 02A table's fields with type and the choices of select fields
- 03Rows filtered with NocoDB's where syntax, sorted and paged, with each row's fields, and how many rows match
- 04When asked and granted, adds, changes, upserts, links or unlinks rows, and adds, edits, resolves or deletes row comments
- 05When asked and granted, creates bases, tables and fields, renames them, and permanently deletes rows, a field with its data, or a table with all its rows
- 06When asked and granted, runs a button field's action on rows or a manual-trigger workflow, which may change rows, send messages or call outside services
Acts when asked
When you ask it to
These tools change something in NocoDB. 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.
- 01Add rows to a table
- 02Comment on a row
- 03Change fields of existing rows
- 04Delete rows from a table
- 05Add or update rows matched on up to three fields
- 06Create a table
- 07Rename a table or change its description or display field
- 08Delete a table and all its rows
- 09Add a field to a table
- 10Rename a field or change its description or default
- 11Delete a field and its data
- 12Link rows through a Link field
- 13Unlink rows on a Link field
- 14Edit a row comment
- 15Delete a row comment
- 16Resolve or reopen a row comment
- 17Run a button field's action on named rows
- 18Run a manual-trigger workflow
- 19Create a base in a workspace
In practice
Ask it like you would a colleague
Once NocoDB 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.
NocoDB + MemtroHow many support requests in NocoDB are still open?
Which orders from Acme are marked unpaid?
What fields does the Inventory table have?
Mark the Northwind order as shipped
Add a Priority field to the Tickets table
Updating a record
Sarah Collins asks Memtro to set the BigCo ticket row to Resolved and comment that the fix shipped. With the actions granted, Memtro changes only the status field of that row, replacing the old value, adds the comment for everyone with access to the base, and notes that NocoDB's API keeps no undo.
Teams
Where it fits
The teams that lean on NocoDB 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 NocoDB 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.
- AnalyticsNocoDB with Google Analytics 4Ask your traffic questions in plain English and get the numbers back.
- AnalyticsNocoDB with Plausible AnalyticsAsk about your website traffic in plain English.
- AnalyticsNocoDB with UmamiAsk about your website traffic in plain English, without sending anybody to a dashboard.
- Finance and commerceNocoDB with XeroInvoices, bills, contacts and reports, answered in plain English with figures cited to Xero.
- Finance and commerceNocoDB with StripeCustomers, charges, invoices and subscriptions through a restricted key.
- Finance and commerceNocoDB with FellohBookings, payments, refunds, chargebacks, supplier payments and payouts from the travel payments platform.
- Work managementNocoDB with JiraJQL search, issue details and projects from Jira Cloud.
- Work managementNocoDB with Clio ManageAsk the matter: its client, its fee earner, the time on it and what is still unbilled.
- Work managementNocoDB 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
- Qdrant
Typesense
Weaviate
Tinybird
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 withAPI token
- 1
In NocoDB open Account settings → Tokens → Add new token, name it Memtro and copy it, shown once. It acts as you, so consider a dedicated user invited only to the right bases
- 2
Leave Host blank for NocoDB Cloud (app.nocodb.com), or type your self-hosted server's host name only, with a publicly trusted certificate. Releases without the v3 API are refused
- 3
Row comments need a Cloud Business plan or a licensed self-hosted NocoDB, and the rest works on every plan. Paste the API token into Connections → NocoDB in Memtro
- 4
Ask how many support requests are still open
Also works from
Chat in the dashboard, the OpenAI-compatible API, scheduled jobs, and any MCP client: Claude Code, OpenCode, Cursor, Claude Desktop. The NocoDB tools are the same everywhere.
FAQ
Questions
Can Memtro change anything in NocoDB?+
Only when you ask, and only what it has been granted: add rows to a table; comment on a row; change fields of existing rows; delete rows from a table; add or update rows matched on up to three fields; create a table; rename a table or change its description or display field; delete a table and all its rows; add a field to a table; rename a field or change its description or default; delete a field and its data; link rows through a Link field; unlink rows on a Link field; edit a row comment; delete a row comment; resolve or reopen a row comment; run a button field's action on named rows; run a manual-trigger workflow; create a base in a workspace. 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 NocoDB 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 NocoDB 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 NocoDB?+
API token. In NocoDB open Account settings → Tokens → Add new token, name it Memtro and copy it, shown once. It acts as you, so consider a dedicated user invited only to the right bases.
Connect NocoDB in a few minutes
Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.