mcp-server-redshift
0
MCP Server for Redshift is an implementation that provides a standardized interface for accessing Amazon Redshift databases through AI models. It includes features like listing database objects and executing read-only queries with support for both stdio and SSE transportation.
MCP Server for Redshift
A Model Context Protocol (MCP) server for Amazon Redshift providing a standardized interface for interacting with Redshift databases through AI models.
Features
- List tables, views, and materialized views across schemas
- Retrieve detailed schema information
- Execute read-only SQL queries
- Supports stdio and SSE transport
Prerequisites
- Node.js 18 or higher
- Redshift database access
Usage
Run the server in development or production mode with available tools to list tables, get table schemas, and execute queries.
Security Considerations
- Queries execute in a read-only mode
- Environment variables and credentials should be secured.