Combined MCP Server

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

List all schemas in the Redshift database.

Args:
    db_user: Database user for authentication
    db_group: Optional database group for permissions

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

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

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.

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)

Get the current status of the knowledge base vector store.

Returns build status, document count, and cache statistics.