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.

data

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.

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.

Agent Surfaces

Snowflake CLIHeadless setup, JSON output, direct function calls. Snowflake MCPExpose selected tools to local MCP clients. Snowflake LuaAgent-facing namespace and Lua reference. FeedbackReport missing tools, auth issues, or bad metadata.

Machine-Readable Metadata

integration_slug: snowflake
route_slug: snowflake
package: snowflake
auth_strategy: oauth2_manual_token
cli_setup_supported: true
cli_runtime_supported: true
mcp_gateway_supported: true
lua_supported: true

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.