redshift-mcp-server
Verified Safeby cyril-goud-foodsmart
Overview
This server acts as a Model Context Protocol (MCP) agent for AWS Redshift, enabling programmatic access to Redshift schemas, table metadata, and allowing execution of read-only SQL queries.
Installation
npm startEnvironment Variables
- REDSHIFT_HOST
- REDSHIFT_PORT
- REDSHIFT_DATABASE
- REDSHIFT_USER
- REDSHIFT_PASSWORD
Security Notes
The server connects to AWS Redshift, leveraging environment variables for credentials. The `execute_query` tool is restricted to `SELECT`, `WITH`, and `EXPLAIN` statements, significantly mitigating SQL injection risks for write/destructive operations. However, the Redshift connection explicitly sets `ssl: { rejectUnauthorized: false }`, which weakens SSL security by not verifying the server's certificate. While sometimes necessary in specific enterprise configurations (e.g., custom CAs), it introduces a potential man-in-the-middle vulnerability if not properly understood and managed.
Similar Servers
enhanced-postgres-mcp-server
This server acts as a Model Context Protocol interface for PostgreSQL, enabling LLMs to query data, modify records, and manage database schema objects with read and write capabilities.
jewei-mssql-mcp-server
Provides a Micro-Agent Protocol (MCP) server for querying Microsoft SQL Server databases and retrieving table structures.
mysql_mcp_server
This server provides a Model Context Protocol (MCP) interface to a MySQL database, enabling AI models to execute SQL queries and retrieve database schema information.
mcp-postgres
Provides a read-only Model Context Protocol (MCP) server for AI tools (like Claude Code, Cursor) to query a PostgreSQL database directly.