Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| REDSHIFT_HOST | Yes | The Redshift host address | |
| REDSHIFT_PORT | Yes | The Redshift port number | 5432 |
| REDSHIFT_USER | Yes | The Redshift user | |
| REDSHIFT_DATABASE | Yes | The Redshift database name | |
| REDSHIFT_PASSWORD | Yes | The Redshift password |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| redshift_query | 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_tables | List all tables in a specific schema.
Args:
schema: The schema name (default: "public")
Returns:
JSON list of table names |
| redshift_describe_table | 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_data | 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_status | Check the Redshift connection status.
Returns:
Connection status information |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
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. |