Snowflake Basic
Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments
This is a first-class FlyMyAI MCP. Agents discover it automatically via tool search and call the actions below on demand - you never wire it up by hand. See the Composio catalog for how discovery works.
Connect
Snowflake Basic authenticates with basic authentication credentials. Generate the credential in your Snowflake Basic account, then paste it into FlyMyAI the first time an agent uses a Snowflake Basic action.
Get your Snowflake Basic credential →
Fields to fill in FlyMyAI
| Field | Details |
|---|---|
Username | Username for basic auth (required) |
Password | Password for basic auth (required) |
Account ID | Your Snowflake account ID for authentication. Use the format 'myorganization-myaccount'. To find your account ID, click on your account in the bottom left corner of the Snowflake web interface. The account identifier will be displayed in the account details popup. (required) |
Actions
Every action this integration exposes. Agents pick the right one from the task; you do not call them by name.
| Action | What it does | Required inputs |
|---|---|---|
SNOWFLAKE_BASIC_DESCRIBE_TABLE | Retrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified snowflake table. | database, schema_name, table_name |
SNOWFLAKE_BASIC_EXPLORE_COLUMNS | Retrieves a sample of distinct values for specified columns from a snowflake table. | database, schema_name, table_name |
SNOWFLAKE_BASIC_RUN_QUERY | Executes the given sql query in snowflake within the specified database and schema (which must exist and be accessible), automatically setting context first. | database, schema_name, query |
SNOWFLAKE_BASIC_SHOW_DATABASES | Retrieves a list of all databases available in the snowflake account. | - |
SNOWFLAKE_BASIC_SHOW_SCHEMAS | Retrieves a list of all schemas within a specified snowflake database. | database |
SNOWFLAKE_BASIC_SHOW_TABLES | Retrieves a list of tables, including their row counts and sizes in bytes, from a specified schema within a snowflake database. | database, schema_name |
Links
We love our partners - FlyMy.AI builds with the best. Thanks, Snowflake Basic!