Skip to main content
Glama
manish6007

Combined MCP Server

by manish6007

Combined MCP Server

A production-grade MCP (Model Context Protocol) server combining Redshift query capabilities and Knowledgebase vector store features.

Features

Redshift Tools

  • run_query - Execute SQL with IAM authentication via get_cluster_credentials

  • list_schemas - List database schemas

  • list_tables - List tables in a schema

  • describe_table - Get table structure

Large results (>100 rows) are automatically stored in S3 with 20 sample rows returned.

Knowledgebase Tools

  • build_vectorstore - Build vector store from S3 markdown files

  • query_vectorstore - Hybrid search (semantic + keyword) with RRF reranking

  • get_vectorstore_status - Check build status and cache stats

Related MCP server: Redshift MCP Server

Quick Start

Local Development

  1. Install uv (if not already installed):

    curl -LsSf https://astral.sh/uv/install.sh | sh
    # Or on Windows: powershell -c "irm https://astral.sh/uv/install.ps1 | iex"
  2. Start infrastructure:

    docker-compose up -d postgres localstack
  3. Install dependencies:

    uv pip install -e ".[dev]"
  4. Configure environment:

    cp .env.example .env.local
    # Edit .env.local with your settings
  5. Run the server:

    # With MCP Inspector
    mcp dev src/combined_mcp_server/main.py
    
    # Or directly
    python -m combined_mcp_server.main

ECS Deployment

# Build container
docker build -t combined-mcp-server .

# Run with health checks
docker run -p 8080:8080 --env-file .env combined-mcp-server

Health endpoints:

  • GET /health - Liveness probe

  • GET /ready - Readiness probe

  • GET /status - Detailed status

Configuration

See .env.example for all configuration options. Key settings:

Variable

Description

REDSHIFT_CLUSTER_ID

Redshift cluster identifier

POSTGRES_SECRET_NAME

Secrets Manager secret for pgvector DB

KNOWLEDGEBASE_S3_BUCKET

S3 bucket with markdown files

BEDROCK_EMBEDDING_MODEL

Titan embedding model ID

Architecture

┌─────────────────────────────────────────────────────┐
│                  Combined MCP Server                 │
├─────────────────────┬───────────────────────────────┤
│   Redshift Tools    │     Knowledgebase Tools       │
│  ─────────────────  │  ───────────────────────────  │
│  • run_query        │  • build_vectorstore          │
│  • list_schemas     │  • query_vectorstore          │
│  • list_tables      │  • get_vectorstore_status     │
│  • describe_table   │                               │
├─────────────────────┴───────────────────────────────┤
│                    Core Services                     │
│  AWS (Secrets Manager, S3, Bedrock, Redshift)       │
│  PostgreSQL + pgvector                              │
└─────────────────────────────────────────────────────┘

Testing

# Unit tests
pytest tests/ -v

# With coverage
pytest tests/ -v --cov=combined_mcp_server

# Integration tests (requires Docker)
docker-compose up -d
pytest tests/ -v -m integration

License

MIT

Available Tools

7 tools
build_vectorstoreA
Build or rebuild the knowledge base vector store from S3 markdown files.

Downloads all markdown files from the configured S3 location, processes them 
into chunks, generates embeddings using AWS Bedrock Titan, and stores in PostgreSQL.
ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

A4.2/5.0
Behavior3/5

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

With no annotations provided, the description carries full burden. It discloses key behavioral traits: it's a complex multi-step process involving downloading, processing, embedding generation, and storage. However, it doesn't mention potential side effects (e.g., overwriting existing data), performance characteristics (time/rate limits), authentication requirements, or error handling - significant gaps for a tool with no annotation coverage.

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 efficiently structured in two sentences: the first states the core purpose, the second elaborates the multi-step process. Every phrase adds value - 'from S3 markdown files,' 'configured S3 location,' and the specific technologies used (AWS Bedrock Titan, PostgreSQL) provide essential context without redundancy.

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 this is a complex data processing tool with no annotations but with an output schema, the description provides good coverage of the operation's purpose and steps. It explains the source (S3 markdown), processing (chunking), embedding generation (AWS Bedrock Titan), and storage (PostgreSQL). The output schema will handle return values, so the description appropriately focuses on the transformation process rather than output details.

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?

The tool has 0 parameters with 100% schema description coverage, so the schema already fully documents the parameter situation. The description appropriately doesn't discuss parameters, instead focusing on what the tool does. A baseline of 4 is appropriate for zero-parameter tools where the description doesn't need to compensate for schema gaps.

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 specific action ('build or rebuild') and target resource ('knowledge base vector store'), with detailed explanation of the multi-step process. It distinguishes this tool from siblings like 'get_vectorstore_status' (monitoring) and 'query_vectorstore' (querying) by emphasizing creation/regeneration from source files.

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 usage context through phrases like 'from S3 markdown files' and 'configured S3 location,' suggesting this is for initial setup or refresh operations. However, it doesn't explicitly state when NOT to use this tool or name specific alternatives among siblings, though the distinction from query/monitoring tools is clear from their names.

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

describe_tableB
Get detailed information about a Redshift table including columns and data types.

Args:
    schema: Schema name
    table: Table name
    db_user: Database user for authentication
    db_group: Optional database group for permissions
ParametersJSON Schema
NameRequiredDescriptionDefault
schemaYes
tableYes
db_userYes
db_groupNo

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

B3.4/5.0
Behavior2/5

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

No annotations are provided, so the description carries the full burden of behavioral disclosure. While it mentions authentication via 'db_user' and permissions via 'db_group', it doesn't describe what 'detailed information' includes beyond columns and data types, whether this is a read-only operation, potential rate limits, or error conditions. The description is minimal and lacks crucial behavioral context for a tool with authentication parameters.

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 appropriately sized and front-loaded with the core purpose in the first sentence. The Args section is structured but could be more integrated; however, every sentence adds value (e.g., clarifying parameter roles). Minor room for improvement in flow, but overall efficient with minimal waste.

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 tool has an output schema (which likely covers return values), the description's minimalism is somewhat acceptable. However, for a tool with 4 parameters (including authentication) and no annotations, it should provide more behavioral context (e.g., read-only nature, error handling). The description is adequate but has clear gaps in usage guidelines and transparency.

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?

Schema description coverage is 0%, so the description must compensate. It adds meaningful context for all parameters: 'schema' and 'table' are clearly identified as names, 'db_user' is explained as 'for authentication', and 'db_group' as 'Optional database group for permissions'. This goes beyond the schema's basic titles, providing purpose and usage hints for each parameter.

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 specific action ('Get detailed information') and resource ('about a Redshift table including columns and data types'), distinguishing it from sibling tools like list_tables (which likely lists names only) or run_query (which executes queries). The verb+resource combination is precise and unambiguous.

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. It doesn't mention when this tool is appropriate (e.g., for metadata inspection vs. data retrieval) or differentiate it from siblings like list_tables or run_query. No explicit when/when-not statements or alternative tool references are included.

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

get_vectorstore_statusA
Get the current status of the knowledge base vector store.

Returns build status, document count, and cache statistics.
ParametersJSON Schema
NameRequiredDescriptionDefault

No parameters

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

A3.5/5.0
Behavior3/5

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

With no annotations provided, the description carries full burden. It discloses the return content (build status, document count, cache statistics) which is valuable behavioral information. However, it doesn't mention performance characteristics, error conditions, rate limits, or authentication requirements that would be helpful for a status-checking tool.

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 perfectly concise with two sentences that each earn their place. The first sentence states the purpose, the second describes return values. No wasted words, well-structured, and front-loaded with the core functionality.

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 has an output schema (which handles return value documentation), no parameters, and no annotations, the description provides adequate context. It clearly states what the tool does and what information it returns. For a simple status-checking tool with output schema support, this is reasonably complete, though could benefit from more behavioral context.

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?

The tool has 0 parameters with 100% schema description coverage, so the schema already fully documents the empty parameter set. The description appropriately doesn't discuss parameters since none exist, earning a baseline 4 for parameter semantics when no parameters need explanation.

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

Purpose4/5

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

The description clearly states the tool's purpose as 'Get the current status of the knowledge base vector store' with specific verb ('Get') and resource ('knowledge base vector store'). It distinguishes from siblings like 'build_vectorstore' (creation) and 'query_vectorstore' (querying), but doesn't explicitly contrast with all siblings like 'describe_table' or 'list_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?

No guidance is provided on when to use this tool versus alternatives. The description doesn't mention prerequisites, timing considerations, or contrast with similar tools like 'describe_table' or 'list_schemas' that might provide related metadata. Usage context is implied but not explicit.

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

list_schemasB
List all schemas in the Redshift database.

Args:
    db_user: Database user for authentication
    db_group: Optional database group for permissions
ParametersJSON Schema
NameRequiredDescriptionDefault
db_userYes
db_groupNo

Output Schema

ParametersJSON Schema
NameRequiredDescription

No output parameters

TDQS

B3.2/5.0
Behavior2/5

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

With no annotations provided, the description carries the full burden of behavioral disclosure. It implies a read-only operation by using 'List', but doesn't specify permissions needed, rate limits, pagination behavior, or what 'all schemas' entails (e.g., system vs. user schemas). This leaves significant gaps for a tool with authentication parameters.

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 efficiently structured with a clear purpose statement followed by parameter explanations. Every sentence adds value without redundancy, making it appropriately sized and 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 the tool's moderate complexity (2 parameters, authentication required) and the presence of an output schema (which handles return values), the description covers the basic purpose and parameters adequately. However, it lacks behavioral details like permissions or scope, which are important for a database listing tool with no annotations.

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?

The description adds meaningful context for both parameters: 'db_user' is explained as 'Database user for authentication' and 'db_group' as 'Optional database group for permissions'. With 0% schema description coverage, this compensates well by clarifying the purpose of each parameter beyond their names.

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

Purpose4/5

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

The description clearly states the verb 'List' and resource 'all schemas in the Redshift database', making the purpose unambiguous. However, it doesn't explicitly differentiate from sibling tools like 'list_tables' or 'describe_table', which would require a 5.

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 'list_tables' or 'describe_table'. It mentions authentication parameters but doesn't explain usage context or prerequisites beyond that.

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

list_tablesB
List all tables in a Redshift schema.

Args:
    schema: Schema name to list tables from
    db_user: Database user for authentication
    db_group: Optional database group for permissions
ParametersJSON Schema
NameRequiredDescriptionDefault
schemaYes
db_userYes
db_groupNo

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 carries the full burden of behavioral disclosure. It mentions authentication parameters ('db_user', 'db_group') but doesn't explain what permissions are needed, whether this is a read-only operation, potential rate limits, or what the output looks like. For a tool with authentication requirements and no annotations, this is a significant gap in transparency.

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 appropriately sized and front-loaded: the first sentence states the purpose clearly, followed by a concise 'Args' section listing parameters with brief explanations. Every sentence earns its place without redundancy, making it efficient and well-structured.

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 tool's moderate complexity (3 parameters, authentication needs) and the presence of an output schema (which handles return values), the description is partially complete. It covers the purpose and parameters but lacks behavioral context like permissions or usage guidelines. With no annotations, it should do more to compensate, but the output schema reduces the burden slightly.

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 adds meaning by explaining that 'schema' is the 'Schema name to list tables from', 'db_user' is for 'Database user for authentication', and 'db_group' is 'Optional database group for permissions'. This clarifies the purpose of each parameter beyond their titles in the schema, but it doesn't provide format details or constraints, keeping it at a baseline level.

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

Purpose4/5

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

The description clearly states the tool's purpose: 'List all tables in a Redshift schema.' It specifies the verb ('List') and resource ('tables in a Redshift schema'), making the function unambiguous. However, it doesn't explicitly differentiate from sibling tools like 'list_schemas' or 'describe_table', which would require a 5.

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. It doesn't mention sibling tools like 'list_schemas' (for listing schemas instead of tables) or 'describe_table' (for detailed table information), nor does it specify prerequisites or exclusions. Usage is implied by the purpose but not explicitly stated.

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

query_vectorstoreA
Search the knowledge base vector store.

Supports semantic search (vector similarity), keyword search (full-text), 
or hybrid search combining both with RRF reranking. Results are cached for performance.

Args:
    query: The search query text
    top_k: Maximum number of results to return (default: 10)
    search_type: Type of search - semantic, keyword, or hybrid (default)
ParametersJSON Schema
NameRequiredDescriptionDefault
queryYes
top_kNo
search_typeNohybrid

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?

With no annotations provided, the description carries the full burden. It discloses key behavioral traits: the tool performs searches with caching for performance and supports three search types. However, it doesn't cover important aspects like rate limits, authentication needs, error conditions, or what 'cached for performance' entails operationally.

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 efficiently structured: purpose statement first, followed by key capabilities, behavioral note about caching, and clear parameter explanations. Every sentence adds value with zero waste, making it easy to parse quickly.

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 3 parameters with no schema descriptions, an output schema exists (so return values don't need explanation), and no annotations, the description provides solid coverage of purpose, parameters, and basic behavior. It could be more complete by addressing error cases or search result format, but covers the essentials well for a search tool.

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?

With 0% schema description coverage, the description compensates well by explaining all three parameters: 'query' as search text, 'top_k' as maximum results with default, and 'search_type' as semantic/keyword/hybrid with default. It adds meaningful context beyond the bare schema, though could elaborate on parameter interactions.

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

Purpose4/5

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

The description clearly states the tool's purpose: 'Search the knowledge base vector store' with specific search methods (semantic, keyword, hybrid). It distinguishes itself from siblings like 'build_vectorstore' (creation) and 'run_query' (likely SQL queries), but doesn't explicitly contrast with other search-related tools if they exist.

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 usage through search method options (semantic, keyword, hybrid) and mentions caching for performance, but doesn't explicitly state when to use this tool versus alternatives like 'run_query' or provide clear exclusions. The guidance is functional but lacks explicit comparative context.

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

run_queryA
Execute a SQL query on Redshift.

For queries returning more than 100 rows, the full result set is stored 
in S3 and only 20 sample rows are returned.

Args:
    sql: The SQL query to execute
    db_user: Database user for authentication via get_cluster_credentials
    db_group: Optional database group for permissions
ParametersJSON Schema
NameRequiredDescriptionDefault
sqlYes
db_userYes
db_groupNo

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 and does well by disclosing critical behavioral traits: the 100-row limit for direct returns, S3 storage for larger results, and authentication requirements via get_cluster_credentials. However, it doesn't mention rate limits, timeout behavior, or error handling for malformed queries.

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 efficiently structured with a clear purpose statement followed by important behavioral information, then parameter explanations. Every sentence adds value, and the Args section is appropriately formatted without redundancy.

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 this is a database query execution tool with no annotations but with an output schema, the description provides good coverage of purpose, behavior, and parameters. However, it could better address error scenarios, performance characteristics, and how to retrieve full results from S3 when applicable.

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?

With 0% schema description coverage, the description compensates well by explaining all three parameters: sql (the query to execute), db_user (for authentication), and db_group (optional permissions). It adds meaningful context about authentication via get_cluster_credentials that isn't in 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 clearly states the specific action ('Execute a SQL query') and target resource ('on Redshift'), distinguishing it from sibling tools like query_vectorstore or describe_table. It provides precise verb+resource information that helps the agent understand this is a database query execution tool.

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 usage for SQL query execution on Redshift, but doesn't explicitly state when to use this tool versus alternatives like query_vectorstore or describe_table. There's no guidance on prerequisites, error conditions, or specific scenarios where this tool is preferred over siblings.

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.

  1. 7 tool updatesv1.0.0
    • First observedbuild_vectorstore
    • First observeddescribe_table
    • First observedget_vectorstore_status
    • First observedlist_schemas
    • First observedlist_tables
    • First observedquery_vectorstore
    • First observedrun_query

TDQS

A3.7/5.0

Scored across 7 tools

Disambiguation5/5

Each tool has a clearly distinct purpose with no overlap. The vectorstore tools (build, get_status, query) handle knowledge base operations, while the Redshift tools (list_schemas, list_tables, describe_table, run_query) handle database operations. The separation between these two domains is unambiguous.

Naming Consistency5/5

All tools follow a consistent verb_noun naming pattern. The verbs are descriptive (build, describe, get, list, query, run) and the nouns clearly indicate the target resource (vectorstore, table, schemas, tables, query). There are no deviations in naming conventions.

Tool Count4/5

With 7 tools, the count is reasonable for a combined server covering two domains. However, the vectorstore side feels slightly thin with only three tools (build, status, query), lacking operations like update or delete. The Redshift side is well-covered with four tools.

Completeness4/5

For the Redshift domain, the toolset provides comprehensive coverage (list schemas/tables, describe table, run query). For the vectorstore domain, core operations exist (build, query, status), but there are minor gaps such as updating or deleting documents from the knowledge base, which agents might need to work around.

Maintenance

ActivityStale
ResponsivenessNo issues

Related MCP Connectors

Related MCP Servers