KosmoKrator

database

Snowflake MCP Integration for OpenAI Agents SDK

Connect Snowflake to OpenAI Agents SDK through the local KosmoKrator MCP gateway with scoped tools, credentials, and write policy.

9 functions 8 read 1 write Manual OAuth token auth
Submit Snowflake feedback View package source

Connect Snowflake to OpenAI Agents SDK

Attach KosmoKrator integration tools to OpenAI Agents SDK workflows through a local MCP gateway.

Start the KosmoKrator MCP gateway locally and point the OpenAI Agents SDK MCP tool at that process or wrapper. The gateway is local, scoped to this integration, and starts with --write=deny so OpenAI Agents can inspect read-capable tools without receiving write access by default.

Snowflake MCP Config for OpenAI Agents SDK

Use headless JSON commands for CI-style execution and MCP for agent tool discovery.

{
  "mcpServers": {
    "kosmokrator-snowflake": {
      "type": "stdio",
      "command": "kosmo",
      "args": [
        "mcp:serve",
        "--integration=snowflake",
        "--write=deny"
      ]
    }
  }
}

Run the Gateway Manually

kosmokrator mcp:serve --integration=snowflake --write=deny

Why Use KosmoKrator Here

Scoped tools

Expose only Snowflake instead of a broad multi-service tool list.

Local credentials

Reuse credentials already configured for the KosmoKrator CLI and Lua runtime.

Write policy

Start read-only, then opt into ask or allow for trusted workspaces.

Snowflake Tools Visible to OpenAI Agents

OpenAI Agents sees stable MCP tool names generated from the Snowflake integration catalog.

MCP toolSource functionTypeDescription
integration__snowflake__snowflake_execute_query snowflake.snowflake_execute_query Write Execute a SQL statement on Snowflake. Returns column metadata and result rows. Optionally specify warehouse, database, and schema context.
integration__snowflake__snowflake_list_databases snowflake.snowflake_list_databases Read List all databases in the Snowflake account. Returns database names, identifiers, and creation timestamps.
integration__snowflake__snowflake_get_database snowflake.snowflake_get_database Read Get details for a specific Snowflake database, including retention time, owner, and size.
integration__snowflake__snowflake_list_schemas snowflake.snowflake_list_schemas Read List all schemas within a Snowflake database. Returns schema names and metadata.
integration__snowflake__snowflake_list_tables snowflake.snowflake_list_tables Read List all tables within a Snowflake database schema. Returns table names, types, and metadata.
integration__snowflake__snowflake_describe_table snowflake.snowflake_describe_table Read Describe a Snowflake table — get column names, data types, nullable, default values, and other metadata.
integration__snowflake__snowflake_list_warehouses snowflake.snowflake_list_warehouses Read List all warehouses in the Snowflake account. Returns warehouse names, sizes, and status.
integration__snowflake__snowflake_get_warehouse snowflake.snowflake_get_warehouse Read Get details for a specific Snowflake warehouse, including size, type, auto-suspend, and auto-resume settings.
integration__snowflake__snowflake_get_current_user snowflake.snowflake_get_current_user Read Get the current authenticated Snowflake user and session information.

Related Snowflake Pages

Snowflake CLIUse direct JSON commands instead of MCP discovery. Snowflake MCPFull gateway reference and MCP tool names. KosmoKrator for OpenAI AgentsClient-level gateway setup.