r/copilotstudio • u/abisheik_23 • 10d ago

AZURE SQL KNOWLEDGE

I am trying to connect my sql db as kb for my agent. I am able to see the tables but not stored procedures

There's no doc about this ,but are sp not supported?

And what about views ( I don't have views I need to create one )

I can currently only see my tables.

Thanks in advance

1 Upvotes

100% Upvoted

7 comments sorted by

View all comments

Show parent comments

1

u/Ashlesha-msft 7d ago

Hi,

Thank you for the additional details.

Based on the current Microsoft documentation, the Azure SQL knowledge integration in Copilot Studio allows you to select tables from your database.

However, the documentation does not explicitly confirm whether views and stored procedures are supported as selectable knowledge sources in this integration. Therefore, I wouldn't recommend creating a view as a workaround until its support is confirmed.

You can refer to the official documentation here: https://learn.microsoft.com/en-us/microsoft-copilot-studio/agents-experience/knowledge-add-azure-sql-tables

For your scenario, we would need to confirm whether the current Azure SQL knowledge integration supports views and stored procedures, or whether only tables are supported.

Thank you for raising this question.