Connect your AI agent to Snowflake
Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments
Set it up in Melso
- 1In Melso, open Settings → Agent Apps and hit Connect on Snowflake.
- 2Finish the OAUTH2 sign-in in the window that opens. Melso stores the connection, not your credentials.
- 3Open your agent, go to its Agent Apps tab, and allow Snowflake.
- 4Give the agent a task. It calls Snowflake itself when the work needs it.
What Snowflake gives your agent
The tools, permissions, and events Snowflake exposes — the same ones your agent can use once the app is authorized.
What you sign in with
Snowflake connects with OAUTH2.
- Client id
- Client secret
Permissions
Tools Snowflake exposes
Cancel Statement Execution
Cancels the execution of a running SQL statement. Use this action to stop a long-running query.
Check Statement Status
Retrieves the status and results of a previously submitted SQL statement using its statement handle. Use this to poll async queries submitted via SNOWFLAKE_SUBMIT_SQL_STATEMENT; call repeatedly until status is no longer pending. Use SNOWFLAKE_CANCEL_STATEMENT to abort a hanging query.
Drop Warehouse
Drops (permanently deletes) a warehouse in Snowflake. This operation is irreversible — once a warehouse is dropped, it cannot be recovered. Use this action when you need to permanently remove a warehouse that is no longer needed. Requires OWNERSHIP privilege on the warehouse.
Execute SQL
Execute SQL statements in Snowflake and retrieve results. Supports SELECT queries for data retrieval, DDL statements (CREATE, ALTER, DROP) for schema management, and DML statements (INSERT, UPDATE, DELETE) for data modification. Returns comprehensive result metadata including column types, row counts, and execution status. Unquoted SQL identifiers are auto-uppercased by Snowflake — use matching case in `database`, `schema_name`, `warehouse`, and `role` parameters to avoid 'object not found' errors. Always apply explicit time-range filters and a LIMIT clause to unbounded SELECT queries to prevent large, slow result sets.
Fetch Catalog Integration
Retrieves detailed configuration and metadata for a specific catalog integration. Catalog integrations allow Snowflake to connect to external Apache Iceberg catalogs (AWS Glue, Snowflake Open Catalog/Polaris, or Apache Iceberg REST catalogs) to query Iceberg tables managed by those external systems.
Get Active Scheduled Maintenances
Retrieves a list of any active scheduled maintenances currently in the In Progress or Verifying state.
Get All Scheduled Maintenances
Retrieves a list of the 50 most recent scheduled maintenances, including those in the Completed state.
Get Component Status
Retrieves the status of individual components, each listed with its current status.
Use Snowflake from the agent you already run
Melso runs the agent. You decide which of your authorized apps it may reach.
Codex
Run Codex as a Melso agent and let it use the apps you have authorized.
Use Snowflake from CodexHermes
Run Hermes as a Melso agent and let it use the apps you have authorized.
Use Snowflake from HermesCompare nearby apps
Other Databases connections your agents can use.
Connect to Supabase
Supabase is an open-source backend-as-a-service providing a Postgres database, authentication, storage, and real-time subscription APIs for building modern applications
Connect to Airtable
Airtable merges spreadsheet functionality with database power, enabling teams to organize projects, track tasks, and collaborate through customizable views, automation, and integrations for data management
Connect to Code Interpreter
CodeInterpreter extends Python-based coding environments with integrated data analysis, enabling developers to run scripts, visualize results, and prototype solutions inside supported platforms
Connect to SerpApi
SerpApi provides a real-time API for structured search engine results, allowing developers to scrape, parse, and analyze SERP data for SEO and research
Connect to Exa
Exa focuses on data extraction and search, helping teams gather, analyze, and visualize information from websites, APIs, or internal databases
Connect to People Data Labs
PeopleDataLabs provides B2B data enrichment and identity resolution, empowering organizations to build enriched user profiles and validate customer information