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.

Available tools

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

One-click install from the Simtheory store.

2. Connect

Authorize access to your Amazon Redshift account.

3. Use

Your AI can now interact with Amazon Redshift.

Details

Version 1.0.0

Updated Sep 16, 2026

Category Data science

Publisher AWS

Features

Cloud hosted — no setup required

Secure authentication

Automatic updates

Works with all AI models

Users also installed

Snowflake

Query your Snowflake data warehouse — execute SQL, explore warehouses, databases, schemas and tables, and use Cortex AI for natural-language analytics and search.

View details

Code interpreter

Execute Python code in a sandboxed environment. Analyze data, create charts, edit files, and more.

View details

Snowflake (Team)

Query the shared GTM Snowflake warehouse through one read-only service account.

View details

Ready to use Amazon Redshift?

Get Started