S1:E3
Accelerate Data Engineering using MCP Tools
Host
Jonny DaenenGuest
Emil KrauseEmil Krause & Jonny Daenen explore how to accelerate dbt development by integrating MCP (Model Context Protocol) with Postgres and Cursor. Emil demonstrates how to solve a database bug by allowing AI agents to interact directly with databases.
They discuss the setup of a database MCP server, demonstrate its capabilities in troubleshooting data inconsistencies, and highlight the importance of understanding data even when using advanced tools. The conversation also touches on the potential pitfalls of using such tools and the need for technical expertise in leveraging them effectively.
Chapters
- 00:00Introduction: MCP + Postgres
- 02:20Demo: debugging salary percentiles
- 06:29Creating and testing dbt models
- 07:11Benefits and dangers of AI assistance
- 09:42Setting up Postgres MCP in Cursor
- 12:57Challenges & pitfalls
- 14:54MCP vs semantic models
- 17:16Other dev tasks
- 18:39Claude Desktop vs Cursor
- 19:59Summary

