@Hubert-Dudek 
To communicate with agent I need MCP protocol, so only SQL warehouse is not enough I assume. It has to be wrapped e.g. in FastMCP (to define tools resources etc.) and Fast API (if endpoints are required) and then deployed as custom MCP server. This is what I have done currently - MCP server is deployed in AWS and talking with databricks via REST API (warehouse is also used to get table data). However, I would like to improve latency and that is why I am asking about MCP directly in databricks.

Nevertheless, thank you all! I believe I have very good overview right now with all responses.