snowflake

Server path: /snowflake | Type: Application | PCID required: Yes SQL queries, warehouses, and databases

Tools

Tool	Description
`snowflake_execute_statement`	Execute a SQL statement in Snowflake and return results
`snowflake_check_statement_status`	Check the status of a previously submitted SQL statement
`snowflake_cancel_statement`	Cancel the execution of a running SQL statement
`snowflake_list_databases`	List all databases available in the Snowflake account
`snowflake_list_schemas`	List all schemas in a database or current database
`snowflake_list_tables`	List all tables in a schema, database, or current context
`snowflake_describe_table`	Get detailed information about a table including columns, data types, and constraints
`snowflake_get_table_ddl`	Get the DDL (Data Definition Language) statement for creating a table
`snowflake_get_warehouse_status`	Get the status of warehouses (running, suspended, etc.)
`snowflake_start_warehouse`	Start a suspended warehouse
`snowflake_stop_warehouse`	Stop/suspend a running warehouse
`snowflake_get_session_info`	Get current session information including user, role, warehouse, database, and schema
`snowflake_get_query_history`	Get query execution history with optional filters
`snowflake_get_users`	Get a list of users in the Snowflake account

snowflake_execute_statement

Execute a SQL statement in Snowflake and return results Parameters:

Parameter	Type	Required	Default	Description
`statement`	string	Yes	—	SQL statement to execute
`timeout`	number	No	—	Execution timeout in seconds (default: 60)
`bindings`	object	No	—	Parameter bindings for the SQL statement
`database`	string	No	—	Database context for the statement
`schema`	string	No	—	Schema context for the statement
`warehouse`	string	No	—	Warehouse context for the statement
`role`	string	No	`"ACCOUNTADMIN"`	Role context for the statement, defaults to ACCOUNTADMIN
`requestId`	string	No	—	Optional request ID for tracking

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for authentication"
    },
    "statement": {
      "type": "string",
      "description": "SQL statement to execute"
    },
    "timeout": {
      "type": "number",
      "description": "Execution timeout in seconds (default: 60)"
    },
    "bindings": {
      "type": "object",
      "additionalProperties": true,
      "description": "Parameter bindings for the SQL statement"
    },
    "database": {
      "type": "string",
      "description": "Database context for the statement"
    },
    "schema": {
      "type": "string",
      "description": "Schema context for the statement"
    },
    "warehouse": {
      "type": "string",
      "description": "Warehouse context for the statement"
    },
    "role": {
      "type": "string",
      "default": "ACCOUNTADMIN",
      "description": "Role context for the statement, defaults to ACCOUNTADMIN"
    },
    "requestId": {
      "type": "string",
      "description": "Optional request ID for tracking"
    }
  },
  "required": [
    "PCID",
    "statement"
  ]
}

snowflake_check_statement_status

Check the status of a previously submitted SQL statement Parameters:

Parameter	Type	Required	Default	Description
`statementHandle`	string	Yes	—	Statement handle returned from execute_statement
`requestId`	string	No	—	Optional request ID for tracking

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for authentication"
    },
    "statementHandle": {
      "type": "string",
      "description": "Statement handle returned from execute_statement"
    },
    "requestId": {
      "type": "string",
      "description": "Optional request ID for tracking"
    }
  },
  "required": [
    "PCID",
    "statementHandle"
  ]
}

snowflake_cancel_statement

Cancel the execution of a running SQL statement Parameters:

Parameter	Type	Required	Default	Description
`statementHandle`	string	Yes	—	Statement handle of the statement to cancel
`requestId`	string	No	—	Optional request ID for tracking

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for authentication"
    },
    "statementHandle": {
      "type": "string",
      "description": "Statement handle of the statement to cancel"
    },
    "requestId": {
      "type": "string",
      "description": "Optional request ID for tracking"
    }
  },
  "required": [
    "PCID",
    "statementHandle"
  ]
}

snowflake_list_databases

List all databases available in the Snowflake account

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for authentication"
    }
  },
  "required": [
    "PCID"
  ]
}

snowflake_list_schemas

List all schemas in a database or current database Parameters:

Parameter	Type	Required	Default	Description
`database`	string	No	—	Database name to list schemas from (defaults to current database)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for authentication"
    },
    "database": {
      "type": "string",
      "description": "Database name to list schemas from (defaults to current database)"
    }
  },
  "required": [
    "PCID"
  ]
}

snowflake_list_tables

List all tables in a schema, database, or current context Parameters:

Parameter	Type	Required	Default	Description
`database`	string	No	—	Database name (defaults to current database)
`schema`	string	No	—	Schema name (defaults to current schema)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for authentication"
    },
    "database": {
      "type": "string",
      "description": "Database name (defaults to current database)"
    },
    "schema": {
      "type": "string",
      "description": "Schema name (defaults to current schema)"
    }
  },
  "required": [
    "PCID"
  ]
}

snowflake_describe_table

Get detailed information about a table including columns, data types, and constraints Parameters:

Parameter	Type	Required	Default	Description
`tableName`	string	Yes	—	Name of the table to describe
`database`	string	Yes	—	Database name
`schema`	string	Yes	—	Schema name

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for authentication"
    },
    "tableName": {
      "type": "string",
      "description": "Name of the table to describe"
    },
    "database": {
      "type": "string",
      "description": "Database name"
    },
    "schema": {
      "type": "string",
      "description": "Schema name"
    }
  },
  "required": [
    "PCID",
    "tableName",
    "database",
    "schema"
  ]
}

snowflake_get_table_ddl

Get the DDL (Data Definition Language) statement for creating a table Parameters:

Parameter	Type	Required	Default	Description
`tableName`	string	Yes	—	Name of the table to get DDL for
`database`	string	No	—	Database name (defaults to current database)
`schema`	string	No	—	Schema name (defaults to current schema)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for authentication"
    },
    "tableName": {
      "type": "string",
      "description": "Name of the table to get DDL for"
    },
    "database": {
      "type": "string",
      "description": "Database name (defaults to current database)"
    },
    "schema": {
      "type": "string",
      "description": "Schema name (defaults to current schema)"
    }
  },
  "required": [
    "PCID",
    "tableName"
  ]
}

snowflake_get_warehouse_status

Get the status of warehouses (running, suspended, etc.) Parameters:

Parameter	Type	Required	Default	Description
`warehouseName`	string	No	—	Specific warehouse name (defaults to all warehouses)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for authentication"
    },
    "warehouseName": {
      "type": "string",
      "description": "Specific warehouse name (defaults to all warehouses)"
    }
  },
  "required": [
    "PCID"
  ]
}

snowflake_start_warehouse

Start a suspended warehouse Parameters:

Parameter	Type	Required	Default	Description
`warehouseName`	string	Yes	—	Name of the warehouse to start

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for authentication"
    },
    "warehouseName": {
      "type": "string",
      "description": "Name of the warehouse to start"
    }
  },
  "required": [
    "PCID",
    "warehouseName"
  ]
}

snowflake_stop_warehouse

Stop/suspend a running warehouse Parameters:

Parameter	Type	Required	Default	Description
`warehouseName`	string	Yes	—	Name of the warehouse to stop

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for authentication"
    },
    "warehouseName": {
      "type": "string",
      "description": "Name of the warehouse to stop"
    }
  },
  "required": [
    "PCID",
    "warehouseName"
  ]
}

snowflake_get_session_info

Get current session information including user, role, warehouse, database, and schema

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for authentication"
    }
  },
  "required": [
    "PCID"
  ]
}

snowflake_get_query_history

Get query execution history with optional filters Parameters:

Parameter	Type	Required	Default	Description
`limit`	number	No	—	Maximum number of queries to return (default: 100)
`startTime`	string	No	—	Start time for query history (ISO format)
`endTime`	string	No	—	End time for query history (ISO format)

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for authentication"
    },
    "limit": {
      "type": "number",
      "description": "Maximum number of queries to return (default: 100)"
    },
    "startTime": {
      "type": "string",
      "description": "Start time for query history (ISO format)"
    },
    "endTime": {
      "type": "string",
      "description": "End time for query history (ISO format)"
    }
  },
  "required": [
    "PCID"
  ]
}

snowflake_get_users

Get a list of users in the Snowflake account

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for authentication"
    }
  },
  "required": [
    "PCID"
  ]
}

Triggers API

Platform API

Embedded MCP Servers

Application MCP Servers

Tools

snowflake_execute_statement

snowflake_check_statement_status

snowflake_cancel_statement

snowflake_list_databases

snowflake_list_schemas

snowflake_list_tables

snowflake_describe_table

snowflake_get_table_ddl

snowflake_get_warehouse_status

snowflake_start_warehouse

snowflake_stop_warehouse

snowflake_get_session_info

snowflake_get_query_history

snowflake_get_users

Triggers API

Platform API

Embedded MCP Servers

Application MCP Servers

​Tools

​snowflake_execute_statement

​snowflake_check_statement_status

​snowflake_cancel_statement

​snowflake_list_databases

​snowflake_list_schemas

​snowflake_list_tables

​snowflake_describe_table

​snowflake_get_table_ddl

​snowflake_get_warehouse_status

​snowflake_start_warehouse

​snowflake_stop_warehouse

​snowflake_get_session_info

​snowflake_get_query_history

​snowflake_get_users

Tools

snowflake_execute_statement

snowflake_check_statement_status

snowflake_cancel_statement

snowflake_list_databases

snowflake_list_schemas

snowflake_list_tables

snowflake_describe_table

snowflake_get_table_ddl

snowflake_get_warehouse_status

snowflake_start_warehouse

snowflake_stop_warehouse

snowflake_get_session_info

snowflake_get_query_history

snowflake_get_users