Snowflake MCP server for your AI

Create a table from a column list.

Drop a table.

Get one table with its columns, types, constraints, comment, rows and bytes.

List dynamic tables in a schema with refresh state and target lag.

List the tables in a schema with row counts, size and owner.

Refresh a dynamic table now.

What a role is allowed to do: its privileges on objects, and roles granted to it.

List the account's roles, with who owns them and how many users and roles hold them.

Ask a question in plain language about data described by a semantic view or semantic model.

Run a prompt on an AI model hosted in Snowflake, so the data stays in the account.

List the Cortex Agents in a schema.

List the Cortex Search services in a schema.

Search a Cortex Search service: text search with meaning, over documents someone indexed.

Ask a Cortex Agent something and get its answer.

Call a stored procedure.

Run a task once now, outside its schedule.

Get one task: its schedule, the SQL it runs, its warehouse and state.

List stored procedures in a schema, with their argument types.

List scheduled tasks in a schema, with state and schedule.

Turn a task's schedule on.

Turn a task's schedule off.

List the files in a stage.

List the stages (file storage for loading and unloading) in a schema.

Get one database: owner, comment, retention time, kind and options.

List the databases this role can see, with owner, comment and retention.

Get one warehouse: size, state, clusters, auto-suspend and owner.

List the warehouses this role can see, with size, state (STARTED or SUSPENDED) and auto-suspend.

Start a suspended warehouse.

Stop a warehouse so it stops using credits.

Get one schema: owner, comment, managed access and retention time.

List the tables and views of a schema in one answer, with rows, size and comments.

List the schemas in a database.

Stop a running statement by its handle.

Run SQL that changes things: INSERT, UPDATE, DELETE, MERGE, CREATE, ALTER, DROP, GRANT, COPY, CALL, and so on.

Start here when you do not know the account.

Read a statement by handle: whether it finished, and its rows from any row number.

Check a statement by its handle, or read one partition of its results.

Run one SQL statement that only reads and get the rows back as objects, with dates and numbers decoded.

Get one view with its columns and the SQL it runs.

List the views in a schema.

Clone dynamic table.

Clone a snowflake managed iceberg table.

Create a new sequence by cloning from the specified resource.

Clone table.

Converts an Apache Iceberg™ table that uses an external Iceberg catalog into a table that uses Snowflake as the catalog.

Create a dynamic table.

Create an event table.

Create a snowflake managed iceberg table (clone and undrop are separate subresources).

Create a snowflake managed iceberg table as select.

Create an unmanaged iceberg table from AWS Glue catalog.

Create an unmanaged iceberg table from Delta.

Create an unmanaged iceberg table from Iceberg files.

Create an unmanaged iceberg table from Iceberg REST.

Create iceberg table like.

Create a (or alter an existing) table.

Create a sequence.

Create a table using the result of the specified select query.

Create a table like this existing one.

Create a table using the templates specified in staged files.

Delete a dynamic table.

Delete an event table.

Drop iceberg table.

Delete a sequence.

Fetch a dynamic table.

Get the tag assignments for a dynamic table.

Fetch an event table.

Get the tag assignments for an event table.

Describe iceberg table.

Get the tag assignments for an Iceberg table.

Fetch a sequence.

Get the tag assignments for a table.

List event tables.

List iceberg tables.

List sequences.

Refreshes the metadata for an Apache Iceberg table that uses an external Iceberg catalog.

Rename the event table.

Rename a sequence with a new identifier.

Resume refreshes on the dynamic table.

Resume recluster of a dynamic table.

Resume recluster of an iceberg table.

Resume recluster of a table.

Set tags on a dynamic table.

Set tags on an event table.

Set tags on an Iceberg table.

Set tags on a table.

Suspend refreshes on the dynamic table.

Suspend recluster of a dynamic table.

Suspend recluster of an iceberg table.

Suspend recluster of a table.

Swap with another dynamic table.

Swap with another table.

Undrop a dynamic table.

Undrop iceberg table.

Undrop a table.

Unset tags from a dynamic table.

Unset tags from an event table.

Unset tags from an Iceberg table.

Unset tags from a table.

Create a new database role by cloning from the specified resource.

Create a database role.

Create a (or alter an existing) user.

Create a role.

Create an user.

Delete a database role.

Delete a role.

Delete an user.

Get the tag assignments for a database role.

Get the tag assignments for a role.

Fetch information about an user.

Get the tag assignments for an user.

Grant future privileges to the role.

Grant privileges to the role.

Grant future privileges to the role.

Grant privileges to the role.

Grant a role to the user.

List all future grants to the role.

List all grants to the role.

List database roles.

List all future grants to the role.

List all grants of the role.

List all grants on the role.

List all grants to the user.

List the account's users.

Revoke future grants from the role.

Revoke grants from the role.

Revoke future grants from the role.

Revoke grants from the role.

Revoke grants from the user.

SCIM: create a group.

SCIM: create an user.

SCIM: delete a group.

SCIM: delete an user.

SCIM: get one group by SCIM id.

SCIM: get one user by SCIM id.

SCIM: list groups, which are roles in Snowflake.

SCIM: list users.

SCIM: rename a group or change its members.

SCIM: change some of an user's attributes.

SCIM: replace an user.

Set tags on a database role.

Set tags on a role.

Set tags on an user.

Unset tags from a database role.

Unset tags from a role.

Unset tags from an user.

Cancel a background agent run.

Rapidly generate a semantic model given source material.

Generate filters, facts, and metrics suggestions for a semantic model.

Retrieve relevant table information from input data for semantic model generation.

Generate VQ suggestions for a semantic model.

Perform LLM text completion inference using Cortex Messages API format.

Turn text into embeddings with a model hosted in Snowflake.

Perform LLM text completion inference using Cortex Chat Completions API format.

Create a Cortex Agent in a schema.

Start a conversation thread for Cortex Agents.

Create a cortex search service.

Delete a Cortex Agent.

Delete a thread and all its messages.

Delete a cortex search service.

Get a Cortex Agent's configuration.

Read the events of a background agent run, collapsed into one answer.

Read a thread and its messages, newest first.

Get the status and state of a specified agentic optimization run.

Fetch a cortex search service.

List your Cortex Agent threads.

List all agentic optimization runs for a given base model.

List the AI models this account may use with Cortex, which depends on its region and account settings.

Resume the cortex search service.

Run a Cortex Agent described in the request, without an agent object.

Record feedback on a Cortex Agent's answer.

Send an user feedback of Cortex Analyst response

Send user feedback for a Cortex Search result

Suggest from a Cortex Search Service.

Suspend a cortex search service.

Change a Cortex Agent's configuration.

Rename a thread.

Creates a compute pool.

Creates an image repository in the specified database and schema.

Create a (or alter an existing) compute pool.

Create a (or alter an existing) service.

Create a service.

Deletes a compute pool.

Deletes an image repository.

Delete a service.

Execute a job service.

Fetches a compute pool.

Get the tag assignments for a compute pool.

Fetches an image repository.

Get the tag assignments for an image repository.

Fetch a service.

Fetch the logs for a given service.

Lists available compute pool instance families.

Lists compute pools.

Lists image repositories.

List images in the image repository.

List all the containers of the service

List the endpoints in a service.

List all the instances of the service

List all the grants of the service role

List all the grants given to the service role

List all the service roles of the service

List services.

Resumes a suspended compute pool.

Resume a service.

Set tags on a compute pool.

Set tags on an image repository.

Stops all services on the compute pool.

Suspends an active compute pool.

Suspend a service.

Unset tags from a compute pool.

Unset tags from an image repository.

Create a new alert by cloning from the specified resource.

Clone a stream.

Create an alert.

Create an artifact repository.

Create a service function.

Create or update an artifact repository.

Create a (or alter an existing) task.

Create a procedure.

Create a stream.

Create a task.

Create a UDF.

Delete an alert.

Delete an artifact repository.

Delete a service function.

Delete a procedure.

Delete a stream.

Delete a task.

Delete a UDF.

Execute an alert.

Execute a service function.

Execute a UDF.

Fetch an alert.

Get the tag assignments for an alert.

Fetch an artifact repository.

Fetch a service function.

Get the tag assignments for a service function.

Fetch a procedure.

Get the tag assignments for a procedure.

Fetch a stream.

Get the tag assignments for a stream.

Get the tag assignments for the task.

Fetch a UDF.

Get the tag assignments for an user-defined function.

List alerts.

List artifact repositories.

List service functions in a schema.

List streams (change tracking on tables) in a schema.

Get the graph runs that are completed for the task.

Get the graph runs that are executing or scheduled for the task for the next 8 days.

Fetch the dependent tasks of a task.

List the SQL, Python, Java and other functions in a schema.

Changes the name of an artifact repository.

Rename a UDF.

Set tags on an alert.

Set tags on a service function.

Set tags on a procedure.

Set tags on a stream.

Set tags on an existing task.

Set tags on an user-defined function.

Unset tags from an alert.

Unset tags from a service function.

Unset tags from a procedure.

Unset tags from a stream.

Unset tags from an existing task.

Unset tags from an user-defined function.

Abort live version.

Adds a LIVE version to the notebook.

Add live version.

Add version from Git.

Add version from source.

Commits the LIVE version of the notebook.

Commit live version.

Create a notebook.

Create a Streamlit.

Delete a notebook.

Delete a Streamlit.

Run a notebook.

Fetch a notebook.

Get the tag assignments for a notebook.

Fetch a Streamlit.

Get the tag assignments for a Streamlit.

List the notebooks in a schema.

List Streamlits.

Pull from Git.

Push to Git.

Changes the name of the notebook to new name.

Rename a Streamlit.

Set tags on a notebook.

Set tags on a Streamlit.

Undrop a Streamlit.

Unset tags from a notebook.

Unset tags from a Streamlit.

Create a network policy.

Create a network rule.

Create a password policy.

Create a secret.

Delete a network policy.

Delete a network rule.

Delete a password policy.

Delete a secret.

Fetch a network policy.

Get the tag assignments for a network policy.

Fetch a network rule.

Fetch a password policy.

Get the tag assignments for a password policy.

Fetch a secret.

List network policies.

List network rules.

List password policies.

List secrets.

Rename a password policy with a new identifier.

Set tags on a network policy.

Set tags on a password policy.

Unset tags from a network policy.

Unset tags from a password policy.

Create an API integration.

Create a catalog integration.

Create an external volume.

Create a notification integration.

Create an (or alter an existing) API integration.

Create a pipe.

Create a stage.

Delete an API integration.

Delete a catalog integration.

Delete an external volume.

Delete a notification integration.

Delete a pipe.

Delete a stage.

Fetch an API integration.

Get the tag assignments for an API integration.

Fetch a catalog integration.

Get the tag assignments for a catalog integration.

Fetch an external volume.

Fetch a notification integration.

Get the tag assignments for a notification integration.

Fetch a pipe.

What a Snowpipe loaded recently: events kept up to 10 minutes, the latest 10,000.

A Snowpipe's load history over a time range, from the last 14 days, at most 10,000 items.

Get the tag assignments for a pipe.

Fetch a stage.

Make a temporary link to download a file from a stage.

Tell a Snowpipe which staged files to load.

List API integrations.

List catalog integrations.

List external volumes.

List notification integrations.

List Snowpipes in a schema.

Refresh the pipe.

Set tags on an API integration.

Set tags on a catalog integration.

Set tags on a notification integration.

Set tags on a pipe.

Undrop an external volume.

Unset tags from an API integration.

Unset tags from a catalog integration.

Unset tags from a notification integration.

Unset tags from a pipe.

Clone a database.

Create a database.

Create a database from a share.

Create a new, or alters an existing, database.

Delete a database.

Disable database failover.

Disable database replication.

Enable database failover.

Enable database replication.

Get the tag assignments for a database.

Set a primary database.

Refresh database replications.

Set tags on a database.

Undrop a database.

Unset tags from a database.

Stop every statement running or queued on a warehouse, including other people's.

Create a warehouse or change one to match this definition, such as its size or auto_suspend.

Create or replace warehouse.

Drop warehouse.

disable adaptive warehouse.

enable adaptive warehouse.

Get the tag assignments for a warehouse.

Update and rename warehouse.

Set tags on a warehouse.

Unset tags from a warehouse.

Clone a schema.

Create a new, or alters an existing, schema.

Create a schema.

Delete a schema.

Get the tag assignments for a schema.

Set tags on a schema.

Undrop a schema.

Unset tags from a schema.

Add a version to a code bundle.

Cancel a code bundle execution.

Create a code bundle.

Delete a code bundle.

Execute a code bundle.

Fetch a code bundle.

Get the status of a code bundle execution.

List code bundle executions.

List code bundles.

Execute a code bundle.

Run SQL through Snowflake's SQL API, with every option it has.

Read a REST API result by the opaque id Snowflake returned for a slow request, or the next page of a long list.

Create an account.

Create a managed accounts.

Create or update a tag.

Create a tag.

Create a view.

Delete an account.

Delete a managed account.

Delete a tag.

Delete a view.

Fetch a tag.

Get the tag assignments for a view.

List accounts.

List managed accounts.

List tags.

Rename a tag with a new identifier.

Set tags on a view.

Restore an account.

Undrop a tag.

Unset tags from a view.