Integration

Snowflake integration

Cloud data platform for data warehousing, data lakes, and analytics. Execute SQL queries, manage databases, warehouses, schemas, and tables, and process large-scale data. Essential for data analytics, ETL pipelines, and business intelligence.

Connect Snowflake How integrations work

Ask it in chat

Say what should happen.
The workflow builds itself.

When this happens, do that in Snowflake.Built from the 23 Snowflake tools below, on the connection you add once.

Common Snowflake use cases

resource removal
warehouse cleanup
ETL operations
cost saving
data loading
data queries
data analysis
table cleanup
schema cleanup
table discovery

What you can do with Snowflake

Each of these is one operation on one endpoint, available both as a workflow step and as a tool an AI agent can call on its own. Nothing bundles several operations into one action, so what a run did stays readable afterwards.

Most endpoints run on the free plan. A few, mainly the ones that publish on your behalf, need a paid plan.

Warehouse, 8 operations

abort_warehouse_queriesAbort warehouse queriesPOSTAborts all queries on a Snowflake warehouse.
alter_warehouseAlter warehousePUTAlters a Snowflake warehouse configuration.
create_warehouseCreate warehousePOSTCreates a new Snowflake warehouse.
delete_warehouseDelete warehouseDELETEDrops a Snowflake warehouse.
get_warehouseGet warehouseGETGets details of a specific Snowflake warehouse.
list_warehousesList warehousesGETLists all compute warehouses in Snowflake.
resume_warehouseResume warehousePOSTResumes a suspended Snowflake warehouse.
suspend_warehouseSuspend warehousePOSTSuspends a running Snowflake warehouse.

Statement, 5 operations

cancel_statementCancel statementPOSTCancels a running Snowflake query.
get_statement_statusGet statement statusGETGets the status and results of a Snowflake query.
insert_dataInsert dataPOSTInserts data into a Snowflake table.
select_dataSelect dataPOSTExecutes a SELECT query in Snowflake.
submit_statementSubmit statementPOSTExecutes a SQL statement in Snowflake.

Database, 4 operations

create_databaseCreate databasePOSTCreates a new Snowflake database.
delete_databaseDelete databaseDELETEDrops a Snowflake database.
get_databaseGet databaseGETGets details of a specific Snowflake database.
list_databasesList databasesGETLists all databases in Snowflake account.

Schema, 3 operations

create_schemaCreate schemaPOSTCreates a new schema in a Snowflake database.
delete_schemaDelete schemaDELETEDrops a schema from a Snowflake database.
list_schemasList schemasGETLists all schemas in a Snowflake database.

Table, 3 operations

delete_tableDelete tableDELETEDrops a table from a Snowflake schema.
get_tableGet tableGETGets details of a specific Snowflake table.
list_tablesList tablesGETLists all tables in a Snowflake schema.

Use Snowflake from Claude Code, Cursor or Codex

Connect Snowflake in LiveContext, create an API key in Settings, then add the LiveContext MCP server to your client. Its Snowflake operations become tools the client can call, next to every other integration you connected.

Claude Code

claude mcp add --transport http livecontext https://livecontext.ai/mcp --header "X-API-Key: YOUR_API_KEY"

Codex (~/.codex/config.toml)

[mcp_servers.livecontext]
url = "https://livecontext.ai/mcp"

[mcp_servers.livecontext.http_headers]
"X-API-Key" = "YOUR_API_KEY"

Cursor, Claude Desktop and other JSON configs

{
  "mcpServers": {
    "livecontext": {
      "type": "http",
      "url": "https://livecontext.ai/mcp",
      "headers": {
        "X-API-Key": "YOUR_API_KEY"
      }
    }
  }
}

Set up the MCP server step by step

How to connect Snowflake

Create your workspace
Sign up free. Nothing to install.
Connect Snowflake once
Add your Snowflake connection in Settings. Every tool from this integration reuses it, and secrets are encrypted at rest and visible only to you.
Describe the job in chat
The workflow builds itself in front of you and picks the endpoints it needs. Drag the steps yourself on the canvas whenever you would rather be explicit.

Snowflake integration FAQ

What can you do with the Snowflake integration?

LiveContext exposes 23 operations on Snowflake, covering warehouse, statement, database and schema. Common uses include resource removal, warehouse cleanup and ETL operations.