Retrieve column names and data types for data lake tables to understand table structure and write optimized queries in Snowflake.
Python
Apache 2.0
133,413 tools. Last updated 2026-05-25 14:15
"How to query data in Snowflake" matching MCP tools:
- Execute SQL SELECT queries to retrieve data from Snowflake databases using fully qualified table names, including database, schema, and table details for accurate results.
- Execute SQL queries on Snowflake data warehouses to retrieve, analyze, or modify data. Supports custom database, schema, and warehouse configurations for targeted operations.
- Retrieves a list of all databases accessible in your Snowflake account.GPL 3.0
- Retrieve all available databases in Snowflake to explore and manage database structures for efficient data operations and analysis.GPL 3.0
- Execute SQL queries on Snowflake databases to retrieve data, manage warehouses, and perform data analysis operations through AI-guided interactions.MIT
Matching MCP Servers
- AlicenseAquality-maintenanceEnables AI assistants to securely connect to Snowflake data warehouses and execute SQL queries through natural language interactions. Supports multiple authentication methods and provides formatted query results with built-in security controls.Last updated12
- Alicense-qualityCmaintenanceSnowflake MCP Server by CDataLast updatedMIT
Matching MCP Connectors
- ThinAir DataOAuth
Connect your AI to any database — PostgreSQL, MySQL, or SQL Server — in seconds.
data.ny.gov — New York State open-data Socrata portal
- Set up new data connections in Polytomic by specifying name, type, and configuration for sources like PostgreSQL, Salesforce, or Snowflake.MIT
- Retrieve a list of available Snowflake Data Warehouses to manage resources efficiently using the Simple Snowflake MCP Server.MIT
- Run SQL queries on Snowflake and retrieve results directly through the Simple Snowflake MCP Server, designed to operate behind corporate proxies.MIT
- Start the query profiler to record execution times and plans for all queries. Specify a timeout in seconds; profiler auto-stops after that duration.
- Stop the query profiler to retrieve aggregated query statistics including execution counts, timing, and plan step costs, with results saved to disk.
- Manage data source and destination connections for CData Sync by creating, updating, or deleting configurations. Define how to access databases, APIs, and files with provider-specific connection strings.MIT
- Create box plots from SQL query results on CSV or Parquet data sources to visualize statistical distributions and identify outliers in your data.MIT
- Retrieve a specific query configuration from a Tulip Table using table and query IDs to access manufacturing data through the Tulip API.Apache 2.0
- Find the K nearest neighbors to a query vector among vectors stored in Redis hash data structures.MIT
- Query managed objects in PingOne Advanced Identity Cloud using CREST query filter syntax. Filter, sort, and paginate results.Apache 2.0
- Create foreign tables in Hologres to query MaxCompute data directly, enabling faster analytics without data movement.Apache 2.0
- Retrieve and filter rows from a specified Appwrite database table using query parameters to manage data efficiently.MIT
- Execute Artifactory Query Language (AQL) queries to search for artifacts, builds, or entities in JFrog Artifactory. Supports complex criteria, sorting, and pagination for precise artifact discovery.Apache 2.0
- Create database indexes to optimize query performance by specifying columns for faster data retrieval in Appwrite tables.MIT