sripaladugu/mcp-client-server

3.2

If you are the rightful owner of mcp-client-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 querying Redshift databases, implemented in Python using FastMCP.

Tools

Functions exposed to the LLM to take actions

query

Executes a read-only SQL query against the Redshift database

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

sripaladugu

Claim Ownership

Verify you have write access to the repository

Version

v.1.0.0

Repository

https://github.com/sripaladugu/mcp-client-server

GitHub Stars

Last publish date

2025-05-10

Last update date

2025-08-03

Server configs

in cursor

{
  "mcpServers": {
    "redshift-mcp-docker": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DEFAULT_SCHEMA=flatiron_cmdb_nsclc_sdm_latest",
        "redshift-mcp-py-simple",
        "postgresql://username:password@redshift-url:5439/database?sslmode=require"
      ],
      "description": "Redshift MCP Server in Docker",
      "env": {}
    }
  }
}

in claude desktop

{
  "servers": [
    {
      "name": "Redshift MCP Server",
      "command": "python",
      "args": [
        "/path/to/redshift_mcp_server.py",
        "postgresql://username:password@hostname:port/database?sslmode=require"
      ],
      "description": "Redshift MCP Server in Python"
    }
  ]
}

Top Comments

Related MCP Servers

View all databases servers →

notion-mcp-server

4.3

by makenotion

This project implements an MCP server for the Notion API, allowing integration with LLMs.

databases

python-mcp-server-client

4.2

by GobinFan

MCP Server is a server implementing the Model Context Protocol (MCP) to provide a standardized interface for AI models, connecting external data sources and tools like file systems, databases, or APIs.

ai_chatbot

prisma

4.1

by prisma

Prisma is a next-generation ORM for Node.js and TypeScript, providing tools for data modeling, migrations, and querying databases.

databases

mcp-server-qdrant

4.0

by qdrant

The mcp-server-qdrant is a Model Context Protocol server designed to integrate with the Qdrant vector search engine, providing a semantic memory layer for storing and retrieving information.

knowledge_and_memory

mcp-memory-libsql

4.0

by spences10

A high-performance, persistent memory system for the Model Context Protocol (MCP) powered by libSQL, providing vector search capabilities and efficient knowledge storage.

knowledge_and_memory

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

mcp-graphql

4.0

by blurrah

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

databases

mysql_mcp_server_pro

4.0

by wenb1n-dev

mcp_mysql_server_pro is a comprehensive MySQL server tool that extends beyond basic CRUD operations to include database anomaly analysis and custom tool extensions.

databases

db-mcp-server

3.9

by FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

databases

supabase-mcp

3.9

by coleam00

A Model Context Protocol (MCP) server that provides tools for interacting with a Supabase database. This server enables AI assistants to perform database operations through a standardized interface.

databases

mcp-server

3.9

by keboola

Keboola MCP Server connects AI agents and MCP clients to Keboola, enabling data access and transformations without glue code.

cloud_platforms

doris-mcp-server

3.9

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

postgresql-mcp-server

3.9

by HenkDz

A Model Context Protocol (MCP) server that provides comprehensive PostgreSQL database management capabilities for AI assistants.

databases

osv-mcp

3.8

by StacklokLabs

An MCP server providing access to the OSV database for querying vulnerability information.

databases

mcp-server-mysql

3.7

by benborla

A Model Context Protocol server for MySQL databases using NodeJS, enabling LLMs to inspect schemas and execute SQL queries.

databases

mcp-proxy

3.7

by TBXark

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

databases

anyquery

3.7

by julien040

Anyquery is a versatile SQL query engine that allows users to run SQL queries on various data sources, including files, databases, and applications, with support for LLMs and MySQL server functionality.

databases

chroma-mcp

3.7

by chroma-core

Chroma MCP Server is an open-source embedding database server that facilitates the integration of LLM applications with external data sources using the Model Context Protocol.

databases

mcp-server-motherduck

3.7

by motherduckdb

An MCP server implementation that interacts with DuckDB and MotherDuck databases, providing SQL analytics capabilities to AI Assistants and IDEs.

databases

mcp-google-sheets

3.7

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

openehr-mcp-server

3.7

by deak-ai

An MCP server designed to interface with openEHR REST APIs, specifically the EHRbase implementation.

databases

mcp-redis

3.6

by redis

The Redis MCP Server is a natural language interface designed for agentic applications to efficiently manage and search data in Redis.

databases

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-mongo-server

3.6

by kiliczsh

A Model Context Protocol server that enables LLMs to interact with MongoDB databases, providing capabilities for inspecting collection schemas and executing MongoDB operations through a standardized interface.

databases