Query and explore Amazon Redshift data warehouses - discover clusters, databases, schemas, tables, and execute SQL queries.
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.
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.
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.
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.
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.
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.
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.
One-click install from the Simtheory store.
Authorize access to your Amazon Redshift account.
Your AI can now interact with Amazon Redshift.
Query your Snowflake data warehouse — execute SQL, explore warehouses, databases, schemas and tables, and use Cortex AI for natural-language analytics and search.
Execute Python code in a sandboxed environment. Analyze data, create charts, edit files, and more.
Make accurate mathematical calculations. Safely evaluates arithmetic expressions, math functions (sin, cos, sqrt, log, etc.), and constants (pi, e).
Sync and manage your Microsoft calendar, create events, and view your schedule.
Connect to repositories and manage code
Access the AlphaFold Protein Structure Database for predictions, analysis, and visualization.
Sign up for Simtheory and install this MCP directly into your workspace.
Get Started
