R
Redshift
Query Amazon Redshift warehouses.
·No reviews yet
Share:
About
Auto-generated
Redshift is a Model Context Protocol server in the Data & Databases category. It lets AI assistants that speak MCP call its tools and read its resources over STDIO.
Example tools
Illustrative tool names — the actual tool set is defined by the server at runtime.
query
Run a read-only SQL query
list_tables
List tables in the connected database
describe_table
Return column info for a table
Screenshots
No screenshots yet.
Frequently Asked Questions
Common questions about Redshift.
- What does the Redshift MCP enable?
- The Redshift MCP facilitates querying Amazon Redshift data warehouses. It allows users to interact with their Redshift instances through a standardized protocol, enabling data retrieval and manipulation via SQL commands.
- How can I install the Redshift MCP into a client like Cline?
- Installation typically involves adding the Redshift MCP server's repository URL to your Cline configuration. Specific steps may vary based on the Cline version and its method for integrating external MCPs.
- Does the Redshift MCP require an API key for authentication?
- Yes, the Redshift MCP uses an API key for authentication. This key is used to secure access to your Amazon Redshift data warehouse and should be configured within your MCP client.
- What kind of capabilities does the Redshift MCP expose?
- The Redshift MCP primarily exposes capabilities for executing SQL queries against an Amazon Redshift data warehouse. This allows for data analysis, reporting, and other data-driven operations.
- How is the Redshift MCP licensed and what are its costs?
- The Redshift MCP itself is community-provided and available from awslabs on GitHub. However, usage of Amazon Redshift incurs costs based on AWS pricing for compute and storage resources, which are separate from the MCP.
- What are the common prerequisites for using the Redshift MCP?
- A prerequisite for using the Redshift MCP is an active Amazon Redshift data warehouse instance. You will also need appropriate AWS credentials and permissions to access the Redshift instance.
Install Redshift
Claude Desktop
Add this to claude_desktop_config.json.
{
"mcpServers": {
"redshift": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-redshift"
]
}
}
}Cursor
Add this to ~/.cursor/mcp.json.
{
"mcpServers": {
"redshift": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-redshift"
]
}
}
}VS Code
Add this to your workspace settings.json.
{
"mcp.servers": {
"redshift": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-redshift"
]
}
}
}Reviews
Sign in to leave a review.
No reviews yet. Be the first!
Discussion(0)
No comments yet.