The server uses the Snowflake API to enable bidirectional SQL access.

Discovering Schemas

The CData MCP Server for Snowflake automatically retrieves the structure of your data from Snowflake, including warehouses, databases, and schemas. Specifying a database or schema is optional, but doing so limits the available tables and views to only those within the selected database or schema.

Stored Procedures

Stored Procedures are function-like interfaces to Snowflake. They are used for OAuth authentication.