redshift-mcp-server

redshift-mcp-server

3.3
databases

If you are the rightful owner of redshift-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

A Model Context Protocol (MCP) server for interacting with Amazon Redshift databases.

The Redshift MCP Server is designed to facilitate seamless interaction with Amazon Redshift databases through a Model Context Protocol (MCP) server. It allows users to execute SQL queries, obtain execution plans, and explore database schemas and tables. The server is built to integrate with platforms like Amazon Q or Claude, providing a robust solution for database management and analysis. With a focus on security, users are advised to manage credentials carefully and avoid exposing sensitive information. The server supports various development and testing configurations, ensuring flexibility and ease of use for developers.

Features

  • Run SQL queries on Redshift
  • Explain SQL query execution plans
  • List tables and views within a schema
  • List all schemas within the database
  • Test connection to Redshift

Tools

  1. run_query

    Execute a SQL query against Redshift

  2. explain_query

    Get the execution plan for a SQL query

  3. list_tables_in_schema

    List all tables and views in a specific schema

  4. list_schemas

    List all schemas in the database

  5. test_redshift_connection

    Test connectivity to the Redshift database

Related MCP Servers

View all databases servers →
mysql_mcp_server

mysql_mcp_server

4.5

by designcomputer

MySQL MCP Server is a Model Context Protocol implementation that facilitates secure interaction between AI applications and MySQL databases.

databases
mcp-notion-server

mcp-notion-server

4.3

by suekou

MCP Server for the Notion API, enabling LLM to interact with Notion workspaces. Additionally, it employs Markdown conversion to reduce context size when communicating with LLMs, optimizing token usage and making interactions more efficient.

databases
mcp-server-neon

mcp-server-neon

4.3

by neondatabase-labs

Neon MCP Server is an open-source tool that enables natural language interaction with Neon Postgres databases.

databases
gateway

gateway

4.0

by centralmind

CentralMind Gateway is a tool designed to expose databases to AI agents via MCP or OpenAPI protocols, providing secure, LLM-optimized APIs.

databases
mariadb-mcp-server

mariadb-mcp-server

3.7

by rjsalgado

This MCP server provides access to MariaDB / MySQL databases, allowing users to list databases, tables, describe table schemas, and execute SQL queries with security features.

databases
mcp-clickhouse

mcp-clickhouse

3.7

by ClickHouse

An MCP server for ClickHouse that allows executing SQL queries and managing databases and tables.

databases
mcp-proxy

mcp-proxy

3.7

by TBXark

An MCP proxy server that aggregates and serves multiple MCP resource servers through a single HTTP server.

databases
atlas-mcp-server

atlas-mcp-server

3.6

by cyanheads

ATLAS (Adaptive Task & Logic Automation System) is a project, knowledge, and task management system for LLM Agents, implemented as a Model Context Protocol (MCP) server.

developer_tools
mcp-google-sheets

mcp-google-sheets

3.6

by xing5

mcp-google-sheets is a Python-based MCP server that connects MCP-compatible clients to Google Sheets API for automation and data manipulation.

cloud_platforms
mcp-graphql

mcp-graphql

3.6

by blurrah

A Model Context Protocol server that enables LLMs to interact with GraphQL APIs, providing schema introspection and query execution capabilities.

databases
mongo-mcp

mongo-mcp

3.6

by QuantGeekDev

A Model Context Protocol (MCP) server that enables LLMs to interact directly with MongoDB databases. Query collections, inspect schemas, and manage data seamlessly through natural language.

databases
mcp-server-splunk

mcp-server-splunk

3.6

by jkosik

A Go implementation of the MCP server for Splunk, supporting STDIO and SSE (Server-Sent Events HTTP API) using the github.com/mark3labs/mcp-go SDK.

cloud_platforms
prometheus-mcp-server

prometheus-mcp-server

3.6

by pab1it0

A Model Context Protocol (MCP) server for Prometheus, enabling access to Prometheus metrics and queries through standardized MCP interfaces.

databases
mcp-1panel

mcp-1panel

3.6

by 1Panel-dev

1Panel MCP Server is an implementation of the Model Context Protocol (MCP) server for 1Panel, providing a range of tools for system, website, certificate, application, and database management.

os_automation
postg-mem

postg-mem

3.6

by dariogriffo

PostgMem is a .NET-based MCP server that provides vector memory storage using PostgreSQL and pgvector for AI applications.

databases
mcp-server-weaviate

mcp-server-weaviate

3.6

by weaviate

Weaviate MCP Server is a protocol server designed to interact with the Weaviate vector database, providing functionalities for inserting and querying data.

databases
mcp-pinecone

mcp-pinecone

3.6

by sirmews

The Pinecone Model Context Protocol Server for Claude Desktop allows users to read and write to a Pinecone index, facilitating operations like semantic search and document processing.

databases
mssql_mcp_server

mssql_mcp_server

3.6

by RichardHan

A Model Context Protocol (MCP) server that enables secure interaction with Microsoft SQL Server databases.

databases
elasticsearch-mcp-server

elasticsearch-mcp-server

3.6

by cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction. This server enables searching documents, analyzing indices, and managing cluster through a set of tools.

databases
firebase-mcp

firebase-mcp

3.6

by gannonh

Firebase MCP enables AI assistants to work directly with Firebase services, including Firestore, Storage, and Authentication.

databases
MCPServerForMSSQL

MCPServerForMSSQL

3.6

by shakunvohradeltek

This repository contains the SQL Server MCP (Model Context Protocol) integration for Claude, allowing direct querying and analysis of SQL Server databases using natural language.

databases
meilisearch-mcp

meilisearch-mcp

3.6

by meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces like Claude.

databases
postgres-mcp-server

postgres-mcp-server

3.6

by aadarshjain

A Model Context Protocol (MCP) server implementation for PostgreSQL database exploration and querying.

databases
mcp-snowflake-server

mcp-snowflake-server

3.6

by isaacwasserman

A Model Context Protocol (MCP) server implementation that provides database interaction with Snowflake.

databases
notion-mcp-server

notion-mcp-server

3.6

by awkoy

Notion MCP Server is a Model Context Protocol server implementation that enables AI assistants to interact with Notion's API, providing tools for reading, creating, and modifying Notion content through natural language interactions.

ai_chatbot
mcp-mysql-server

mcp-mysql-server

3.6

by f4ww4z

A Model Context Protocol server that provides MySQL database operations, enabling AI models to interact with MySQL databases through a standardized interface.

databases
doris-mcp-server

doris-mcp-server

3.6

by apache

Doris MCP Server is a backend service built with Python and FastAPI, designed to connect to Apache Doris databases and potentially leverage LLMs for tasks like NL2SQL.

databases