Snowflake

Run SQL statements and manage warehouses in Snowflake.

Data and search infra

How an agent reaches it

MCPREST APICLI

API key

Generate a programmatic access token, or a key-pair JWT, for your Snowflake user.
The account identifier forms the host: {account}.snowflakecomputing.com.

run SQL	POST /statements
poll a statement	GET /statements/{handle}

The X-Snowflake-Authorization-Token-Type header must say KEYPAIR_JWT or OAUTH; a bare bearer without it 401s.
Statements can execute asynchronously and return a statementHandle to poll.
Warehouse, database and schema must be set in the request or the statement fails with an unhelpful error.

Run SQL statements and manage warehouses in Snowflake.

Data and search infra

MCPREST APICLI

API key

Generate a programmatic access token, or a key-pair JWT, for your Snowflake user.
The account identifier forms the host: {account}.snowflakecomputing.com.

run SQL	POST /statements
poll a statement	GET /statements/{handle}

The X-Snowflake-Authorization-Token-Type header must say KEYPAIR_JWT or OAUTH; a bare bearer without it 401s.
Statements can execute asynchronously and return a statementHandle to poll.
Warehouse, database and schema must be set in the request or the statement fails with an unhelpful error.