Get answers from your Redshift data, in Claude, ChatGPT or Cursor

Ask "which campaigns drove the most trial signups last week?" and your assistant runs the query on Redshift. SaturnSQL's hosted MCP server works with provisioned clusters and Redshift Serverless, no local process to run.

ChatGPTMCP · redshift
You
Which campaigns drove the most trial signups last week?
execute_query
SELECT utm_campaign, COUNT(*) AS trials
FROM marketing.signups
WHERE signup_at >= DATEADD(day, -7, GETDATE())
  AND plan = 'trial'
GROUP BY utm_campaign
ORDER BY trials DESC
LIMIT 3;
utm_campaigntrials
spring_search138
partner_webinar91
retargeting_eu64
ChatGPT
spring_search drove the most trials last week, 138.

Setup

1. Add your Redshift connection in SaturnSQL, either directly (host, port 5439, over SSL or an SSH tunnel) or through the Redshift Data API with IAM credentials, which needs no network path into your VPC. See connecting Redshift.

2. Click your name in the sidebar, then Install MCP, and pick your client: Claude, ChatGPT, Cursor or Claude Code. You add https://mcp.saturnsql.com/mcp and sign in with your SaturnSQL account, with no API key to copy.

What it can do

The connector gives your assistant six tools: list your connections, read a schema (tables, columns and foreign keys), run SQL, run a saved query from your team's library, save a new query back to that library, and export a result to CSV. Queries run through the same read-only validation and row limits as the SaturnSQL editor, and billing, users and account settings are never reachable.

It works with PostgreSQL, MySQL and MariaDB, SQL Server, Oracle, Amazon Redshift, ClickHouse, BigQuery and DynamoDB. Your database password stays encrypted in SaturnSQL; the assistant only ever sees results.

Why not run a Redshift MCP server yourself?

A self-hosted Redshift MCP server needs AWS credentials or a database password on each laptop and a network route into the cluster, and it only reaches desktop clients. SaturnSQL keeps those credentials in one place, connects over the Data API when the cluster is private, and gives ChatGPT and Claude on the web the same access as the desktop apps.

Common questions

What plan do I need? The MCP server is included on SaturnSQL Starter and above. The free plan can try the editor, but it cannot connect an AI client.

Does the assistant see my database password? No. The connection and its credentials stay encrypted in SaturnSQL. Your AI client signs in with your SaturnSQL account and only receives query results.

Can it change or delete data? No. Queries go through the same read-only validation and row limits as the SaturnSQL editor. For defense in depth, connect with a read-only database user as well.

Does it work with Redshift Serverless? Yes. Use a direct connection to the workgroup endpoint, or the Redshift Data API with the workgroup name. Provisioned clusters work the same way with a cluster identifier.

Other databases and clients

The same server connects PostgreSQL, MySQL and MariaDB, SQL Server, Oracle, Amazon Redshift, ClickHouse, BigQuery and DynamoDB. Setting up a specific assistant? See Claude, ChatGPT, Cursor and Claude Code.

Get answers from your Redshift data