MCP Server for Amazon Redshift

MCP Server for Redshift

A Model Context Protocol (MCP) server implementation for Amazon Redshift, providing a standardized interface for interacting with Redshift databases through AI models.

Features

• List tables, views, and materialized views across multiple schemas
• Get detailed schema information for multiple tables in a single request
• Execute read-only SQL queries against Redshift
• Support for both stdio and SSE (Server-Sent Events) transport
• Type-safe implementation in TypeScript

Prerequisites

• Node.js 18 or higher
• Access to a Redshift database
• Environment variables configured (see Configuration section)

Installation

1. Clone the repository:

   git clone https://github.com/yourusername/mcp-server-redshift.git
   cd mcp-server-redshift
   

2. Install dependencies:

   npm install
   

3. Build the project:

   npm run build
   

Configuration

Create a .env file in the root directory with the following variables:

# Redshift Connection
REDSHIFT_HOST=your-redshift-host
REDSHIFT_PORT=5439
REDSHIFT_DATABASE=your-database
REDSHIFT_USER=your-username
REDSHIFT_PASSWORD=your-password
REDSHIFT_SCHEMAS=public,schema1,schema2  # Comma-separated list of schemas

# Server Configuration
TRANSPORT_TYPE=stdio  # or 'sse' for Server-Sent Events
PORT=3000  # Only used when TRANSPORT_TYPE=sse

Usage

Running the Server

# Development
npm run dev

# Production
npm run build
npm start

Available Tools

1. List Tables (list_tables)

   • Lists all tables, views, and materialized views in specified schemas
   • Optional schemas parameter to filter by specific schemas

   {
     "schemas": ["public", "analytics"]
   }
   

2. Get Tables Schema (get_tables_schema)

   • Get schema information for multiple tables across different schemas

   {
     "tables": [
       { "schema": "public", "table": "users" },
       { "schema": "analytics", "table": "events" }
     ]
   }
   

3. Query (query)

   • Execute read-only SQL queries against the database

   {
     "sql": "SELECT * FROM public.users LIMIT 5"
   }
   

Testing

Run the test suite:

npm test

Architecture

The project is organized into the following structure:

src/
├── config/         # Configuration and database setup
├── tools/          # Individual tool implementations
├── server/         # Server setup and transport configuration
└── index.ts        # Main entry point

Security Considerations

• All queries are executed in read-only transactions
• Environment variables should be properly secured
• CORS is enabled for SSE transport (should be configured for production)
• Database credentials should be managed securely

Contributing

1. Fork the repository
2. Create your feature branch (git checkout -b feature/amazing-feature)
3. Commit your changes (git commit -m 'Add some amazing feature')
4. Push to the branch (git push origin feature/amazing-feature)
5. Open a Pull Request

License

This project is licensed under the MIT License - see the LICENSE file for details.

Acknowledgments

This project is based on the PostgreSQL MCP server from the Model Context Protocol project. Special thanks to the original authors for their work.