redshift-mcp-server
If you are the rightful owner of redshift-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
This is a Model Context Protocol (MCP) server for Amazon Redshift implemented in TypeScript, providing rich contextual information about Redshift data warehouses.
The Redshift MCP Server is designed to integrate with MCP-compatible clients, such as Cursor IDE, to provide detailed insights into Amazon Redshift databases. Implemented in TypeScript, it allows for the inspection of database schemas and execution of read-only queries, following Anthropic's implementation pattern. The server is configured via a JSON file and can be used globally or project-specifically. It supports stdio transport for communication with other MCP clients. The server requires Node.js 16 or higher, TypeScript, and access to an Amazon Redshift cluster. It emphasizes security by using read-only transactions, sanitizing inputs, and redacting sensitive data.
Features
- Integration with MCP Clients: Supports configuration for both project-specific and global use, automatically detected by Cursor IDE.
- Read-Only Transactions: Ensures database integrity by executing only non-modifying queries.
- Schema Inspection: Provides detailed schema information, including table structures and column data types.
- Security Measures: Sanitizes inputs to prevent SQL injection and redacts sensitive data in sample results.
- Extensibility: Allows for the addition of new resource types and tools, as well as enhanced security features.
Tools
query
Perform read-only SQL queries
describe_table
Get detailed structure information of the table
find_column
Find a table with specific column names
