MCP.so
Sign In

Redshift MCP Server (TypeScript)

@paschmaria

Repository

About Redshift MCP Server (TypeScript)

No overview available yet

Basic information

Category

Other

Runtime

node

Transports

stdio

Publisher

paschmaria

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "redshift-js-mcp-server": {
      "command": "node",
      "args": [
        "dist/index.js"
      ],
      "env": {
        "DATABASE_URL": "redshift://username:password@hostname:port/database?ssl=true"
      }
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Redshift MCP Server (TypeScript)?

It is a Model Context Protocol (MCP) server for Amazon Redshift, implemented in TypeScript. It enables LLMs to inspect database schemas and execute read-only queries on a Redshift data warehouse.

How to use Redshift MCP Server (TypeScript)?

Install Node.js 16+, clone the repository, run npm install and npm run build. Set the DATABASE_URL environment variable (e.g., redshift://username:password@hostname:port/database?ssl=true). Start with npm start or node dist/index.js. For Cursor IDE, configure via .cursor/mcp.json; for other MCP clients, use stdio transport configuration.

Key features of Redshift MCP Server (TypeScript)

  • Execute read-only SQL queries via the query tool.
  • Describe table structure with describe_table.
  • Find tables by column name patterns with find_column.
  • Provide schema listings, table schemas, sample data, and statistics.
  • Automatic redaction of sensitive data (email, phone) in samples.
  • Input sanitization and read-only transactions for security.

Use cases of Redshift MCP Server (TypeScript)

  • Ask LLMs to list all tables in a given schema.
  • Retrieve the structure of a specific table (e.g., customers).
  • Find tables containing columns matching a name pattern (e.g., 'email').
  • Request sample data from tables for quick inspection.
  • Write queries to count orders by status or perform aggregations.

FAQ from Redshift MCP Server (TypeScript)

How does the server ensure security?

It uses read-only transactions, sanitizes inputs to prevent SQL injection, does not expose raw passwords in resource URIs, and automatically redacts sensitive data (email, phone) in sample results.

What are the prerequisites to run this server?

Node.js 16 or higher, TypeScript, access to an Amazon Redshift cluster, basic SQL knowledge, and for Cursor integration, Cursor IDE installed.

Comments

More Other MCP servers

Core Philosophy: Connect, Unify, Respond

mindsdb

Delegate anything. It comes back done.

39.4K

AutoBrowser MCP

autobrowser-ai

Browser MCP is a Model Context Provider (MCP) server that allows AI applications to control your browser

6.8K

Awesome-MCP-ZH

yzfly

MCP 资源精选， MCP指南，Claude MCP，MCP Servers, MCP Clients

7.4K

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K

Inbox Zero AI MCP

elie222

The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.

11.6K