Redshift MCP Server
Give your agent safe, read-only Amazon Redshift access with schema introspection and sampled rows for SQL and analytics work.
Overview
io.github.davidalbertonogueira/redshift-mcp-server is a MCP server for the Build phase that provides secure read-only Amazon Redshift access with schema introspection and smart sampling.
What is this MCP server?
- Read-only Amazon Redshift access designed for safer agent queries
- Schema introspection tools for tables, columns, and relationships
- Smart sampling to inspect row shape without dumping full tables
- npm package @davidalbertonogueira/redshift-mcp-server v1.0.5 stdio transport
- Redshift MCP Server titled package aligned to MCP server.schema.json 2025-10-17
- package version 1.0.5
- npm identifier @davidalbertonogueira/redshift-mcp-server
- stdio transport type
What problem does it solve?
Agents guess at Redshift table shapes and write risky SQL because they cannot see your real warehouse schema or representative samples safely.
Who is it for?
Indie builders with an existing Redshift warehouse who want MCP-assisted SQL, modeling, and debugging without write access in the agent path.
Skip if: Greenfield projects with no Redshift cluster, or teams that need mutating DDL/DML through the agent.
What do I get? / Deliverables
Your agent introspects Redshift schemas and sampled data read-only so queries and backend code align with production structures.
- Agent tools for Redshift schema metadata inspection
- Smart-sampled row previews for query design
- Read-only query path that avoids destructive warehouse operations
Recommended MCP Servers
Journey fit
Backend and data-layer work during Build is when you need accurate warehouse schemas and sample data to write queries and features. Backend subphase covers data stores and query paths; Redshift MCP targets warehouse inspection without opening full admin consoles in chat.
How it compares
Read-only warehouse MCP connector, not a full BI dashboard or dbt orchestration skill.
Common Questions / FAQ
Who is io.github.davidalbertonogueira/redshift-mcp-server for?
Developers and solo data-minded builders on Amazon Redshift who want coding agents to explore schemas and samples under read-only guardrails.
When should I use io.github.davidalbertonogueira/redshift-mcp-server?
Use it while building analytics features, writing SQL migrations context, or validating metrics logic against live warehouse metadata.
How do I add io.github.davidalbertonogueira/redshift-mcp-server to my agent?
Install @davidalbertonogueira/redshift-mcp-server from npm, configure stdio MCP in your client, and provide Redshift connection credentials per the package README on GitHub.