Log in if you already have an account.
Quick Info
- Secure cloud hosting
- Secure authentication
- 1.0.0
- Mar 04, 2026
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.
Lemonado
Access and query all your business data — connect your apps, CRM, ad accounts, databases, spreadsheets, and more.
Linear
Connect your Linear workspace for issue tracking and project management.
Zapier
Connect your apps and automate workflows.
BuiltWith
Integrates with BuiltWith's API to identify the technology stack of any website.
Firecrawl
Crawls web pages and websites to extract data
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