redshift-comment-mcp
The redshift-comment-mcp server is a read-only MCP server for Amazon Redshift focused on guided data discovery, with database comments treated as authoritative descriptors. Key capabilities:
Schema, Table & Column Discovery
List schemas, tables, and columns with optional inline comments
Paginated results across all listing tools
Search
Keyword search (OR logic) across schema/table/column names and comments
Searches can be scoped to a specific schema or run cluster-wide
Results ranked by hit count
Comment Retrieval
Fetch authoritative comments for schemas, tables, specific columns, or all columns in a table at once
Query Execution
Run
SELECT/WITHqueries against Redshift with paginated resultsDDL/DML is blocked at the parser level — read-only by construction
Connection Setup & Management
Bootstrap or update connection profiles via
setup_via_dialogusing an OS-native dialog — passwords never cross the MCP wire or appear in chatCheck profile configuration status with
get_setup_statuswithout connecting to the database or exposing secretsSupports multiple named profiles for multi-cluster environments
General
Comments are surfaced aggressively to clarify ambiguous table/column names
Defense-in-depth read-only enforcement (parser-level blocking + recommended DB-level read-only grants)
Provides read-only access to Amazon Redshift, with tools for listing schemas, tables, and columns, searching across metadata, executing SELECT/WITH queries, and skills for column profiling, schema exploration, lineage reconstruction from query history, and keyword-based column/table search.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@redshift-comment-mcpProfile the column 'status' in table dbt_marts.fct_orders"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
redshift-comment-mcp
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_sqlrejects 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 |
|
Search (hit-count ranked) |
|
Comment retrieval |
|
Query |
|
Setup (since v0.7.0) |
|
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 |
Conversational walk-through to configure a connection profile. | v0.2.0 | |
Switch the active profile (no host / user / password re-entry); single-profile users get a friendly bow-out. | v0.4.0 | |
Profile a column: cardinality / top-N / null rate / min-max / existing comment, one round. | v0.3.0 | |
Three-step interactive wizard (schema → table → column) — pick by reading comments. | v0.3.0 | |
Mine | v0.3.0 | |
Cross-table column search by keyword across one or all schemas via schema-wide MCP call. | v0.4.0 | |
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-mcpWhen 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 tosettings.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-setupis 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..mcpbDesktop 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 editingclaude_desktop_config.jsonby hand.
Scenario | How |
Claude Code (recommended) |
|
Claude Desktop (one-click) | Download the |
Claude Desktop / generic MCP client (manual) |
|
Local development |
|
Multi-cluster |
|
.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-profilesThe 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 --stdinStep 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-mcpthen 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 + marketplaceThe two READMEs to read next:
skills/README.md— overview of all 5 skillssrc/redshift_comment_mcp/README.md— server internals, module map, charter constraints
Data layout at runtime
Path | Contents | Permissions |
| Non-secret profile fields |
|
| One-line pointer to the active profile name. Absent ↔ server uses |
|
OS keychain ( | Passwords | OS-managed |
Recommended DB GRANTs (defense-in-depth)
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 / superuserFor /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_commentsdefaults to False onlist_tables/list_columns(onlylist_schemasdefaults True since schema count is small) — agent must opt in to comment-loaded responses.MAX_COMMENT_LEN=1000caps each comment in multi-item responses (withcomment_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 + wheelThe 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
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 toolsexecute_sqlA
Execute a read-only SQL query (SELECT/WITH only). Result rows are paginated via limit/offset.
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| offset | No | ||
| sql_statement | Yes |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
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.
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.
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.
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.
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.
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.
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| offset | No | ||
| table_name | Yes | ||
| schema_name | Yes |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
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.
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.
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.
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.
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.
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.
| Name | Required | Description | Default |
|---|---|---|---|
| table_name | Yes | ||
| column_name | Yes | ||
| schema_name | Yes |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
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.
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.
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.
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.
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.
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.
| Name | Required | Description | Default |
|---|---|---|---|
| schema_name | Yes |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
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.
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.
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.
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.
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.
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 namesource—"inline"when the server was launched in legacy inline mode (--host/--user/--dbname+REDSHIFT_ PASSWORDenv, 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_passwordhas_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/--passwordin inline mode). NEVER returns the password itselfhost/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
| Name | Required | Description | Default |
|---|---|---|---|
| profile | No | default |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
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.
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.
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.
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.
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.
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.
| Name | Required | Description | Default |
|---|---|---|---|
| table_name | Yes | ||
| schema_name | Yes |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
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.
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.
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.
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.
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.
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.
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| offset | No | ||
| table_name | Yes | ||
| schema_name | Yes | ||
| include_comments | No | ||
| include_parent_comments | No |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
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.
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.
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.
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.
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.
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).
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| offset | No | ||
| include_comments | No |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
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.
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.
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.
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.
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.
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.
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| offset | No | ||
| schema_name | Yes | ||
| include_comments | No | ||
| include_parent_comments | No |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
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.
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.
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.
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.
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.
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).
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| offset | No | ||
| keywords | Yes | ||
| table_name | No | ||
| schema_name | Yes |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
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.
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.
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.
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.
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.
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.
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| offset | No | ||
| keywords | Yes |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
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.
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.
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.
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.
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.
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).
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| offset | No | ||
| keywords | Yes | ||
| schema_name | No |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
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.
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.
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.
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.
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.
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: runredshift-comment-mcp set-password --profile X --stdinfrom a terminal).
For headless environments without a GUI, prefer the CLI pair
set-fields + set-password --stdin instead.
| Name | Required | Description | Default |
|---|---|---|---|
| host | Yes | ||
| port | No | ||
| user | Yes | ||
| dbname | Yes | ||
| profile | No | default |
Output Schema
| Name | Required | Description |
|---|---|---|
No output parameters | ||
TDQS
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.
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.
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.
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.
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.
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.
13 tool updates
v0.1.0- First observed
execute_sql - First observed
get_all_column_comments - First observed
get_column_comment - First observed
get_schema_comment - First observed
get_setup_status - First observed
get_table_comment - First observed
list_columns - First observed
list_schemas - First observed
list_tables - First observed
search_columns - First observed
search_schemas - First observed
search_tables - First observed
setup_via_dialog
TDQS
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.
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.
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.
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
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
Query your org's data in natural language — read-only MCP access to SQL, NoSQL, files & warehouses.
Query your warehouse or a CSV with Claude/ChatGPT over MCP, governed by table-level ACL + audit.
An MCP server that provides read access to your cloud storage providers, bank accounts and more.
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
Related MCP Servers
- AlicenseBqualityDmaintenanceA Model Context Protocol server that enables AI assistants to interact with Amazon Redshift databases, allowing for schema exploration, query execution, and statistics collection.32Apache 2.0
- AlicenseAqualityCmaintenance🤖 Enable AI assistants (Claude, Cursor) to monitor, diagnose, and query Amazon Redshift using this MCP server and the AWS Data API.76MIT
- AlicenseCqualityDmaintenanceA 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.254MIT
- AlicenseAqualityDmaintenanceA read-only MCP server for exploring and analyzing a Secoda data catalog, enabling AI chat, semantic search, glossary browsing, and data lineage tracing.12Apache 2.0
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
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