Skip to main content


Send any script from VSCode to


  • Install CLI


  1. Create a VSCode task

Create a file in the path: .vscode/task.json of your workspace with the contents:

// See
// for the documentation about the tasks.json format
"version": "2.0.0",
"tasks": [
"label": "Run query with",
"type": "shell",
"command": "hoop exec ${input:connectionName} -f ${file}",
"panel": "new",
"showReuseMessage": false,
"clear": true
"inputs": [
"type": "pickString",
"id": "connectionName",
"description": "Where do you want to run this script?",
"options": ["db-write", "pg-db", "customers-database", "products-database"],
"default": "component"

'''info Update the options list with the names of the connections you want to use. '''

  1. Run your file in from VSCode!

Hit ctrl+shift+P and type to select our execution task:

VSCode Task