Send Feedback
Skip to content

Connections in the kdb Visual Studio Code Extension

This page explains how to create, edit, and manage connections in the kdb Visual Studio Code Extension.

The kdb VS Code Extension supports multiple concurrent connections, allowing you to work against different q processes, KDB-X runtimes, or kdb Insights Enterprise deployments at the same time. Connections may be used for executing q, Python, or SQL code depending on the backend.

Add connections

To add a connection, follow the steps below:

  1. Select the KX extension from the Activity Bar to display the CONNECTIONS view.

  2. If this is your first time using the extension, the list will be empty. Click Add Connection to create your first connection. Otherwise, if you have previously created connections, click + for New KX Connection in the CONNECTIONS menu.

    connecttoakdbserver

  3. The opens the Add a new connection screen opens. It includes a tab for each of the connection types.

    • My q: This is an unmanaged q session and is a connection to a local or remote q process.
    • Insights: This accesses kdb Insights Enterprise API endpoints and a user-specific scratchpad process within a kdb Insights Enterprise deployment.

  4. Configure the required properties for the selected connection type.

Once saved, the connection appears in the Connections list and becomes available as an execution target for scripts, REPL sessions, data sources, and workbooks.

Edit connections

To edit an existing connection, right-click the connection you wish to edit and select the Edit connection option.

Edit connection option

Note

If you edit a connection that is currently active, the extension may need to temporarily disconnect it. After saving your changes, you will be prompted to reconnect.

Next steps