awslabs.redshift-mcp-server
An AWS Labs Model Context Protocol (MCP) server for Redshift
Decision gist · record as of 2026-08-14
Yes. The package is actively maintained, has no known vulnerabilities, installs with low friction, and solves a clear problem for developers who want AI assistants to interact safely with Redshift. The permissive Apache-2.0 license and broad Python version support (3.10–3.13) make it suitable for most environments. Install it if you use Redshift and want MCP-compatible AI tooling; skip it if you have no Redshift clusters or do not use MCP clients.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or newer, AWS credentials configured (via CLI, environment variables, or profile), and appropriate AWS IAM permissions for Redshift discovery and query execution.
- Low friction installation via pure Python wheel.
- Active maintenance with recent release (4 days old) and high repository engagement (9599 stars).
License · maintenance · safety
Apache-2.0 (permissive) — Apache-2.0 permissive license allows commercial and private use with minimal restrictions; suitable for most deployment scenarios.
last release 2026-08-10 (4 days) · last repo commit 2026-08-14 · 9,599 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 98,931 downloads/mo, #13,049 on PyPI
Alternatives
Verify before relying
# Install via uv
uv pip install awslabs.redshift-mcp-server
# Configure in MCP client (e.g., ~/.kiro/settings/mcp.json)
# Set AWS_PROFILE, AWS_REGION, and FASTMCP_LOG_LEVEL environment variables
# Then use via MCP client to call list_clusters, list_databases, list_tables, execute_query- Specific AWS IAM permissions required for full functionality beyond the general Redshift access mentioned.
- Performance characteristics and query timeout limits for large result sets.
- Whether read-only enforcement applies to all query contexts or only specific execution paths.
What it is and what it does
This package is an MCP server that bridges AI assistants to Amazon Redshift by exposing cluster discovery, metadata browsing, and query execution as standardized protocol tools. It works with both provisioned Redshift clusters and serverless workgroups, allowing assistants to enumerate databases, schemas, tables, and columns, then execute SQL queries in a read-only mode that rejects write statements.
The server integrates with boto3 and botocore to authenticate against AWS using standard credential chains (profiles, environment variables, or IAM roles). It depends on pydantic for configuration validation, loguru for logging, sqlglot for query parsing, and the mcp library for protocol compliance. Installation is straightforward via pip, though it requires Python 3.10+ and properly configured AWS credentials with appropriate Redshift permissions.
Use it for
- Enable AI coding assistants (Cursor, VS Code) to explore Redshift schema and run exploratory queries without leaving the editor.
- Build chatbots that answer business questions by discovering relevant tables and executing aggregation queries on Redshift data.
- Automate metadata documentation by having an AI assistant traverse all clusters, databases, and schemas to generate data dictionaries.
- Create data governance tools that audit which tables and columns exist across multiple Redshift environments.
- Integrate Redshift query capabilities into multi-tool AI agent workflows for data analysis and reporting.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
The package is actively maintained, has no known vulnerabilities, installs with low friction, and solves a clear problem for developers who want AI assistants to interact safely with Redshift. The permissive Apache-2.0 license and broad Python version support (3.10–3.13) make it suitable for most environments. Install it if you use Redshift and want MCP-compatible AI tooling; skip it if you have no Redshift clusters or do not use MCP clients.
Install
awslabs-redshift-mcp-server on PyPI
Before you install
Low friction installation via pure Python wheel. Active maintenance with recent release (4 days old) and high repository engagement (9599 stars). Requires Python 3.10 or newer and AWS credentials configured.
Requires Python 3.10 or newer, AWS credentials configured (via CLI, environment variables, or profile), and appropriate AWS IAM permissions for Redshift discovery and query execution.
License in practice
Apache-2.0 permissive license allows commercial and private use with minimal restrictions; suitable for most deployment scenarios.
Quickstart
# Install via uv
uv pip install awslabs.redshift-mcp-server
# Configure in MCP client (e.g., ~/.kiro/settings/mcp.json)
# Set AWS_PROFILE, AWS_REGION, and FASTMCP_LOG_LEVEL environment variables
# Then use via MCP client to call list_clusters, list_databases, list_tables, execute_queryVerify before relying
- Specific AWS IAM permissions required for full functionality beyond the general Redshift access mentioned.
- Performance characteristics and query timeout limits for large result sets.
- Whether read-only enforcement applies to all query contexts or only specific execution paths.
Package facts
| License | Apache-2.0 permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 6 packagesboto3botocorelogurumcppydanticsqlglot |
| Maintenance | Actively maintained 4 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 98,931 / month, #13,049 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | License :: OSI Approved :: Apache Software LicenseOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13 |
Evidence: awslabs_redshift_mcp_server-0.0.34-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “redshift mcp server”
- awslabs.redshift-mcp-serverProvides a Model Context Protocol (MCP) server that enables AI…
- mcp-proxymcp-proxy bridges Model Context Protocol (MCP) servers and clients…
- jupyter-server-mcpExposes Python functions as tools to MCP clients via a Jupyter Server…
Give your agent the search over MCP, or paste the wish link into any chat.
More Database packages
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Python client library for connecting to and executing commands against Redis key-value stores, supporting both synchronous and asynchronous operations.
Install it if your application needs to interact with Redis; the only prerequisite is a running Redis server instance.
YDB Python SDK is the official client library for connecting to and querying YDB databases from Python applications.
Install it if you need to connect Python applications to YDB databases.
Connects Python applications to Snowflake data warehouses using the DB API 2.0 specification, enabling SQL queries, data transfers, and warehouse operations.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
Provides base adapter protocols and shared functionality that database adapters use to integrate with dbt-core, handling connections, dialect translation, relation caching, and core interface management.
See also awslabs.aws-api-mcp-server · awslabs.aws-documentation-mcp-server · awslabs.eks-mcp-server · awslabs.bedrock-kb-retrieval-mcp-server · awslabs.aws-pricing-mcp-server · awslabs.cloudwatch-mcp-server · awslabs.billing-cost-management-mcp-server · aws-cdk.aws-redshift-alpha · redshift-connector · opensearch-mcp-server-py