Can I use Snowflake as a CLI?

Yes. KosmoKrator exposes a Snowflake CLI through kosmo integrations:call and the provider shortcut command. Commands can return JSON for scripts, CI, and coding agents.

Can I expose Snowflake through MCP?

Yes. The KosmoKrator MCP gateway can expose selected Snowflake tools to clients such as Claude Code, Cursor, Codex, and other MCP-compatible tools.

Where are Snowflake credentials stored?

Snowflake credentials are configured in KosmoKrator's local integration settings and reused by CLI, Lua, and MCP gateway surfaces.

Can I deny write access for Snowflake MCP tools?

Yes. Start the gateway with --write=deny for read-only clients, or use ask/allow only for trusted workspaces.

database

Snowflake MCP, CLI, and Lua Integration for AI Agents

Snowflake integration docs for AI agents: MCP gateway setup, Snowflake CLI commands, Lua API reference, credentials, and function schemas.

9 functions 8 read 1 write Manual OAuth token auth

Submit Snowflake feedback View package source

Snowflake for agents

Credentials can be configured manually in web or CLI hosts.

Use this integration from Lua code mode, the headless integrations CLI, or the KosmoKrator MCP gateway. The same package metadata powers all three surfaces.

Machine-Readable Metadata

integration_slug: snowflake
route_slug: snowflake
package: snowflake
auth_strategy: oauth2_manual_token Manual OAuth token
cli_setup_supported: true
cli_runtime_supported: true
mcp_gateway_supported: true
lua_supported: true
supports_multi_account: true

Quick Links

Lua APIAgent-facing namespace and function reference. Snowflake CLIHeadless setup and direct function calls. Snowflake MCPMCP gateway setup for external clients. Submit feedbackReport missing tools, auth problems, wrong docs, or runtime issues. ContributeAdd tools or improve metadata in the integrations repo.

Snowflake MCP Client Matrix

Use these pages when a specific agent client or framework needs copy-pasteable MCP setup for Snowflake.

Snowflake CLI Matrix

Use these pages for direct Snowflake CLI workflows in scripts, CI, cron, and agent wrappers.

CI Snowflake CLI for CI. Cron Jobs Snowflake CLI for cron jobs. Shell Scripts Snowflake CLI for shell scripts. Headless Automation Snowflake CLI for headless automation. Coding Agents Snowflake CLI for coding agents.

Function Catalog

Function	Type	Parameters	Description
`snowflake.snowflake_execute_query`	Write `write`	4	Execute a SQL statement on Snowflake. Returns column metadata and result rows. Optionally specify warehouse, database, and schema context.
`snowflake.snowflake_list_databases`	Read `read`	0	List all databases in the Snowflake account. Returns database names, identifiers, and creation timestamps.
`snowflake.snowflake_get_database`	Read `read`	1	Get details for a specific Snowflake database, including retention time, owner, and size.
`snowflake.snowflake_list_schemas`	Read `read`	1	List all schemas within a Snowflake database. Returns schema names and metadata.
`snowflake.snowflake_list_tables`	Read `read`	2	List all tables within a Snowflake database schema. Returns table names, types, and metadata.
`snowflake.snowflake_describe_table`	Read `read`	3	Describe a Snowflake table — get column names, data types, nullable, default values, and other metadata.
`snowflake.snowflake_list_warehouses`	Read `read`	0	List all warehouses in the Snowflake account. Returns warehouse names, sizes, and status.
`snowflake.snowflake_get_warehouse`	Read `read`	1	Get details for a specific Snowflake warehouse, including size, type, auto-suspend, and auto-resume settings.
`snowflake.snowflake_get_current_user`	Read `read`	0	Get the current authenticated Snowflake user and session information.