# Redshift MCP Server

> Redshift MCP Server is an MCP server. Secure, read-only access to Amazon Redshift with schema introspection and smart sampling. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **MCP Registry name:** io.github.davidalbertonogueira/redshift-mcp-server
- **Listing updated:** 2026-11-13

## About

Secure, read-only access to Amazon Redshift with schema introspection and smart sampling

## Install

### Claude Code (Terminal)

```sh
claude mcp add redshift-mcp-server -- npx -y @davidalbertonogueira/redshift-mcp-server
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "redshift-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@davidalbertonogueira/redshift-mcp-server"
      ]
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "redshift-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@davidalbertonogueira/redshift-mcp-server"
      ]
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "redshift-mcp-server": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@davidalbertonogueira/redshift-mcp-server"
      ]
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "redshift-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@davidalbertonogueira/redshift-mcp-server"
      ]
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "redshift-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@davidalbertonogueira/redshift-mcp-server"
      ]
    }
  }
}
```

## FAQ

### How do I add Redshift MCP Server to Claude Code?

Run this command in your terminal: claude mcp add redshift-mcp-server -- npx -y @davidalbertonogueira/redshift-mcp-server

---
Source: https://ai-powered.com/mcp/redshift-mcp-server
