sample-amazon-redshift-MCP-server

sample-amazon-redshift-MCP-server

0
databases

Redshift MCP Server is a Python-based implementation allowing AI assistants to interact with Amazon Redshift databases via the Model Context Protocol. The server offers functionality to interact with database schemas, tables, and execute various SQL-related operations.

Redshift MCP Server

A Model Context Protocol (MCP) server for Amazon Redshift that allows AI assistants to interact with Redshift databases. It provides tools to list schemas and tables, retrieve table DDL scripts, get table statistics, execute SQL queries, analyze tables for statistics, and get SQL execution plans.

Features

  • List schemas and tables
  • Retrieve table DDL scripts
  • Execute SQL queries
  • Analyze tables
  • Get execution plans

Installation

Prerequisites

  • Python 3.13+
  • Amazon Redshift cluster
  • Redshift credentials

Configuration

Set environment variables for Redshift connection.

Tools

  • execute_sql
  • analyze_table
  • get_execution_plan