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.
Postgres + Memtro
Read-only SQL over your warehouse or application database, written by the model from the schema.
Give Memtro a read-only role and the model can read the schema and run SELECT queries. In agent mode it looks at the schema first, then queries by the identifiers it found in a ticket or a CRM record.
What you can do with Postgres in Memtro
Ask in plain English from chat, your editor, a scheduled job or your own agent. The model picks the right Postgres 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 across the schemas you expose
- Run one read-only SELECT or WITH query at a time, rows capped, 20 second timeout
- Every query runs inside a READ ONLY transaction
- Works with warehouses, reporting replicas and application databases
Ask it like this
Questions people ask once Postgres is connected. In agent mode each one also checks the other systems that know about the same people, companies or identifiers.
- ›What did Sam Lee order in the last 90 days?
- ›Revenue by segment for Q3 from the warehouse
- ›Check the warehouse for duplicate payments on order 4411
Where it fits
Teams that get the most from Postgres 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 Postgres 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 role and grant SELECT on the schemas to expose
- 02Allow Memtro's server IP in your database firewall; use sslmode=require
- 03Paste the connection string on Dashboard → Connections → Postgres and name it (e.g. warehouse)
Also works from
Chat in the dashboard, the OpenAI-compatible API, scheduled jobs, and any MCP client: Claude Code, OpenCode, Cursor, Claude Desktop. The Postgres tools are the same everywhere.
Clients and agents →Questions
- Can Memtro change anything in Postgres?
- No. The Postgres 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 Postgres 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 Postgres 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 Postgres?
- Connection string, optional SSH tunnel. Create a read-only role and grant SELECT on the schemas to expose.
Connect Postgres in a few minutes
Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.