Plugin Claude Code
Single-plugin marketplace for the Redshift Comment MCP server (comment-first DB exploration with 11 tools).
Plugin Claude Code
Single-plugin marketplace for the Redshift Comment MCP server (comment-first DB exploration with 11 tools).
Plugin Claude Code
Redshift MCP server with comment-first exploration. 11 tools for schema/table/column listing, hit-count keyword search, and SELECT-only SQL. Comments are authoritative — names are unreliable. Zero-config install: run /redshift-comment-mcp:redshift-setup in chat after install — host / user / database via Q&A, password.
Instructions file
Claude Code instructions for kouko/redshift-comment-mcp, covering project guidance for claude code, version bumping (must), release publishing (must), tests live in three tiers and profile system gotchas.
Command
3-step guided wizard: schema → table → column. Each step lists candidates with comments so the user picks by reading, not remembering names. Hands off to /redshift-profile. Formalizes the Guided Data Discovery charter.
Command
Cross-table column search — find every column whose name or comment matches a keyword across all tables in one (or all) schemas via schema-wide MCP call. Composes the redshift-comment-mcp tools.
Command
Cross-schema table search — find every table whose name or comment matches a keyword across all schemas in the cluster via cluster-wide MCP call. Composes the redshift-comment-mcp tools.
Command
Mine Redshift's STLQUERY (or SYSQUERYHISTORY for serverless) + sqlglot to reconstruct ACTUAL table-to-table lineage from query history. Catches ad-hoc, BI-tool, manual-fix usage that dbt manifest can't see. Read-only; sqlglot helper script ships in assets.
Command
Profile a Redshift column — surface cardinality, top-N values, null rate, min/max, and the existing comment in one round. Read-only; composes the redshift-comment-mcp tools.
Command
Interactively configure a Redshift connection profile via chat Q&A. Non-secret fields collected in conversation; password collected in user's own terminal so it never enters chat history.
Command
Switch the active Redshift profile by flipping the active-profile pointer file. No connection field re-entry; verifies connection before declaring success. Single-profile users get a friendly bow-out.
Skill Claude CodeCodex
Interactive walkthrough for an unfamiliar Redshift cluster — schema → table → column, picked by reading comments. Hands off to /redshift-profile. Use when user doesn't know where to start in a cluster. Do NOT use when user already knows the table.column (use /redshift-profile directly) or in non-interactive contexts.…
Skill Claude CodeCodex
Cross-table column search — finds every column whose name or comment matches a keyword across all tables in one (or all) schemas via one schema-wide MCP call per schema. Use when user wants to find FK / shared-key columns across many tables (e.g. before composing a JOIN), or to audit column-naming consistency. Do NOT…
Skill Claude CodeCodex
Cross-schema table search — finds every table whose name or comment matches a keyword across all schemas via one cluster-wide MCP call. Use when user is looking for a table by topic but unsure which schema (e.g. "where is the orders fact table"), or auditing table-naming consistency. Do NOT use when schema is already…
Skill Claude CodeCodex
Reconstruct ACTUAL table-to-table data flow from Redshift query history — catches ad-hoc, BI-tool (Tableau / Looker), and manual-fix usage dbt manifest cannot see. Read-only. Use when auditing who reads / writes a table, or before deprecating one. Do NOT use for dbt-internal lineage (use dbt manifest) or real-time…
Skill Claude CodeCodex
Profile a Redshift column — cardinality, top-N values, null rate, min/max, plus comment. Read-only. Use when about to write CREATE TABLE or dbt schema.yml based on column assumptions, or to check whether a column is an enum. Do NOT use for full row counts (use executesql), schema/table search (use searchcolumns), or…
Skill Claude CodeCodex
Configure a Redshift connection profile for the redshift-comment-mcp plugin via chat — password stored in OS keychain via system dialog or terminal handoff (never in chat history), connection verified. Named form /redshift-setup adds a non-default profile and offers to activate it. Use when setting up first Redshift…
Skill Claude CodeCodex
Switch the active Redshift profile by flipping the active-profile pointer file at /.config/redshift-comment-mcp/active-profile (no host / user / password re-entry). Verifies connection before declaring success. Single-profile users get a friendly bow-out pointing to /redshift-setup. Use when switching between 2+…
MCP server Claude CodeCodexCursor
A Model-Context Protocol server for Amazon Redshift. Runs locally from the redshift-comment-mcp Python package.