Can Memtro change anything in Amazon Redshift?

Not yet. Today every Amazon Redshift tool reads, searches or lists. When the connector gains actions, each is marked, granted by name per team and used only when a person asks for exactly that, so nothing is created, sent, updated or deleted until you say so.

Who can use a Amazon Redshift 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 Amazon Redshift 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 Amazon Redshift?

Database user + password (optional SSH tunnel). Create a read-only user: CREATE USER memtro_reader PASSWORD '…'; GRANT USAGE ON SCHEMA public TO memtro_reader; GRANT SELECT ON ALL TABLES IN SCHEMA public TO memtro_reader;.

Amazon Redshift + Memtro

Query your Redshift warehouse in plain English, read-only and capped.

Memtro connects to Amazon Redshift, provisioned or Serverless, with a read-only database user, directly or through an SSH bastion. It browses schemas, tables and columns with row counts and sizes, runs single SELECT statements inside a READ ONLY transaction with a 20-second timeout and a 500-row cap, and can EXPLAIN a query before it runs. Spectrum external tables and late-binding views are included in the schema view.

Connect Amazon Redshift Start for free Reference

What you can do with Amazon Redshift in Memtro

Ask in plain English from chat, your editor, a scheduled job or your own agent. The model picks the right Amazon Redshift tool, reads what it needs, and answers with the source cited.

01

Finance asks a warehouse question

A finance analyst asks for monthly recurring revenue by plan. Memtro finds the subscriptions fact table, checks its columns, writes a DATE_TRUNC query, runs it read-only with the row cap and returns a table with the SQL used.

02

Checking a slow report

A data engineer pastes a query that times out in a BI tool. Memtro runs EXPLAIN and points at the DS_BCAST_INNER step and the missing sort key, then suggests a filtered version and runs it within the 20-second cap.

Schemas and tables with row counts, size, distribution style and sort key
Columns with types, defaults and comments plus sample rows
Read-only SQL in a READ ONLY transaction with timeout and row cap
Server-side cursor fetch so large results never flood the connection
EXPLAIN plans to check for broadcast joins and missing sort keys
Optional SSH tunnel through a bastion in your VPC

Ask it like this

Questions people ask once Amazon Redshift is connected. In agent mode each one also checks the other systems that know about the same people, companies or identifiers.

›Which tables in the analytics schema are the biggest?
›Describe the fact_orders table
›Revenue by week for the last quarter from fact_orders
›How many active customers signed up in the last 30 days?
›Explain this query before running it
›Which schemas contain tables mentioning invoices?

Where it fits

Teams that get the most from Amazon Redshift in Memtro, with the rest of their stack attached.

Better together

A record in Amazon Redshift 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_reader PASSWORD '…'; GRANT USAGE ON SCHEMA public TO memtro_reader; GRANT SELECT ON ALL TABLES IN SCHEMA public TO memtro_reader;
02Optionally GRANT SELECT ON svv_table_info TO memtro_reader so table sizes and row counts show
03Make the endpoint reachable: publicly accessible with a security-group rule, or fill in the SSH tunnel fields for a bastion
04In Memtro choose Amazon Redshift, enter host, port, database, user and password, and click Test

Also works from

Chat in the dashboard, the OpenAI-compatible API, scheduled jobs, and any MCP client: Claude Code, OpenCode, Cursor, Claude Desktop. The Amazon Redshift tools are the same everywhere.

Set it up as an MCP server →Clients and agents →

Questions

Can Memtro change anything in Amazon Redshift?: Not yet. Today every Amazon Redshift tool reads, searches or lists. When the connector gains actions, each is marked, granted by name per team and used only when a person asks for exactly that, so nothing is created, sent, updated or deleted until you say so.
Who can use a Amazon Redshift 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 Amazon Redshift 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 Amazon Redshift?: Database user + password (optional SSH tunnel). Create a read-only user: CREATE USER memtro_reader PASSWORD '…'; GRANT USAGE ON SCHEMA public TO memtro_reader; GRANT SELECT ON ALL TABLES IN SCHEMA public TO memtro_reader;.

Connect Amazon Redshift in a few minutes

Seven-day free trial, then one monthly price per organisation. Connectors, jobs and memory are never metered.

Start for free Pricing