dbt MCP server updates! (2025-10-02)

[b-per]

🚀 We've shipped quite a bit in this repo since the last update in August and here is a summary of the new features and improvements:

🌟 Major Features:

• dbt-codegen Integration - New MCP toolset for code generation (thanks @Muizzkolapo!)
• Error Handling - Now fully compliant with MCP spec (thanks @AjmeraParth132!)
• Initial OAuth Support - We will soon allow people to authenticate with their dbt account without previously creating a service token or personal access token

🛠️ New Tools:

• get_job_run_error - Retrieve and parse job run errors to surface the most relevant information (looking at run_results.json if present and at logs otherwise)
• get_metrics_compiled_sql - Get compiled SQL for Semantic Layer metrics. Instead of using th Semantic Layer to query the Data Warehouse, you can run this SQL from your side
• get_exposures and get_exposure_details - Get information from the Discovery API
• --vars and --full-refresh flag support for CLI tools
• Search parameter for Semantic Layer metadata

🧠 Context Management:

We're increasingly focused on providing LLMs with the most valuable information without overwhelming the context window - smarter, not just more data!

🐛 Key Fixes:

• Windows timeout fix (thanks @adammacleod!)
• Claude Desktop triggering multiple OAuth flows when testing OAuth
• Updated logic for CLI tools to identify the type of executable (Core, Fusion, Cloud CLI) being configured

🙌 Community Contributors:

Huge thanks to @jairus-m , @Muizzkolapo, @WilliamDee, @adammacleod, @AjmeraParth132, @xrpza and @VDFaller!

And of course, Coalesce!

For the people joining us at Coalesce, remember to sign up to the dbt MCP Hackathon to join other community members and build something amazing together!