Log in if you already have an account.
Quick Info
- Secure cloud hosting
- Secure authentication
- 1.0.0
- Dec 19, 2025
Amazon Redshift
Query and explore Amazon Redshift data warehouses - discover clusters, databases, schemas, tables, and execute SQL queries.
Description
• 🔍 **Cluster Discovery**: Find all provisioned clusters and serverless workgroups
• 📊 **Schema Exploration**: Navigate databases, schemas, tables, and columns via SVV system views
• ⚡ **SQL Execution**: Run read-only queries via the Redshift Data API
• 🔒 **Secure**: Uses AWS credentials with IAM permissions, queries wrapped in READ ONLY transactions
• 🛡️ **SQL Guardrails**: Detects and blocks dangerous transaction-breaking statements
Perfect for data analysis, reporting, and exploring your data warehouse structure.
What can this MCP do?
Execute SQL Query
Executes a READ ONLY SQL query against a Redshift cluster. Query is wrapped in BEGIN READ ONLY transaction. Returns columns, rows, row_count, execution_time_ms, query_id.
Execute Write Query
Executes a write SQL query (INSERT, UPDATE, DELETE, DDL). Only available if ALLOW_WRITE is enabled on the connection. Returns affected_rows, execution_time_ms, query_id.
List Columns
Lists all columns in a table via SVV_ALL_COLUMNS. Returns database_name, schema_name, table_name, column_name, ordinal_position, column_default, is_nullable, data_type, character_maximum_length, numeric_precision, numeric_scale, remarks.
List Databases
Lists all databases in a Redshift cluster via SVV_REDSHIFT_DATABASES. Returns database_name, database_owner, database_type (local/shared), database_acl, database_options, database_isolation_level.
List Redshift Clusters
Lists all available Redshift clusters and serverless workgroups. Returns identifier, type (provisioned/serverless), status, database_name, endpoint, port, node_type, number_of_nodes, master_username, encrypted, vpc_id, publicly_accessible, creation_time, and tags.
List Schemas
Lists all schemas in a database via SVV_ALL_SCHEMAS. Returns database_name, schema_name, schema_owner, schema_type (external/local/shared), schema_acl, source_database, schema_option.
List Tables
Lists all tables in a schema via SVV_ALL_TABLES. Returns database_name, schema_name, table_name, table_acl, table_type (TABLE/VIEW/EXTERNAL TABLE/SHARED TABLE), remarks.
How It Works
1. Install the MCP
Install Amazon Redshift from your Simtheory workspace with one click.
2. Connect Your Account
Securely authorize access to your Amazon Redshift account.
3. Start Using
Your AI can now interact with Amazon Redshift on your behalf.
Users also installed these MCPs
Code interpreter
Execute Python code in a sandboxed environment. Analyze data, create charts, edit files, and more.
Weather
Get live weather updates and forecasts for any location.
Data.gov
Access open data resources from the U.S. government.
Notion
Connect your Notion workspace for notes, tasks, and databases.
Microsoft SharePoint
Access and manage your organization's shared documents and sites. The ultimate tool for team collaboration.
GPT Image 1.5
Generate and edit high-fidelity images with OpenAI's GPT Image 1.5
Ready to use Amazon Redshift MCP Server?
Sign up for Simtheory and install this MCP directly into your workspace to start leveraging its capabilities.
Get Started with Simtheory