redshift-mcp-server: Add UDF discovery in Redshift MCP

[grayhemp]

Describe the feature

The tool(s) should be able to answer the following questions:

• What are my UDFs, their properties (type - Python/Lambda/SQL, volatility, etc), and code?
• Can I convert a UDF to plain SQL?
• What is the code to convert a Python UDF to a Lambda UDF? (requires AWS Lambda MCP installed)
• What is the CFN template to deploy that Lambda code?

Use Case

• General UDF understanding to use in queries
• UDF to plain SQL conversion
• Python to Lambda UDF conversion.

Proposed Solution

No response

Other Information

No response

Acknowledgements

• I may be able to implement this feature request
• This feature might incur a breaking change

[AryanBagade]

@grayhemp ! If it's open to external contributors, I'd love to create a PR.

[grayhemp]

@AryanBagade Sure, that would be great. Thank you in advance.