Log in if you already have an account.
Quick Info
- Secure cloud hosting
- Secure authentication
- 1.0.0
- Dec 16, 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.
Mantaro Calculator
Essential calculator tools for PCB design, transmission line impedance, filter design, RF circuits, and analog electronics with automatic component value calculations and schematic generation.
Image tool
Unified image creation, editing, character referencing, background removal, infographics, and chart generation via best-in-class providers.
GPT Image
Generate and edit images with OpenAI's advanced gpt-image-1 model.
Qwen Image Edit Plus
High-fidelity multi-image editing with Qwen Image Edit Plus.
Render.com
Manage your Render infrastructure directly from Simtheory
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