There isn't a single Dataverse table that stores everything related to a Copilot Studio agent. The tables used depend on the features you've enabled, such as transcripts, analytics, generative AI, and Omnichannel integration.
Some of the commonly used tables include:
Bot – Stores the agent metadata.
Bot Component – Stores topics, tools, and other agent components.
ConversationTranscript – Stores conversation transcripts between users and the agent.
ConversationScript – Stores conversation history and script-related information.
msdyn_copilotinteraction / msdyn_copilotevents – Stores Copilot interaction events and telemetry.
msdyn_copilottranscript – Stores transcript metadata.
msdyn_copilottranscriptdata – Stores the transcript content.
msdyn_copilotinteractiondata – Stores additional interaction payloads.
Keep in mind that not every environment will have all of these tables. The available tables depend on the Copilot Studio version, installed solutions, and enabled capabilities.
If your goal is to understand the complete Dataverse schema behind Copilot Studio, I can also provide a diagram showing how the core Bot, Conversation, Transcript, and Copilot tables relate to one another.
