01
Warehouse questions
Revenue by region for last month, answered with SQL Memtro writes and runs on the warehouse you chose.
Snowflake + Memtro
Read-only SQL over Snowflake through the SQL REST API, authenticated with a key pair you control.
Create a read-only user with an RSA key and Memtro signs a short-lived JWT for every request. The model browses databases, schemas and tables, then runs SELECT statements on a warehouse you choose.
What you can do with Snowflake in Memtro
Ask in plain English from chat, your editor, a scheduled job or your own agent. The model picks the right Snowflake tool, reads what it needs, and answers with the source cited.
02
Key pair, no passwords
Authentication is a short-lived JWT signed with a key you control; nothing to rotate in Memtro.
- Browse databases, schemas, tables, views and columns
- Run one SELECT, WITH, SHOW or DESCRIBE statement at a time, rows capped, 20 second timeout
- Key-pair authentication: no password is stored, JWTs expire within the hour
- Defaults for warehouse, database, schema and role per connection
Ask it like this
Questions people ask once Snowflake is connected. In agent mode each one also checks the other systems that know about the same people, companies or identifiers.
- ›Revenue by region for last month from the FINANCE schema
- ›Which tables in ANALYTICS.PUBLIC mention subscriptions?
- ›How many active accounts did we have on 1 September?
Where it fits
Teams that get the most from Snowflake 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 Snowflake 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
- 01Generate an RSA key pair and set the public key on a read-only Snowflake user (ALTER USER … SET RSA_PUBLIC_KEY)
- 02Grant that user's role USAGE on a warehouse and SELECT on the schemas to expose
- 03Enter the account identifier, user, private key and warehouse on Dashboard → Connections → Snowflake
Also works from
Chat in the dashboard, the OpenAI-compatible API, scheduled jobs, and any MCP client: Claude Code, OpenCode, Cursor, Claude Desktop. The Snowflake tools are the same everywhere.
Clients and agents →Questions
- Can Memtro change anything in Snowflake?
- No. The Snowflake 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 Snowflake 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 Snowflake 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 Snowflake?
- RSA key pair. Generate an RSA key pair and set the public key on a read-only Snowflake user (ALTER USER … SET RSA_PUBLIC_KEY).
Connect Snowflake in a few minutes
Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.