Snowflake MCP server with read/write operations and insight tracking via the MCP protocol.
Loading more......
Trino MCP server allowing data querying and access from Trino clusters using the MCP protocol.
Allows LLMs to query and retrieve data from Snowflake data warehouses via the Model Context Protocol (MCP), enabling AI-powered data analysis, report generation, and insights extraction directly from Snowflake.
An MCP server designed for querying and analyzing Azure Data Explorer databases, supporting time-series and analytics MCP use cases.
An MCP server integrating with Airtable to enable CRUD operations on records within code editors, showcasing a practical database MCP server implementation.
Provides read and write access to Airtable databases via an MCP server, offering a simple and effective database integration for MCP applications.
MCP server implementation for Alibaba Cloud Tablestore, supporting document management, semantic and vector search, RAG-friendly, and serverless capabilities.
Category: database-messaging-mcp-servers
Tags: snowflake, database, mcp, data-access
Source: GitHub Repository
mcp-snowflake-server is an implementation of the Model Context Protocol (MCP) server that enables database interaction with Snowflake. It allows users to run SQL queries, perform schema operations, and track insights via a memo resource using the MCP protocol.
Dynamic Memo Resource
memo://insights: Continuously updated data insights memo that aggregates discovered insights during analysis. Auto-updates as new insights are discovered via the append_insight tool.Query Tools
read_query: Execute SELECT queries to read data from the database. Returns query results as an array of objects.write_query (requires --allow-write flag): Execute INSERT, UPDATE, or DELETE queries. Returns the number of affected rows.create_table (requires --allow-write flag): Create new tables in the database. Returns confirmation of table creation.Schema Tools
list_tables: Retrieve a list of all tables in the database.describe_table: View column information for a specific table, returning column definitions with names and types.Analysis Tools
append_insight: Add new data insights to the memo resource, triggering an update of the memo://insights resource.Configurable Connection
--log_dir, --log_level) and tool exclusion (--exclude_tools).--allow_write flag enables write operations (not recommended by default).Integration
No pricing information provided; the project is open-source under the GPL-3.0 license.