Claude Desktop
Desktop · Freemium · Proprietary
Anthropic's official Claude AI desktop application. Supports MCP servers to extend functionality.
WindowsMacOS
simple_snowflake_mcp
yannbrrd/simple_snowflake_mcp
A production-ready MCP server that provides seamless Snowflake integration with advanced features including configurable logging, resource subscriptions, and comprehensive error handling. Designed to work seamlessly behind corporate proxies.
Install
uvx simple-snowflake-mcpClient configuration
{
"mcpServers": {
"simple-snowflake-mcp": {
"command": "uv",
"args": [
"run",
"simple-snowflake-mcp"
]
}
}
}Environment variables
SNOWFLAKE_USERSNOWFLAKE_PASSWORDSNOWFLAKE_ACCOUNTCONFIG_FILE- Author
- @yannbrrd
- Category
- Database, Developer Tools
- Updated
- Oct 6, 2026
About simple_snowflake_mcp
Enhanced Snowflake MCP Server with comprehensive configuration system and full MCP protocol compliance.
Features
Real-time notifications when Snowflake resources change
Automatic updates for database schema changes
Tool availability notifications
Dynamic resource discovery and listing
Detailed resource metadata and descriptions
Resource templates for browsing the object hierarchy by URI (snowflake://database/{database}/schemas, snowflake://database/{database}/schema/{schema}/tables,…
Argument completion for prompts and resource templates (live database/ schema/table name suggestions)
Client-controlled log verbosity via the MCP logging/setLevel request
Configurable query limits and a server-side statement timeout
Comprehensive error handling with generic client messages and a server-side reference id
Tools (15)
execute-snowflake-sql
Executes a SQL query on Snowflake and returns the result.
execute-query
Executes a SQL query with server-enforced read-only protection.
get-connection-info
Returns current Snowflake connection information and server status.
list-snowflake-warehouses
Lists available Data Warehouses (DWH) on Snowflake.
list-databases
Lists all accessible Snowflake databases.
list-schemas
Lists schemas in a database.
list-tables
Lists tables in a database/schema.
list-views
Lists views in a database/schema.
describe-table
Returns the columns and types of a database/schema/table (works for views too).
query-view
Reads rows from a database/schema/view (or table) by name, with the same server-enforced read-only protection and row limiting as execute-query.
export-schema
Exports hierarchical schema metadata (databases → schemas → tables/views → columns).
add-note
Adds or updates a note (name, content) kept in server memory for the session.
delete-note
Deletes an existing note by name.
list-notes
Lists current note names in sorted order.
get-note
Returns the note payload (name, content) for a given note name.
Details on this page are taken from the project's README. Open README
Supported clients
Clients mentioned in this server's README:
VS Code GitHub Copilot
Desktop · Freemium · MIT
VS Code integrates MCP with GitHub Copilot through agent mode, allowing direct interaction with MCP-provided tools in your agentic coding workflow. Configure servers in Claude Desktop, workspace, or user settings, with guided MCP installation and secure handling of secrets in input variables to avoid leaking hardcoded keys.
Related MCP servers
Supabase MCP
supabase-community/supabase-mcp
The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.
Genai Toolbox
googleapis/genai-toolbox
MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.
Supabase MCP Server
alexander-zuev/supabase-mcp-server
Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.
Awesome MCP List
MobinX/awesome-mcp-list
This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.
PostgreSQL Model Context Protocol (PG MCP) Server
stuzero/pg-mcp-server
PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.
dbhub
bytebase/dbhub
[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.