Advertise
MCP.so
Sign In

Redshift MCP Server (TypeScript)

@paschmaria

Repository

Basic information

Category

Other

Transports

stdio

Author

paschmaria

About Redshift MCP Server

No overview available yet

#redshift#mcp#typescript#database#server

Redshift MCP Server config

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

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

Redshift MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

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 in Cursor IDE and other MCP-compatible clients to inspect database schemas and execute read-only queries.

How to use Redshift MCP Server (TypeScript)?

Configure the server in a .cursor/mcp.json file (project‑specific or global) with a DATABASE_URL environment variable following the redshift://username:password@hostname:port/database?ssl=true format. Install dependencies with npm install, build with npm run build, and run via npm start or directly with node dist/index.js. For development use npm run dev.

Key features of Redshift MCP Server (TypeScript)

  • Execute read‑only SQL queries with the query tool.
  • Get detailed table structure with the describe_table tool.
  • Find tables containing columns matching a name pattern using find_column.
  • Automatically discover and list schemas, tables, and columns.
  • Provide sample rows (up to 5) with automatic sensitive‑data redaction.
  • Use read‑only transactions and input sanitisation for security.

Use cases of Redshift MCP Server (TypeScript)

  • Inspect database schemas and table structures through natural language.
  • Run ad‑hoc read‑only queries (e.g., count orders by status).
  • Search for columns across all tables (e.g., find columns containing “email”).
  • Retrieve sample data from tables without exposing sensitive information.
  • Obtain table statistics like size, row count, and creation time.

Frequently asked questions

1

What are the prerequisites?

Node.js 16 or higher, TypeScript, access to an Amazon Redshift cluster, and Cursor IDE installed.

2

How do I connect to my Redshift database?

Set the `DATABASE_URL` environment variable to a Redshift‑formatted connection string: `redshift://username:password@hostname:port/database?ssl=true`.

3

Is the server read‑only?

Yes. The server uses read‑only transactions for queries to prevent modifications and sanitises inputs to avoid SQL injection.

4

Where does the data live?

All data stays in your own Amazon Redshift cluster. The server connects directly to it and does not store or expose data outside your environment.

5

What transport and authentication does it use?

The server uses stdio transport. Authentication is handled via the Redshift connection URL (username/password). No additional MCP‑level authentication is required.

Comments

More Other MCP servers

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K

Awesome Mlops

visenger

A curated list of references for MLOps

14.0K

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

Advertise