An end-to-end chain built live: a DreamFactory API over SQL Server, the DreamFactory MCP server, Claude Desktop to interrogate the data, and Canva to turn the answers into charts. Useful as an illustration of how far a governed API reaches once MCP is in place.
What you’ll learn
- Chaining a database API, MCP, an assistant and a design tool
- Interrogating SQL Server data from Claude Desktop
- Turning query results into finished charts
