mcp-snowflake-server
The Snowflake MCP Server is a Model Context Protocol implementation designed for seamless interaction with Snowflake databases. It facilitates SQL queries through various tools and offers dynamically updated data insights and schema context resources for efficient database management.
How can I enable write operations?
Write operations can be enabled by using the --allow-write flag when starting the server.
What is the purpose of the append_insight tool?
The append_insight tool is used to add new data insights to the memo resource, which is then updated dynamically.
Can I filter out specific databases or tables?
Yes, the server supports exclusion patterns to filter out specific databases, schemas, or tables.
Is it possible to use external browser authentication?
Yes, you can use external browser authentication by setting SNOWFLAKE_AUTHENTICATOR to externalbrowser in your .env file.
What logging options are available?
You can specify logging options such as --log_dir for the log directory and --log_level for the logging level (DEBUG, INFO, WARNING, ERROR, CRITICAL).