snowflake

SQL queries, warehouses, and databases

Server path: /snowflake | Type: Application | PCID required: Yes

Tools

Tool	Description
snowflake_cancel_statement	Cancel the execution of a running SQL statement
snowflake_check_statement_status	Check the status of a previously submitted SQL statement
snowflake_describe_table	Get detailed information about a table including columns, data types, and constraints
snowflake_execute_statement	Execute a SQL statement in Snowflake and return results
snowflake_get_query_history	Get query execution history with optional filters
snowflake_get_session_info	Get current session information including user, role, warehouse, database, and schema
snowflake_get_table_ddl	Get the DDL (Data Definition Language) statement for creating a table
snowflake_get_users	Get a list of users in the Snowflake account
snowflake_get_warehouse_status	Get the status of warehouses (running, suspended, etc.)
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_start_warehouse	Start a suspended warehouse
snowflake_stop_warehouse	Stop/suspend a running warehouse

---

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_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_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_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_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_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_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_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"
  ]
}

---

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_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_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"
  ]
}