Skip to main content
Glama
kouko

redshift-comment-mcp

by kouko

redshift-comment-mcp

English · 日本語 · 繁體中文

A read-only Model Context Protocol server for Amazon Redshift, plus a Claude Code plugin with 6 slash-command skills built on top. Designed around one assertion: column names lie, comments don't — so the server exposes comments aggressively and the skills compose those tools into the discovery workflows you actually do every day.

"What values does dbt_marts.fct_orders.status really hold?"
   → /redshift-profile dbt_marts.fct_orders status
   → cardinality, top-N, null rate, min/max, existing comment — one round.

Why this exists

If you've ever opened an unfamiliar Redshift table and squinted at column names like f3, legacy_id_v2, or status (which status?), you already know the pain. dbt manifests are too narrow. Web GUIs are too slow. Hand-written SQL is too repetitive.

This plugin's charter is Guided Data Discovery:

  • Comments first. Every list / search tool returns the column, table, or schema comment when asked — names are advisory, comments are authoritative.

  • Read-only by construction. execute_sql rejects DDL / DML at the parse layer; no skill in this repo can mutate Redshift.

  • MCP-composed skills. New workflows are built by stringing together existing tools, not by adding new database connections.

  • No persistence. No synthesis layer, no .redshift-wiki/ markdown, no stale tracking. Persistence belongs in a separate plugin.

See implementation_guide.md §1.2 for the full charter.

Related MCP server: redshift-utils-mcp

What you get

MCP tools (13, defined in src/redshift_comment_mcp/)

Group

Tools

List

list_schemas · list_tables · list_columns

Search (hit-count ranked)

search_schemas · search_tables · search_columns

Comment retrieval

get_schema_comment · get_table_comment · get_column_comment · get_all_column_comments

Query

execute_sql (SELECT / WITH only)

Setup (since v0.7.0)

setup_via_dialog — in-band profile bootstrap; OS-native password dialog, never crosses MCP wire; tests connection before declaring success · get_setup_status — read-only configuration check; safe to call at session start; never returns password value

Pagination on every list / search; explicit WARNING strings nudging the LLM to read comments before trusting names.

Slash-command skills (6, defined in skills/)

Skill

One-liner

Since

/redshift-setup

Conversational walk-through to configure a connection profile.

v0.2.0

/redshift-switch-profile

Switch the active profile (no host / user / password re-entry); single-profile users get a friendly bow-out.

v0.4.0

/redshift-profile

Profile a column: cardinality / top-N / null rate / min-max / existing comment, one round.

v0.3.0

/redshift-explore

Three-step interactive wizard (schema → table → column) — pick by reading comments.

v0.3.0

/redshift-lineage-from-stl

Mine STL_QUERY + sqlglot to reconstruct actual table-to-table lineage from query history.

v0.3.0

/redshift-grep-columns

Cross-table column search by keyword across one or all schemas via schema-wide MCP call.

v0.4.0

/redshift-grep-tables

Cross-schema table search by keyword across all schemas via cluster-wide MCP call.

v0.4.0

Each skill has its own tri-lingual README inside its folder (except /redshift-setup and /redshift-switch-profile, which are setup-style internals — see SKILL.md directly).

Quick start

The fastest path is the Claude Code plugin.

# 1. Register the marketplace (one-time)
claude plugin marketplace add kouko/redshift-comment-mcp

# 2. Install the plugin (ships DISABLED — opt-in, since it connects to an external service)
claude plugin install redshift-comment-mcp

# 3. Enable it — this is when the connection dialog appears
claude plugin enable redshift-comment-mcp

When you enable the plugin, Claude Code shows a connection dialog asking for host / port (default 5439) / user / dbname / password. There are two ways to connect — pick one; both store the password in an OS keychain, never in chat or settings.json:

  • Quick single connection — fill the dialog. The password field is sensitive, so it goes to the OS keychain; host / port / user / dbname are saved to settings.json. That's all you need for one cluster.

  • Profiles / multi-cluster — leave the dialog blank and run /redshift-setup. The fields are optional; leave them blank and the plugin falls back to the profile flow. /redshift-setup is the conversational walk-through that writes a named profile (config.toml + active-profile pointer + keychain), and it's the path for running more than one cluster.

# In a Claude Code chat — the profile path (also the multi-cluster path)
/redshift-setup

/redshift-setup walks you through host / port / user / dbname / password. The password is collected in a system dialog (macOS) or a zenity prompt (Linux desktop) or your own terminal (headless) — never in chat. It lands directly in your OS keychain.

After connecting, just type any of the slash commands above. Multi-cluster? Add a second profile with /redshift-setup <name>, then switch between them with /redshift-switch-profile.

For Claude Desktop / other MCP clients / local development, scroll down to Other install paths.

Other install paths

Two packaged artifacts — install ONE of them:

  • Claude Code plugin — gives the 6 slash-command skills plus the MCP server, configured via /redshift-setup. This is the Quick start above and the recommended path for Claude Code users.

  • .mcpb Desktop Extension — gives the MCP server plus a GUI config form in Claude Desktop, but NOT the skills. This is the path for Claude Desktop users who want a one-click install and a connection form instead of editing claude_desktop_config.json by hand.

Scenario

How

Claude Code (recommended)

claude plugin install redshift-comment-mcp (above), then enable it — Claude Code pops a connection dialog (host / port / user / dbname / password; password → OS keychain). Fill it for one quick connection, or leave it blank and run /redshift-setup instead.

Claude Desktop (one-click)

Download the .mcpb from the project's GitHub Releases page, then install it in Claude Desktop (Settings → Extensions, or drag-and-drop the file). Claude Desktop shows a connection form — fill in host / port / user / dbname / password (the password is stored in the OS keychain). Requires uv (see prerequisite below). Ships the server + form, not the skills.

Claude Desktop / generic MCP client (manual)

pip install redshift-comment-mcp then point your client at uvx redshift-comment-mcp (or --profile <name> to override the pointer file)

Local development

git clone … && pip install -e ".[dev]" then python -m redshift_comment_mcp.server

Multi-cluster

/redshift-setup <name> per cluster + /redshift-switch-profile to switch

.mcpb prerequisite — uv. The Desktop Extension runs on the uv runtime, so uv must be available on your machine before you install the .mcpb (e.g. brew install uv on macOS). The Claude Code plugin path does not need this step — Claude Code provides its own uv.

The plugin runs from the cloned repo source via uv run --project ${CLAUDE_PLUGIN_ROOT} — PyPI release is NOT a prerequisite for plugin updates.

Setting up with uvx — Claude Desktop / generic MCP client

The Claude Code plugin's uv run --project ${CLAUDE_PLUGIN_ROOT} form is specific to Claude Code. For any other MCP client (Claude Desktop, generic stdio MCP clients), the equivalent launch is uvx redshift-comment-mcp against the PyPI release.

Step 1 — set up a profile via the CLI. redshift-comment-mcp ships the same Q&A flow that the Claude Code plugin's /redshift-setup uses, exposed as subcommands:

# interactive Q&A — writes config.toml + stores password in OS keychain
uvx redshift-comment-mcp setup

# or a named profile (for multi-cluster setups)
uvx redshift-comment-mcp setup --profile prod

# verify
uvx redshift-comment-mcp test-connection --profile prod
uvx redshift-comment-mcp list-profiles

The files it writes — ~/.config/redshift-comment-mcp/config.toml + OS keychain entry under service redshift-comment-mcp — are per-user, not per-client. Run setup once and every MCP client that launches uvx redshift-comment-mcp afterwards reads the same profile data. If you already have Claude Code with the plugin, /redshift-setup writes the exact same files; no duplicate setup needed.

Other useful subcommands: set-password, delete-profile. See uvx redshift-comment-mcp --help.

For code-agent bootstrap (any MCP client, since v0.7.0): the preferred path is the in-band MCP tool setup_via_dialog — no Bash tool, no MCP client restart, password stays out of chat:

agent calls any DB tool          → {"error": "not_configured", "next_step": "Call setup_via_dialog..."}
agent asks user for host/user/dbname  (these are NOT secrets)
agent calls MCP tool setup_via_dialog(host=..., user=..., dbname=...)
                                 → server-side spawns OS dialog (macOS osascript / Linux zenity)
                                 → user types password directly into dialog
                                 → server writes config.toml + keychain
                                 → {"status": "configured", ...}
agent retries the DB tool        → works (lazy resolve; no restart needed)

The server boots in degraded mode even when no profile exists — DB tools return a structured not_configured error pointing at setup_via_dialog, so the agent sees the recovery path in its own tool-call result (no need to read MCP client log files). After setup, lazy resolution picks up the new profile on the next tool call.

Fallback for headless / non-GUI hosts (no osascript / no zenity): drop to the Bash + CLI path which uses --stdin instead of the dialog:

uvx redshift-comment-mcp set-fields --profile default \
    --host H --port P --user U --dbname D
echo "$PASSWORD" | uvx redshift-comment-mcp set-password \
    --profile default --stdin

Step 2 — single profile. In claude_desktop_config.json (or your client's equivalent):

{
  "mcpServers": {
    "redshift-comment": {
      "command": "uvx",
      "args": ["redshift-comment-mcp"]
    }
  }
}

The server resolves which profile to use via this chain (most explicit wins): --profile CLI flag > REDSHIFT_COMMENT_PROFILE env var > active-profile pointer file > implicit fallback (lone profile rescue / default).

Step 3 — multi-cluster. One MCP server entry per profile, override the pointer file via --profile:

{
  "mcpServers": {
    "redshift-prod": {
      "command": "uvx",
      "args": ["redshift-comment-mcp", "--profile", "prod"]
    },
    "redshift-stg": {
      "command": "uvx",
      "args": ["redshift-comment-mcp", "--profile", "stg"]
    }
  }
}

Each entry runs as a separate MCP server; tools appear in the client under their respective server names.

Tip — uv tool install for faster startup. uvx fetches and spawns on every invocation (~2s after the first cache warmup). If you'd rather pay the install cost once:

uv tool install redshift-comment-mcp

then point "command" at redshift-comment-mcp directly with no uvx wrapper.

Where things live

.
├── README.md / README.ja.md / README.zh-TW.md     (this file, tri-lingual)
├── implementation_guide.md                         design rationale + charter
├── src/redshift_comment_mcp/                       MCP server source — see its own README
├── skills/                                         5 slash-command skills — see its own README
├── commands/                                       plugin slash command stubs
├── tests/                                          pytest suite
├── pyproject.toml                                  packaging metadata
└── .claude-plugin/                                 plugin manifest + marketplace

The two READMEs to read next:

Data layout at runtime

Path

Contents

Permissions

~/.config/redshift-comment-mcp/config.toml

Non-secret profile fields

0600

~/.config/redshift-comment-mcp/active-profile

One-line pointer to the active profile name. Absent ↔ server uses default (canonical single-profile state — most users never see this file).

0600

OS keychain (redshift-comment-mcp / <profile>)

Passwords

OS-managed

execute_sql blocks DDL / DML / admin keywords at the parser layer (DROP / DELETE / UPDATE / INSERT / ALTER / CREATE / TRUNCATE / MERGE / GRANT / REVOKE / COPY / UNLOAD), but that's a layer-1 defense. The defense-in-depth move is to give the plugin's connecting Redshift user read-only privileges only, so even if a parser bypass is found, the database itself rejects writes:

-- Create a dedicated read-only user for the plugin
CREATE USER redshift_mcp_reader WITH PASSWORD '...';

-- Grant only what the plugin actually needs
GRANT USAGE ON SCHEMA public, dbt_marts, dbt_staging TO redshift_mcp_reader;
GRANT SELECT ON ALL TABLES IN SCHEMA public, dbt_marts, dbt_staging TO redshift_mcp_reader;
ALTER DEFAULT PRIVILEGES IN SCHEMA public, dbt_marts, dbt_staging
  GRANT SELECT ON TABLES TO redshift_mcp_reader;

-- Do NOT grant: INSERT / UPDATE / DELETE / TRUNCATE / DROP / CREATE / GRANT / superuser

For /redshift-lineage-from-stl, the user additionally needs SYSLOG ACCESS UNRESTRICTED (or admin) to read STL_QUERY / SYS_QUERY_HISTORY. If you're not running that skill, skip this grant.

Known limits

MCP response token cap (~25K tokens default) — Claude Code silently truncates MCP tool results above ~25,000 tokens (no error, no marker; see anthropics/claude-code#2638). For dbt-rich schemas where column comments are long markdown blocks, a single list_columns(include_comments=True) page (50 rows) on a wide table can approach this. Two mitigations the plugin already applies:

  • include_comments defaults to False on list_tables / list_columns (only list_schemas defaults True since schema count is small) — agent must opt in to comment-loaded responses.

  • MAX_COMMENT_LEN=1000 caps each comment in multi-item responses (with comment_truncated_count + ellipsis marker). Single-item getters (get_table_comment / get_column_comment) never truncate.

If you still need to bump the cap (e.g. to fetch a heavily-documented column set in one shot), set MAX_MCP_OUTPUT_TOKENS=50000 in the environment where Claude Code runs. This affects all MCP servers in that session, not just this one.

Comment-writing tips for your DB

The plugin shines brightest on tables whose owners invest in comments. Concrete tips (Chinese examples — adapt to your team's language):

COMMENT ON SCHEMA   sales        IS '[用途] 線上零售銷售數據 [主要實體] 訂單, 客戶, 產品';
COMMENT ON TABLE    sales.orders IS '[實體] 訂單 [PK] order_id [FK] customer_id → customers.customer_id';
COMMENT ON COLUMN   sales.orders.revenue IS '[定義] 訂單總銷售額 [語意類型] Metric [單位] 新台幣 [計算] 未稅商品總價 + 稅 − 折扣';

A more thorough Semantic Layer guide is in implementation_guide.md Appendix A.

Development

pytest tests/                    # run unit + invariant tests (fast, no live cluster)
REDSHIFT_INTEGRATION=1 \
  pytest tests/integration/      # opt-in: smoke-test against the active Redshift profile
python -m build                  # build sdist + wheel

The tests/integration/ smoke gate exercises every MCP tool against a real Redshift cluster — connection, list / search / get tools, pagination, the SQL-safety guard. It skips cleanly when REDSHIFT_INTEGRATION is unset, when no active profile is configured, or when the keychain entry is missing, so default pytest tests/ is safe in CI.

CI / release flow lives in .github/.

License

MIT

Contributing

Issues and pull requests welcome. New skills should follow the patterns documented in skills/README.md: read-only, MCP-composed, no direct DB connections, no synthesis layer. SKILL.md ≤ 130 lines, tri-lingual README, audited via dev-workflow:skill-judge before commit.

Available Tools

13 tools
execute_sqlA

Execute a read-only SQL query (SELECT/WITH only). Result rows are paginated via limit/offset.

ParametersJSON Schema
NameRequiredDescriptionDefault
limitNo
offsetNo
sql_statementYes

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Discloses read-only nature and pagination via limit/offset, which are key behaviors. With no annotations, this is good disclosure, though it doesn't cover error handling or output format details.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two succinct sentences that front-load the purpose and then add a key detail. No redundant words.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Covers the main aspects of the tool. With an output schema present, the description is sufficiently complete for a 3-parameter tool, though it omits potential constraints like query length.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Adds meaning to sql_statement by specifying allowed query types and to limit/offset by mentioning pagination, supplementing the schema which has 0% description coverage.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool executes read-only SQL queries restricted to SELECT and WITH statements, distinguishing it from sibling tools that provide specific schema/table info.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Implies when to use (custom read-only SQL queries) and implicitly excludes write queries by specifying SELECT/WITH only, but does not explicitly mention alternatives or when not to use.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_all_column_commentsB

Get authoritative comments for ALL columns in a table at once. Each comment overrides the column name.

ParametersJSON Schema
NameRequiredDescriptionDefault
limitNo
offsetNo
table_nameYes
schema_nameYes

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description bears full responsibility for behavioral disclosure. It adds one behavioral trait ('Each comment overrides the column name') but omits key behaviors such as handling empty results, pagination (limit/offset), or whether the tool is read-only. This is insufficient for a safe agent decision.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

A single sentence that conveys purpose and a critical behavioral note. It is not overly verbose, but the sentence is slightly packed; consider splitting for readability. Still very efficient.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Output schema exists, so return value details are not required, but the description should at least mention that the tool returns a list or map of column comments. It also fails to address the presence of pagination parameters or the fact that it retrieves 'ALL' columns despite having limit/offset. Completeness is adequate but not thorough.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters1/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Input schema has 4 parameters with 0% description coverage, and the tool description provides zero explanation for them. It does not clarify what 'schema_name' or 'table_name' represent, nor how 'limit' and 'offset' control pagination. An agent cannot infer correct usage solely from the description.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses a specific verb ('Get') and resource ('authoritative comments for ALL columns in a table at once'), clearly distinguishing this tool from siblings like 'get_column_comment' (singular) and 'get_table_comment'. The phrase 'at once' emphasizes batch retrieval.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No explicit guidance on when to use this tool versus alternatives (e.g., 'get_column_comment' for a single column). While the name and description imply it is for retrieving all column comments, there is no direct comparison or indication of prerequisites or exclusions.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_column_commentB

Get the authoritative comment for a column — defines its business meaning and calculation logic; trust it over the column name.

ParametersJSON Schema
NameRequiredDescriptionDefault
table_nameYes
column_nameYes
schema_nameYes

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

B3.3/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description bears the full burden. It only says 'get', implying a read operation, but does not disclose any behavioral traits such as what happens if the column does not exist, whether there are side effects, authentication needs, or rate limits. The output schema exists but is not described to compensate.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single efficient sentence that front-loads the purpose. It feels concise and adds the key nuance about authority. However, it could be structured with separate sentences for behavioral notes without significant length increase, though it is not verbose.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the presence of an output schema (not detailed), the description lacks return format details and error scenarios. The tool is simple, but with three parameters and no guidance on input formatting, it is partially complete. For an agent, more context on expected input patterns or output structure would be beneficial.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters1/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, meaning the description adds no value for parameters. The parameter names (schema_name, table_name, column_name) are self-explanatory, but the description does not clarify expected formats, case sensitivity, or any constraints beyond the schema. With no param information, the score is minimal.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool gets the authoritative comment for a column, specifying that it defines business meaning and calculation logic, and to trust it over the column name. This distinguishes it from sibling tools like get_table_comment (table-level) or get_all_column_comments (all columns), providing a specific verb and resource with scope.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implies when to use (when authoritative business meaning/calculation logic is needed) and tells the agent to trust this over column names. However, it does not explicitly mention when not to use or compare to alternatives like search_columns or get_table_comment, so it lacks full exclusionary guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_schema_commentB

Get the authoritative comment for a schema — defines its true business purpose; trust it over the schema name.

ParametersJSON Schema
NameRequiredDescriptionDefault
schema_nameYes

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

B3.1/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description must cover behavioral traits. It does not mention whether the tool is read-only, if it requires special permissions, or what happens if the schema doesn't exist. The phrase 'authoritative comment' hints at reliability but lacks specifics.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single sentence that is front-loaded with the action and purpose. It is concise and avoids redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

The tool has a single required parameter and an output schema, so the description can be brief. However, it lacks details about the return format or scenarios where the comment might be empty. It is adequate but not comprehensive.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters1/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The schema coverage is 0%, meaning the description doesn't explain the parameter 'schema_name'. The parameter is only defined by its name and type, with no additional context in the description.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool retrieves the authoritative comment for a schema, distinguishing it from sibling tools like get_table_comment and get_column_comment. It emphasizes trusting this over the schema name, which adds context.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implies use when you need the true business purpose of a schema, but does not explicitly state when not to use or provide alternatives. No direct contrast with siblings like list_schemas.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_setup_statusA

Read-only check of whether a profile is configured. Safe to call at any time including the very start of a session — does not touch Redshift, does not return any secrets.

Use at session start to decide proactively whether to call setup_via_dialog (before triggering any DB tool's not_configured error path), or to verify a setup_via_dialog call succeeded from a fresh angle.

Returns:

  • profile — the queried profile name

  • source"inline" when the server was launched in legacy inline mode (--host/--user/--dbname + REDSHIFT_ PASSWORD env, e.g. the Claude Code plugin UI), else "profile". In inline mode the profile/keychain path is bypassed entirely, so don't go hunting for an active profile.

  • configured — bool, equivalent to has_fields && has_password

  • has_fields — whether config.toml has this profile's non-secret fields (host / port / user / dbname); in inline mode, True (the fields came from launch args)

  • has_password — whether a password is available (OS keychain in profile mode; REDSHIFT_PASSWORD / --password in inline mode). NEVER returns the password itself

  • host / port / user / dbname — present only when has_fields=True (these are non-secret)

  • next_step — present only when configured=False; actionable hint pointing at the right mechanism for the mode

ParametersJSON Schema
NameRequiredDescriptionDefault
profileNodefault

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

A4.6/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations provided, so the description fully carries the burden. It states 'read-only', 'does not touch Redshift', 'does not return any secrets', and explains return fields including behavior in inline mode. This is comprehensive and transparent.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with clear sections and bullet points for returns. It is information-dense but not overly verbose. A slight reduction in the return list could improve conciseness, but it remains effective.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the simple input and presence of an output schema, the description covers all necessary aspects: safety, use cases, return details, inline vs profile mode distinctions, and actionable hints. It is fully complete for this tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema has one parameter 'profile' with 0% description coverage. The description does not explicitly describe the input parameter; it only mentions 'the queried profile name' in the return section, which implies but does not clearly state that the input specifies which profile to check. The added value is marginal.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool is a 'read-only check of whether a profile is configured' with specific verb and resource. It distinguishes itself from siblings like 'setup_via_dialog' and 'execute_sql' by noting it does not touch Redshift and is safe to call at any time.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Explicitly provides when to use: at session start to decide proactively whether to call 'setup_via_dialog', or to verify a setup call succeeded. It also advises against hunting for an active profile in inline mode, offering clear context for usage.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

get_table_commentA

Get the authoritative comment for a table — defines what data it actually contains; trust it over the table name.

ParametersJSON Schema
NameRequiredDescriptionDefault
table_nameYes
schema_nameYes

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

A4.2/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries full burden for behavioral disclosure. It correctly indicates a read operation (get) and adds valuable context about the comment's authoritativeness. There are no contradictory statements, and the simple nature of the tool means no further negative traits need disclosure.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single sentence with no filler words. It front-loads the action and resource, then immediately adds the key semantic nuance. Every part earns its place.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's low complexity (2 simple parameters) and the existence of an output schema, the description is sufficient. It clearly states what the tool returns (authoritative comment) and provides context for its use. No critical information is missing for an agent to invoke it correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, so the description should compensate for parameter meaning. Parameter names (schema_name and table_name) are self-explanatory, and the description's mention of 'table' implicitly relates to the table_name parameter. However, no additional semantic detail is provided beyond the schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses the specific verb 'Get' and identifies the resource as 'the authoritative comment for a table'. It clearly distinguishes the tool from siblings like get_column_comment or list_tables by emphasizing that the comment defines actual data content and should be trusted over the table name.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implicitly guides usage by stating to trust the comment over the table name, suggesting use when reliable data content understanding is needed. It does not explicitly list when not to use or contrast with specific alternatives, but the context of sibling tools makes the differentiation apparent.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_columnsC

List columns (name, type, nullable) in a table. Pass include_comments=True to include column comments inline; include_parent_comments (default True) also returns the parent table's comment.

ParametersJSON Schema
NameRequiredDescriptionDefault
limitNo
offsetNo
table_nameYes
schema_nameYes
include_commentsNo
include_parent_commentsNo

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description must disclose behavioral traits. It mentions optional comment inclusion but omits what happens if the table does not exist, whether the operation is read-only, or any pagination behavior for limit/offset.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single, efficient sentence that front-loads the core purpose. It adds detail on optional parameters without verbosity.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Despite having 6 parameters, the description only covers 2 boolean ones. It does not clarify that limit/offset are for pagination, and the output schema (even if present) is not referenced to explain return structure. Sibling list_tables could cause confusion without differentiation.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters2/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, yet the description only explains include_comments and include_parent_comments with their defaults. Required parameters schema_name and table_name, plus limit and offset, lack any explanation, leaving ambiguity.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states 'List columns (name, type, nullable) in a table', specifying the verb, resource, and key attributes. It distinguishes from siblings like get_column_comment (retrieves a single comment) and search_columns (searches across tables).

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives like execute_sql, search_columns, or list_tables. It does not mention typical use cases or conditions to avoid.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_schemasA

List schema names. include_comments defaults to True (cheap — schema count is small).

ParametersJSON Schema
NameRequiredDescriptionDefault
limitNo
offsetNo
include_commentsNo

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

A3.8/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries full burden. It discloses the cost ('cheap') and default behavior of include_comments. Could add more about permissions or result limits, but sufficient for a simple list operation.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Extremely concise with no wasted words. Two sentences, first captures purpose, second adds valuable default/cost context. Perfectly front-loaded.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given an output schema exists, return values are covered. However, incomplete parameter documentation (limit/offset) leaves a gap. The tool is simple, so not critical, but should explain pagination parameters.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters2/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, so description must compensate. It only addresses 'include_comments' (default, cheap). 'limit' and 'offset' are not mentioned at all, leaving the agent to guess their purpose.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

Clearly states 'List schema names', a specific verb and resource. Differentiates from siblings like search_schemas by focusing on listing all names. Also provides nuance about the cost of include_comments.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Implies usage for listing all schema names, and mentions include_comments is cheap, but does not explicitly tell when to use this tool versus search_schemas or list_tables. No when-not-to-use or alternatives mentioned.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

list_tablesB

List tables in a schema. Pass include_comments=True to include table comments inline; include_parent_comments (default True) also returns the parent schema's comment.

ParametersJSON Schema
NameRequiredDescriptionDefault
limitNo
offsetNo
schema_nameYes
include_commentsNo
include_parent_commentsNo

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

B3.3/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description must fully disclose behavior. It mentions parameter effects but omits critical aspects such as pagination behavior (limit/offset), error conditions, access requirements, or the structure of the returned data.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is concise at two sentences, front-loaded with the core purpose, and contains no redundant information.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity (5 parameters, no annotations, low schema coverage) and the existence of an output schema, the description fails to provide adequate contextual detail about parameter usage, behavior, and prerequisites, leaving significant gaps.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters2/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, so the description must explain all parameters. It only covers include_comments and include_parent_comments, leaving schema_name, limit, and offset unexplained, which is insufficient for an agent to use the tool correctly.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action ('List tables') and the resource ('in a schema'), which is specific and distinguishes it from sibling tools like list_columns or search_tables.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines3/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides hints on when to use optional parameters (include_comments, include_parent_comments) but does not specify when to prefer this tool over alternatives like search_tables or list_columns, nor does it give explicit when-not-to-use guidance.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

search_columnsA

Search columns by keywords (space-separated, OR logic) over column name and comment.

schema_name is required. Pass table_name to scope to one table (cheap; use this for routine drill-down). Omit table_name to search every table in the schema (schema-wide; the natural primitive for cross-table FK / JOIN-key reconnaissance, returns table_name on each row).

ParametersJSON Schema
NameRequiredDescriptionDefault
limitNo
offsetNo
keywordsYes
table_nameNo
schema_nameYes

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

A4.2/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the full burden. It discloses search logic (OR, space-separated), return of table_name when omitted, and required params. However, it does not state whether the tool is read-only or describe pagination behavior for limit/offset, which are minor gaps.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is extremely concise, using two sentences to cover purpose, required params, and two usage modes. No redundancy or filler.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

With an output schema present, return values need not be described. The description covers the core parameters (3 of 5) well, but omits limit/offset. Given the complexity of 5 params and 0% schema coverage, the description is mostly complete but has a minor gap.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, so the description must compensate. It explains keywords, schema_name, and table_name well, but fails to describe limit and offset parameters. Since limit and offset are common but not self-explanatory in context, this leaves a gap.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool searches columns by keywords (space-separated, OR logic) over name and comment, with a required schema_name and optional table_name. It effectively distinguishes from sibling tools like search_tables and search_schemas by specifying the resource (columns) and the two usage modes.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides explicit guidance on when to use table_name (routine drill-down) and when to omit it (cross-table FK/JOIN-key reconnaissance). However, it does not mention alternatives like list_columns or execute_sql, leaving some ambiguity for edge cases.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

search_schemasA

Search schemas by keywords (space-separated, OR logic) over schema name and comment.

ParametersJSON Schema
NameRequiredDescriptionDefault
limitNo
offsetNo
keywordsYes

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

A3.7/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Discloses OR logic and searchable fields (name and comment) but does not mention sorting, case sensitivity, or behavior with no results. Without annotations, more transparency is needed.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Single sentence, no redundancy, directly explains functionality.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given no annotations and 3 parameters, the description is minimal but covers core behavior. Could mention sorting, defaults, or return format, but output schema likely provides that.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Adds meaning beyond schema: keywords are space-separated, OR logic, applied to name and comment. Limit and offset are not described but are standard. Schema coverage is 0%, so description compensates well.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

Description clearly states the tool searches schemas by keywords over name and comment with OR logic. It distinguishes from sibling tools like search_tables and search_columns.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No guidance on when to use this tool vs alternatives like list_schemas or search_columns. The description lacks usage context and exclusion criteria.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

search_tablesA

Search tables by keywords (space-separated, OR logic) over table name and comment.

Pass schema_name to scope to one schema (faster, narrower). Omit it to search across all user schemas in the cluster (broader, slightly slower).

ParametersJSON Schema
NameRequiredDescriptionDefault
limitNo
offsetNo
keywordsYes
schema_nameNo

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

A3.8/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations provided, so description carries the burden. It discloses OR logic, scope, and performance implications. However, it does not explicitly state that the operation is read-only or describe pagination behavior for limit/offset.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two sentences, each essential and front-loaded. No wasted words, clear and efficient.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

With an output schema present, the description does not need to explain return values. However, it omits details on limit and offset, and lacks behavioral notes like pagination. Adequate but with significant gaps.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters2/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%. The description explains keywords (space-separated, OR logic) and schema_name (scoping), but does not mention limit and offset parameters, leaving half the parameters undocumented.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states 'Search tables by keywords' with specific verb and resource. It distinguishes from sibling tools like search_columns and search_schemas by focusing on tables and mentioning OR logic over table name and comment.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides clear guidance on when to use schema_name (scope to one schema, faster) versus omitting it (broader search). It does not explicitly contrast with alternate sibling tools but the context is clear enough.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

setup_via_dialogA

Bootstrap (or update) a Redshift connection profile from inside an MCP session.

Use when DB tools (list_schemas etc.) return {"error": "not_configured"}, or to add a new profile / re-key an existing one. Ask the user for host / port / user / dbname conversationally — these are not secret — then call this tool. The password is collected via an OS-native dialog (macOS osascript / Linux zenity) launched server-side; it never crosses the MCP wire, never appears in chat or tool args.

Outcomes (return shape):

  • {"status": "configured", ...} — profile written, password in keychain. Lazy resolve picks it up on next DB tool call; no restart needed.

  • {"status": "dialog_cancelled" | "dialog_unavailable" | "platform_unsupported" | "empty_password", ...} — profile fields saved but no password set; the message field tells the agent / user what to do next (often: run redshift-comment-mcp set-password --profile X --stdin from a terminal).

For headless environments without a GUI, prefer the CLI pair set-fields + set-password --stdin instead.

ParametersJSON Schema
NameRequiredDescriptionDefault
hostYes
portNo
userYes
dbnameYes
profileNodefault

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

A4.6/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Thoroughly explains password handling via OS dialog, never crossing MCP wire, and describes all possible outcomes. No annotations are provided, so the description carries the full burden and does so comprehensively.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Description is well-structured with clear sections and front-loaded purpose, though slightly verbose. Every sentence adds value.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given 5 parameters and an output schema, the description covers use case, outcomes, password safety, and alternatives completely. Output schema exists and description briefly explains return shapes.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 0%, but description adds context that host/port/user/dbname are conversational and not secret. However, it does not detail each parameter individually; defaults and types are only in schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

Description clearly states it bootstraps or updates a Redshift connection profile, with specific verb and resource. It distinguishes from siblings by mentioning alternative tools for headless environments.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Explicitly says when to use (when DB tools return not_configured error) and when not (prefer set-fields + set-password in headless environments).

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections. Dates show when Glama detected each change.

  1. 13 tool updatesv0.1.0
    • First observedexecute_sql
    • First observedget_all_column_comments
    • First observedget_column_comment
    • First observedget_schema_comment
    • First observedget_setup_status
    • First observedget_table_comment
    • First observedlist_columns
    • First observedlist_schemas
    • First observedlist_tables
    • First observedsearch_columns
    • First observedsearch_schemas
    • First observedsearch_tables
    • First observedsetup_via_dialog

TDQS

A3.7/5.0
Disambiguation5/5

All 13 tools have clearly distinct purposes: getters target specific objects (schema, table, column, all columns), listers enumerate different entities, searchers operate at different scopes, execute_sql runs read-only SQL, and setup tools handle configuration. No overlapping functionality.

Naming Consistency5/5

All tool names follow a consistent verb_noun pattern in snake_case (e.g., get_column_comment, list_schemas, search_tables, setup_via_dialog). The convention is uniform across the entire set.

Tool Count5/5

With 13 tools, the count is well within the ideal 3–15 range for a focused MCP server. Each tool contributes to the server's purpose of exploring and retrieving Redshift metadata and comments.

Completeness3/5

The read side is thorough: tools cover getting comments at multiple granularities, listing, searching, and executing SQL. However, the server lacks any tools for creating, updating, or deleting comments, which is a notable gap for a comment-focused service. The setup tools are peripheral to the core domain.

Maintenance

ActivityStale
ResponsivenessSyncing

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Connectors

Related MCP Servers

  • A
    license
    B
    quality
    D
    maintenance
    A Model Context Protocol server that enables AI assistants to interact with Amazon Redshift databases, allowing for schema exploration, query execution, and statistics collection.
    3
    2
    Apache 2.0
  • A
    license
    C
    quality
    D
    maintenance
    A read-only MCP server that enables users to query Databricks SQL, browse metadata, and monitor Delta Lake tables. It also supports tracking Databricks Jobs, DLT Pipelines, and cluster metrics through natural language interfaces.
    25
    4
    MIT

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/kouko/redshift-comment-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server