Allow to use VS Code Secret Storage for database password

[hongbo-miao]

Validations

• I believe this is a way to improve. I'll try to join the Continue Discord for questions
• I'm not able to find an open issue that requests the same enhancement

Problem

Currently Continues saves database password in plain text at ~/.continue/config.json which is not that secured:

{
  "contextProviders": [
    {
      "name": "database",
      "params": {
        "connections": [
          {
            "name": "examplePostgres",
            "connection_type": "postgres",
            "connection": {
              "user": "username",
              "host": "localhost",
              "database": "exampleDB",
              "password": "yourPassword",
              "port": 5432
            }
          },
          {
            "name": "exampleMssql",
            "connection_type": "mssql",
            "connection": {
              "user": "username",
              "server": "localhost",
              "database": "exampleDB",
              "password": "yourPassword"
            }
          }
        ]
      }
    }
  ]
}

Solution

I don't have a perfect way in mind. As I know Continue supports multiple IDEs.
For VS Code, one option is to allow to save in VSCode Secret Storage. This is what this DBCode plugin does. In VS Code ~/Library/Application Support/Code/User/settings.json, it refers as

{
  "dbcode.connections": [
    {
      "connectionId": "V76A15foqKcw2ZcD-AkWy",
      "name": "examplePostgres",
      "driver": "postgres",
      "connectionType": "host",
      "host": "localhost",
      "port": 5432,
      "ssl": true,
      "username": "username",
      "password": "",
      "savePassword": "secretStorage",
      "connectionTimeout": 30
    }
  ]
}