redshift-mcp-server

redshift-mcp-server

1
databases

Redshift MCP Server is a TypeScript implementation of the Model Context Protocol for Amazon Redshift, providing MCP clients with contextual information about database schemas. It allows for executing read-only queries and integrating with tools like Cursor IDE.

Redshift MCP Server (TypeScript)

This is an MCP server for Amazon Redshift that provides rich contextual information to MCP-compatible clients like Cursor IDE. It allows inspection of database schemas and execution of read-only queries.

Integration with MCP Clients

  • Configure project-specific and global settings using .cursor/mcp.json.
  • Available tools automatically detected in Cursor IDE.
  • Supports stdio transport for other MCP clients.

Prerequisites

  • Node.js 16 or higher, TypeScript, Amazon Redshift access, basic SQL knowledge, Cursor IDE.

Installation

  1. Clone the repository or copy files.
  2. Install dependencies.
  3. Build the code.

Usage

  • Requires a Redshift connection URL via DATABASE_URL.
  • Can run in different modes for development.

Components

Tools in Cursor

  • query: Execute SQL queries.
  • describe_table: Get table information.
  • find_column: Find tables with specific columns.

Resources to Cursor

  • Provides schema listings, table schemas, sample data, and statistics.

Security Considerations

  • Uses read-only transactions.
  • Sanitizes inputs to prevent SQL injection.

Example Cursor Interactions

  • "Show me all tables in the public schema."
  • "What's the structure of the customers table?"

Extending the Server

  • Add new resource types or tools.
  • Enhance security features.

Development

  • Use npm run dev for development.

License

MIT