redshift-mcp-server
3
Redshift MCP Server is a Model Context Protocol server that facilitates interaction with Amazon Redshift databases. It offers features like running and explaining SQL queries, listing tables and schemas, and testing database connections. The project is designed to be secure and efficient for database management tasks.
Redshift MCP Server
A Model Context Protocol (MCP) server designed for interacting with Amazon Redshift databases.
Features
- Run SQL queries on Redshift
- Explain SQL query execution plans
- List tables and views within a schema
- List all schemas within the database
- Test connection to Redshift
Prerequisites
- Python 3.10+
- Amazon Redshift database credentials
Installation
- Install the required software and configure your environment for Amazon Q or Claude.
- Set up your Redshift credentials securely using environment variables.
Development
- Clone the repository and set up a virtual environment.
- Install the project and its dependencies for development or regular use.
Best Practices
- Use specific queries to enhance performance and reduce load.
Available Tools
- Execute and explain SQL queries.
- List tables, views, and schemas.
- Test database connectivity.
Connection Testing
- The server includes automatic connection testing during startup.