Amazon Redshift

By: AWS Data science

Query and explore Amazon Redshift data warehouses - discover clusters, databases, schemas, tables, and execute SQL queries.

Description

Connect to Amazon Redshift data warehouses for powerful analytics.

• 🔍 **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.

PubMed

Search biomedical literature from MEDLINE, life science journals, and online books.

ChartMogul

Connect to ChartMogul for subscription analytics, revenue reporting, and customer management.

Audiobook maker

Create a professional audiobook from text or your recent session history, with optional custom voices.

Make a song

Make a song with lyrics using AI: describe the style, genre, and mood of the song you want to create as well as providing lyrics you would like in the song.

Video maker

Generate videos from a topic or a provided script with narrated voiceover, captions (optional) and AI B‑roll.

Ready to use Amazon Redshift MCP Server?

Get Started with Simtheory