read_queryLABSCO SUMMARY
A SELECT-only seat at your warehouse.
The four schema calls give an agent the orientation it needs before it writes SQL, and read_query is the only way data comes back — this build has no write path. append_insight is the unusual part: findings accumulate into a memo instead of scrolling out of the conversation.
What it is
A read path into Snowflake: walk from databases to schemas to tables to columns, run SELECT queries, and append findings to a memo the server keeps updated.
What you get
- Every database in the Snowflake instance
- The schemas inside a database you name
- The tables inside one database and schema
- Column names, types, nullability, defaults and comments for a table
- A SELECT query run against the warehouse, returned as rows
- A running memo of insights that updates as you append to it
Requirements
A Snowflake account, with account, warehouse, user, password, role and database passed on the launch command. It runs through uvx.
Setup effort
One command plus credentials — uvx mcp_snowflake_server_readonly, then supply credentials
USE CASES
01
Getting oriented in an account you did not build
Three calls take you from which databases exist, to the schemas inside one, to the tables inside that.
02
Writing a query against a table you have never read
Read the column names and types first so they are copied rather than guessed, then run the query — the loop that otherwise costs two failed attempts.
03
Answering a data question where it was asked
The SELECT runs and the rows come back inline, instead of a switch to a worksheet and a paste back.
04
Keeping what an analysis turned up
Append the finding to the memo so the next session starts from it rather than rediscovering it.
6 tools
Listed in project docs. Your client may show a different list.
list_databaseslist_schemaslist_tablesdescribe_tableappend_insightBEFORE YOU INSTALL
What to know first
Tools you get
6 tools named in the project's documentation.
Requires
- uvx on PATH
- A Snowflake account — its account identifier, user and password, plus the warehouse, role, database and schema to use, passed as flags in the client configuration
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
Server setup
TERMINAL
uvx mcp_snowflake_server_readonlyMCP Clients
Claude Desktop — uvx
CLAUDE DESKTOP — UVX · JSON
{
"mcpServers": {
"snowflake_pip": {
"command": "uvx",
"args": [
"--python=3.12",
"mcp_snowflake_server_readonly",
"--account",
"<YOUR_ACCOUNT>",
"--warehouse",
"<YOUR_WAREHOUSE>",
"--user",
"<YOUR_USER>",
"--password",
"<YOUR_PASSWORD>",
"--role",
"<YOUR_ROLE>",
"--database",
"<YOUR_DATABASE>",
"--schema",
"<YOUR_SCHEMA>"
]
}
}
}
