01
Questions, not dashboards
Ask for total sales by region last quarter; Memtro reads the schema, writes the T-SQL, runs it with a db_datareader login and shows the query.
SQL Server + Memtro
Ask questions of SQL Server and Azure SQL, safely.
Memtro connects to Microsoft SQL Server or Azure SQL with a read-only login and lets the model explore tables and run T-SQL. Only single SELECT statements are accepted, requests time out after 20 seconds and results stop at the row cap, so the model can answer from your data without ever changing it. On-prem servers can be reached through an SSH bastion.
What you can do with SQL Server in Memtro
Ask in plain English from chat, your editor, a scheduled job or your own agent. The model picks the right SQL Server tool, reads what it needs, and answers with the source cited.
02
Safe by construction
Only single SELECT statements run, with a timeout and a streamed row cap, through an SSH tunnel if the server is private.
- List tables and columns across chosen schemas
- Run SELECT and WITH (CTE) queries with TOP or OFFSET/FETCH
- Reject anything that is not a plain read before it reaches the server
- Connect to on-prem instances, named instances and Azure SQL over TLS, or through an SSH tunnel
Ask it like this
Questions people ask once SQL Server is connected. In agent mode each one also checks the other systems that know about the same people, companies or identifiers.
- ›What were total sales by region last quarter?
- ›Which invoices in dbo.Invoices are more than 60 days overdue?
- ›Describe the columns of the Customers table
- ›Show the 50 most recent support tickets with the customer's email
Where it fits
Teams that get the most from SQL Server 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 SQL Server 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 login and user: CREATE LOGIN memtro_reader WITH PASSWORD = '…'; CREATE USER memtro_reader FOR LOGIN memtro_reader; ALTER ROLE db_datareader ADD MEMBER memtro_reader;
- 02In Memtro choose SQL Server and paste Server=host,1433;Database=db;User Id=memtro_reader;Password=…;Encrypt=true (or an mssql:// URL); add SSH tunnel details for a private server
- 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 SQL Server tools are the same everywhere.
Clients and agents →Questions
- Can Memtro change anything in SQL Server?
- No. The SQL Server 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 SQL Server 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 SQL Server 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 SQL Server?
- Connection string, optional SSH tunnel. Create a read-only login and user: CREATE LOGIN memtro_reader WITH PASSWORD = '…'; CREATE USER memtro_reader FOR LOGIN memtro_reader; ALTER ROLE db_datareader ADD MEMBER memtro_reader;.
Connect SQL Server in a few minutes
Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.