{"id":"cdatasoftware-amazon-redshift-mcp-server-by-cdata","name":"amazon-redshift-mcp-server-by-cdata","af_score":50.0,"security_score":49.8,"reliability_score":18.8,"what_it_does":"Provides a local MCP (Model Context Protocol) server that wraps the CData JDBC Driver for Amazon Redshift, exposing database metadata (tables/columns) and query execution via MCP tools so an LLM client can retrieve Redshift data (README describes read-only as the project’s intent).","best_when":"You want a local, developer-controlled MCP integration to let an LLM explore and run SELECT queries against Redshift over stdio on the same machine.","avoid_when":"You need network-accessible API endpoints, fine-grained API authorization managed by the MCP server, or you cannot control what SQL the LLM/client may generate.","last_evaluated":"2026-04-04T19:49:30.306623+00:00","has_mcp":true,"has_api":false,"auth_methods":["CData JDBC driver authentication mechanisms (including OAuth when specified by JdbcUrl/connection string)"],"has_free_tier":false,"known_gotchas":["Server uses stdio and therefore only works with clients running on the same machine (per README).","The tools allow SQL SELECT execution via a run_query tool; LLMs may generate overly broad or expensive queries unless constrained.","The README does not document pagination/limits; large result sets may be truncated or expensive depending on driver/client behavior.","Tool outputs are described as CSV for tables/columns; agents should handle CSV parsing correctly."],"error_quality":0.0}