# Redshift Query

> Use this tool when you need to analyze data from Amazon Redshift warehouses using natural-language questions, and it solves problems such as complex data querying and schema exploration by translating queries into read-only SQL and providing insights into query execution. It takes natural-language input and outputs query results, schema information, and execution plans, with built-in protections like row limits and timeouts. Ideal for use cases requiring ad-hoc data analysis and exploration from Redshift data warehouses.

Canonical page: https://skillsregistry.net/skills/davisong-cup-redshift-query  
JSON: https://api.skillsregistry.net/v1/skills/davisong-cup-redshift-query

## Description

Redshift Query bridges AI assistants with Amazon Redshift data warehouses, allowing natural-language questions to be translated into read-only SQL queries executed via the Redshift Data API. It provides four tools for running queries, listing tables, describing schemas, and analyzing execution plans, with built-in row limits and timeout protection.

## Trust

- **Trust score (0–1):** 0.65
- **Verification tier:** scanned
- **Last scanned:** 2026-09-03

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-03

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/davisong-cup-redshift-query)
- **Repository:** <https://github.com/davisong-cup/query-mcp-poc>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "davisong-cup-redshift-query"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/davisong-cup-redshift-query` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/davisong-cup-redshift-query/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt
