01
Questions, not dashboards
Ask how many orders shipped late last week; Memtro reads the schema, writes the SQL, runs it read-only and shows the query.
MySQL and MariaDB + Memtro
Read-only SQL over your MySQL or MariaDB database, directly or through an SSH tunnel.
Point Memtro at a MySQL or MariaDB database with a read-only user and the model can explore the schema and answer questions with SQL. Every query runs as a single SELECT inside a READ ONLY transaction with a 20-second timeout and a row cap; writes are rejected before they reach the server. Databases on a private network can be reached through an SSH bastion.
What you can do with MySQL and MariaDB in Memtro
Ask in plain English from chat, your editor, a scheduled job or your own agent. The model picks the right MySQL and MariaDB tool, reads what it needs, and answers with the source cited.
02
Safe by construction
Every statement runs in a READ ONLY transaction with a timeout and a row cap, through an SSH tunnel if the database is private.
- List tables and columns, optionally limited to chosen schemas
- Run SELECT, WITH, SHOW, DESCRIBE and EXPLAIN statements
- Enforce READ ONLY transactions, statement timeouts and row caps
- Connect over TLS to RDS, PlanetScale, Aiven, Azure and others, or through an SSH tunnel to a private host
Ask it like this
Questions people ask once MySQL and MariaDB is connected. In agent mode each one also checks the other systems that know about the same people, companies or identifiers.
- ›How many orders were placed last week, by status?
- ›Which customers signed up in September but never ordered?
- ›What columns does the subscriptions table have?
- ›Show the 20 most recent failed payments with the customer email
Where it fits
Teams that get the most from MySQL and MariaDB in Memtro, with the rest of their stack attached.
- Data and analyticsQuestions answered from the warehouse, with the SQL shownPoint Memtro at a read-only replica and anyone can ask the warehouse a question in plain English. The agent reads the schema, writes the query, runs it inside a read-only transaction, and shows its work.
- EngineeringKeep decisions from evaporatingDecisions, owners and deadlines are extracted from conversations and tool results into a typed, time-aware memory. Corrections supersede old facts instead of piling up next to them.
- FinanceAsk the ledger questions in plain EnglishXero, Stripe and the warehouse answer through read-only tools. Duplicate charges, aged receivables, revenue by segment: one question, with the figures cited to their source.
Better together
A record in MySQL and MariaDB is rarely the whole story. Connect the systems that hold the rest and the agent cross-references them by default, then remembers what it learned so the next question starts further along.
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.
How to connect
- 01Create a read-only user: CREATE USER 'memtro'@'%' IDENTIFIED BY '…'; GRANT SELECT ON app.* TO 'memtro'@'%';
- 02In Memtro choose MySQL and MariaDB and paste mysql://memtro:password@host:3306/app?ssl=true; for a private database open the SSH tunnel section and add the bastion host, user and key
- 03Optionally list the schemas to expose, then save; Memtro checks the connection and server version
Also works from
Chat in the dashboard, the OpenAI-compatible API, scheduled jobs, and any MCP client: Claude Code, OpenCode, Cursor, Claude Desktop. The MySQL and MariaDB tools are the same everywhere.
Clients and agents →Questions
- Can Memtro change anything in MySQL and MariaDB?
- No. The MySQL and MariaDB connector is read-only: every tool reads, searches or lists. Nothing is created, sent, updated or deleted, and the credentials you give it should be read-only too.
- Who can use a MySQL and MariaDB 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 MySQL and MariaDB 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 MySQL and MariaDB?
- Connection string, optional SSH tunnel. Create a read-only user: CREATE USER 'memtro'@'%' IDENTIFIED BY '…'; GRANT SELECT ON app.* TO 'memtro'@'%';.
Connect MySQL and MariaDB in a few minutes
Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.