Skip to content
Kitbay
MCP server

mcp-snowflake-server

Runs locallyGPL-3.0Updated on Oct 7, 2025184GitHub starsCan change dataNeeds an API key

A community MCP server by Isaac Wasserman that lets an AI client work with a Snowflake account.

What it does

A community MCP server by Isaac Wasserman that lets an AI client work with a Snowflake account. It lists databases, schemas and tables, describes a table's columns, and runs SELECT queries; insert, update, delete and table creation are only offered when the server is started with an allow-write flag. Findings from an analysis can be added to a memo resource, and table schema summaries can be prefetched as resources. It runs locally with uvx and takes connection details either as arguments or from a connections TOML file, with password or private-key sign-in. Individual tools can be excluded, and logging can be written to a folder.

Capabilities

  • List databases, schemas and tables
  • Describe table columns
  • Run SELECT queries
  • Insert, update, delete and create tables when writes are allowed
  • Keep an insights memo resource