Redshift
This MCP server provides AI assistants with secure Amazon Redshift database access through a FastMCP-based implementation built by Anshul Patre using Python with configurable security modes (readonly, readwrite, admin) that enforce SQL operation restrictions based on environment variables. The implementation features automatic connection management using environment variables or manual credentials, comprehensive database operations including schema/table discovery and query execution, and built-in SQL command filtering that prevents dangerous operations in restricted modes. Built with support for both Amazon's official redshift-connector and PostgreSQL-compatible drivers, automatic reconnection capabilities, and structured JSON responses for all operations, it serves data analysts needing conversational database querying, developers requiring AI-assisted data exploration, and teams wanting secure programmatic access to Redshift warehouses with granular permission controls and connection state management.
Composite of vulnerability cleanliness, spec conformance, provenance, stability, and usage signals — scanned and weighted by Cognium. Human and agent signals are tracked separately. Last scanned 2026-09-28.
Scan details: Circle-IR · 2026-09-28 · Appeal
View full trust & usage report →Metadata
- Version
- 1.0.0
- Skill type
- atomic
- Execution layer
- mcp-remote
- Category
- database
- Source
- PulseMCP
- Repository
- github.com/anshulpatre/my-redshift-mcp
- Author type
- human
- Last scanned
- 2026-09-28
- Updated
- 2026-09-28
Use via MCP
Resolve Redshift from your agent
Streamable HTTP transport at https://api.skillsregistry.net/mcp. No auth for read tools. Discovery: .well-known/mcp.json.
One command in your shell — Claude Code wires it up and verifies the connection. Run /mcp in any session to confirm.
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp--scope user for --scope project to commit it to .mcp.json.