How to query data from a Snowflake database – MCP tools

execute_snowflake_sql_query
Snowflake MCP Server
Execute SQL queries on Snowflake data warehouses to retrieve, analyze, or modify data. Supports custom database, schema, and warehouse configurations for targeted operations.
MIT
list-snowflake-warehouses
Simple Snowflake MCP
Retrieve a list of available Snowflake Data Warehouses to manage resources efficiently using the Simple Snowflake MCP Server.
MIT
query_table
Keboola Explorer MCP Server
Execute SQL SELECT queries to retrieve data from Snowflake databases using fully qualified table names, including database, schema, and table details for accurate results.
MIT
execute-snowflake-sql
Simple Snowflake MCP
Run SQL queries on Snowflake and retrieve results directly through the Simple Snowflake MCP Server, designed to operate behind corporate proxies.
MIT
execute_sql
DataPilot MCP Server
Execute SQL queries on Snowflake databases to retrieve data, manage warehouses, and perform data analysis operations through AI-guided interactions.
MIT
list_databases
Snowflake MCP Server
Retrieve all available databases in Snowflake to explore and manage database structures for efficient data operations and analysis.
GPL 3.0

Interested in MCP?

Join the MCP community for support and updates.

Global Database
Access comprehensive company data including financial records, ownership structures, and contact information. Search for businesses using domains, registration numbers, or LinkedIn profiles to streamline due diligence and lead generation. Retrieve historical financial performance and complex corporate group structures to support informed business analysis.
Google Big Query
The BigQuery remote MCP server is a fully managed service that uses the Model Context Protocol to connect AI applications and LLMs to BigQuery data sources. It provides secure, standardized tools for AI agents to list datasets and tables, retrieve schemas, generate and execute SQL queries through natural language, and analyze data—enabling direct access to enterprise analytics data without requiring manual SQL coding.