# Redshift

> Use this tool when you need to securely access and query Amazon Redshift databases with granular permission controls, or require conversational database querying and AI-assisted data exploration. It provides a configurable and restricted interface for executing SQL operations, with automatic connection management and built-in SQL command filtering. Ideal for data analysts, developers, and teams needing programmatic access to Redshift warehouses with controlled security modes.

Canonical page: https://skillsregistry.net/skills/anshulpatre-redshift  
JSON: https://api.skillsregistry.net/v1/skills/anshulpatre-redshift

## Description

This MCP server provides AI assistants with secure Amazon Redshift database access through a FastMCP-based implementation built by Anshul Patre using Python with configurable security modes (readonly, readwrite, admin) that enforce SQL operation restrictions based on environment variables. The implementation features automatic connection management using environment variables or manual credentials, comprehensive database operations including schema/table discovery and query execution, and built-in SQL command filtering that prevents dangerous operations in restricted modes. Built with support for both Amazon's official redshift-connector and PostgreSQL-compatible drivers, automatic reconnection capabilities, and structured JSON responses for all operations, it serves data analysts needing conversational database querying, developers requiring AI-assisted data exploration, and teams wanting secure programmatic access to Redshift warehouses with granular permission controls and connection state management.

## Trust

- **Trust score (0–1):** 0.93
- **Verification tier:** verified
- **Last scanned:** 2026-09-28

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-28

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/anshulpatre-redshift)
- **Repository:** <https://github.com/anshulpatre/my-redshift-mcp>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "anshulpatre-redshift"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/anshulpatre-redshift` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/anshulpatre-redshift/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt