Schema | Redshift MCP Server

Redshift MCP Server

Describes the environment variables required to run the server.

Name	Required	Description	Default
`REDSHIFT_HOST`	Yes	The Redshift host address
`REDSHIFT_PORT`	No	The Redshift port number	5432
`REDSHIFT_USER`	Yes	The Redshift username
`REDSHIFT_DATABASE`	Yes	The Redshift database name
`REDSHIFT_PASSWORD`	Yes	The Redshift password

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Server capabilities have not been inspected yet.

Functions exposed to the LLM to take actions

Name	Description
redshift_queryB	`Execute a SQL query on Redshift and return results as JSON. Args: sql: The SQL query to execute Returns: JSON string of the query results or error message`
redshift_list_tablesA	`List all tables in a specific schema. Args: schema: The schema name (default: "public") Returns: JSON list of table names`
redshift_describe_tableC	`Get the column definitions for a table. Args: table_name: Name of the table schema: Schema name (default: "public") Returns: JSON description of columns`
redshift_get_sample_dataB	`Get sample rows from a table. Args: table_name: Name of the table limit: Number of rows to return (default: 5) schema: Schema name (default: "public") Returns: JSON sample data`
redshift_connection_statusC	`Check the Redshift connection status. Returns: Connection status information`

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
`get_tables_resource`	List of available tables in the public schema.
`get_status_resource`	Current Redshift connection status.

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

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

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