Loading...
npx -y @smithery/cli install mcp_snowflake_server --client clauderead_queryExecutes SELECT queries to retrieve data from the Snowflake database.
Read-only operation, no data modification.
write_queryExecutes INSERT, UPDATE, or DELETE queries to modify data in the Snowflake database.
Allows modification and deletion of data.
create_tableCreates new tables within the Snowflake database.
Allows structural changes to the database schema.
list_databasesLists all databases available in the Snowflake instance.
Read-only operation, no data modification.
list_schemasLists all schemas within a specified database.
Read-only operation, no data modification.
list_tablesLists all tables within a specified database and schema.
Read-only operation, no data modification.
describe_tableRetrieves column information for a specified table.
Read-only operation, no data modification.
append_insightAdds a new data insight to the insights memo.
Non-destructive write operation, but could be used to inject misleading information.
The Snowflake MCP server is relatively safe in its default read-only configuration. Enabling write access significantly increases the risk, requiring careful management of permissions and input validation to prevent data corruption or unauthorized modifications. Use of connection files is recommended to avoid hardcoding credentials.