redshift_connection_status
Check the connection status of Amazon Redshift databases to verify connectivity and ensure database operations can proceed.
Instructions
Check the Redshift connection status.
Returns:
Connection status information
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Implementation Reference
- redshift_mcp_server.py:133-154 (handler)The handler function for the 'redshift_connection_status' tool. It is decorated with @mcp.tool() for registration and implements the logic to check Redshift connection status, returning JSON with status details.@mcp.tool() def redshift_connection_status() -> str: """ Check the Redshift connection status. Returns: Connection status information """ try: with get_connection() as conn: return json.dumps({ "status": "connected", "host": REDSHIFT_HOST, "port": REDSHIFT_PORT, "database": REDSHIFT_DATABASE }, indent=2) except Exception as e: return json.dumps({ "status": "disconnected", "error": str(e) }, indent=2)