How to programmatically connect a specific .sql file to a connection profile from another extension?

[EliothSinH]

❓ Question: How to programmatically connect a specific .sql file to a connection profile from another extension?

Hi! I'm developing a custom VS Code extension that interacts with .sql files and uses the vscode-mssql extension to run queries.

My goal is to:

• Open a .sql file
• Connect it to a specific MSSQL connection profile

Currently, I was trying to call the connect function from MSSQL extension like this:

const connectionUri = await mssqlExtension.exports.connect(connectionInfo);

However, this creates a virtual URI like vscode-mssql-adhoc://query0, which is not tied to the .sql file I opened.

What I would like to do is something like:

await mssqlExtension.exports.connect(fileUri, connectionInfo);

That way, the connection is explicitly associated with the file I opened, and the user can run queries without needing to manually select a connection through the Command Palette.

🙋‍♂️ My question

Is there a supported way to associate a connection profile with a specific .sql file programmatically?

Any guidance or clarification would be greatly appreciated. Thanks in advance!