# Redshift MCP Server

A Model Context Protocol (MCP) server that enables AI agents to interact with Amazon Redshift using natural language.

## Features

- **SQL Tools**: Execute queries, list tables, describe schemas, get sample data.
- **Resources**: Connection status, table list.
- **Sample Data**: Pre-configured users, products, and orders tables.
- **Architecture**: See [DESIGN.md](DESIGN.md) for system diagrams.

---

## 🚀 Quick Start

For detailed instructions on **Windows, macOS, and Linux**, please refer to the [SETUP.md](SETUP.md) guide.

### Basic Steps (Local Testing):

1. **Start Postgres**: `docker run -d -p 5432:5432 --name postgres -e POSTGRES_PASSWORD=password postgres`
2. **Install Deps**: `pip install mcp redshift-connector pandas python-dotenv psycopg2-binary sqlalchemy`
3. **Seed Data**: `python seed_redshift.py`
4. **Test**: `python test_redshift_local.py`

---

## 🔧 MCP Client Configuration

Add this to your MCP client configuration (e.g., Antigravity, Claude Code, or VS Code).

```json
"redshift-mcp": {
  "command": "py",
  "args": ["redshift_mcp_server.py"],
  "cwd": "c:/Users/santo/OneDrive/Desktop/workspace/redis connection",
  "env": {
    "REDSHIFT_HOST": "localhost",
    "REDSHIFT_PORT": "5432",
    "REDSHIFT_DATABASE": "postgres",
    "REDSHIFT_USER": "postgres",
    "REDSHIFT_PASSWORD": "password"
  }
}
```

---

## ☁️ AWS Deployment

See [AWS_DEPLOYMENT.md](AWS_DEPLOYMENT.md) for deployment options.