mcp-client-server

mcp-client-server

1
databases

Redshift MCP Server is a Python-based Model Context Protocol server designed for querying Redshift databases. It allows listing of tables, viewing schemas, and executing read-only SQL queries, all through a secure and easy-to-use interface.

Redshift MCP Server (Python)

A Model Context Protocol (MCP) server for querying Redshift databases, implemented in Python using FastMCP.

Features

  • Query Redshift databases through an MCP server
  • List tables in the database
  • View table schemas
  • Execute read-only SQL queries
  • Works with Cursor and Claude Desktop

Installation

Prerequisites

  • Python 3.10+
  • Redshift database connection details
  • pip 21.3+ (for pyproject.toml support)

Setup

  1. Clone this repository.
  2. Create a virtual environment and install the package.

Usage

Running the server using the CLI

After installation, you can use the provided command-line interface.

Using with Docker

  1. Build the Docker image.
  2. Run the container.

Setting up in Cursor

Edit .cursor/mcp.json to update your database connection string.

Setting up in Claude Desktop

Add configuration to Claude Desktop's configuration file.

Available MCP Features

Resources

  • redshift://tables - Lists all tables in the database
  • redshift://{hostname}/{table_name}/schema - Returns schema information for a specific table

Tools

  • query(sql: string) - Executes a read-only SQL query against the Redshift database

Security Notes

  • The server only allows read-only transactions
  • All queries are executed inside a transaction that is rolled back
  • Database passwords are never exposed in resource URIs

License