dbt-mcp

# Changelog All notable changes to this project will be documented in this file. The format is based on [Keep a Changelog](https://keepachangelog.com/en/1.0.0/), adheres to [Semantic Versioning](https://semver.org/spec/v2.0.0.html), and is generated by [Changie](https://github.com/miniscruff/changie). ## v0.10.3 - 2025-10-08 ### Under the Hood * Improved retry logic and post project selection screen * Avoid double counting in usage tracking proxied tools * Categorizing ToolCallErrors ## v0.10.2 - 2025-10-08 ### Enhancement or New Feature * Improved oauth error handling * Remove oauth env var feature flag. Enable oauth broadly. ### Under the Hood * Improved logging for development * Updating prompts to include examples to avoid bad parameter generation * Remove DBT_HOST prefix * Update usage tracking with new fields * Write .user.yml if it does not exist * Changed UsageTracker to a protocol ## v0.10.1 - 2025-10-02 ### Bug Fix * Fix get_job_run_error truncated log output ## v0.10.0 - 2025-10-01 ### Enhancement or New Feature * Add get_job_run_error to Admin API tools ## v0.9.1 - 2025-09-30 ### Under the Hood * Reorganize code and add ability to format the arrow table differently ## v0.9.0 - 2025-09-30 ### Enhancement or New Feature * Adding the dbt codegen toolset. ### Under the Hood * Updates README with new tools * Fix .user.yml error with Fusion ## v0.8.4 - 2025-09-29 ### Enhancement or New Feature * Allow doc files to skip changie requirements ### Under the Hood * Upgrade @vitejs/plugin-react * Add ruff lint config to enforce Python 3.9+ coding style * Opt-out of usage tracking with standard dbt methods ## v0.8.3 - 2025-09-24 ### Under the Hood * Rename SemanticLayerConfig.service_token to SemanticLayerConfig.token ### Bug Fix * Fix Error handling as per native MCP error spec ## v0.8.2 - 2025-09-23 ### Enhancement or New Feature * Use `dbt --help` to identify binary type * Increase dbt CLI timeout default ### Under the Hood * Implement SemanticLayerClientProvider ### Bug Fix * Update how we identify CLIs ## v0.8.1 - 2025-09-22 ### Under the Hood * Create ConfigProvider ABC ## v0.8.0 - 2025-09-22 ### Enhancement or New Feature * Allow creating pre-releases * Return compiled code in get_model_details ### Under the Hood * Handle Claude Desktop running multiple MCP server instances * Add docs for using the MCP server with google ADK and dbt-core * Add search string to SL metadata queries * Improve parameters in query_metrics examples * Reduce token usage in `get_job_run_details` response by removing debug param and unnecessary logs * Automatically refresh oauth token * Improve dbt platform context mcp.yml parsing * Add PR and issue templates * Address claude desktop re-triggering oauth on exit * Turning off caching for static files ### Bug Fix * Add account id to dbt platform context ## v0.7.0 - 2025-09-09 ### Enhancement or New Feature * Add tools to retrieve exposure information from Disco API ### Under the Hood * Expect string sub in oauth JWT * Using sync endpoints for oauth FastAPI server * Fix release pipeline ## v0.6.2 - 2025-09-08 ### Enhancement or New Feature * Adding the ability to return the config.meta attribute from list metrics to give the LLM more context * Oauth initial implementation * Fix #251 - Add flag for no color + ability to detect binary type ### Under the Hood * Add docs for using the MCP server with Pydantic AI * Don't run mypy on examples ## v0.6.1 - 2025-08-28 ### Enhancement or New Feature * Add support for --vars flag * Allow headers in AdminApiConfig ### Under the Hood * Remove redundant and outdated documentation ## v0.6.0 - 2025-08-22 ### Under the Hood * Update docs with new tools * Using streamable http for SQL tools * Correctly handle admin API host containing protocol prefix ## v0.5.0 - 2025-08-20 ### Enhancement or New Feature * Add support for --full-refresh flag * Adds a new tool to get model health (last run, tests, source freshness) from discovery API * Add operational/admin tools to interact with the dbt platform ### Under the Hood * LangGraph create_react_agent example * Make model_name optional for more discovery tools * Update example with OpenAI to show tool calls ### Bug Fix * Fix for timeout on Windows ## v0.4.2 - 2025-08-13 ### Enhancement or New Feature * Add default --limit to show tool ### Under the Hood * Define toolsets ### Bug Fix * Fix the prompt to ensure grain is passed even for non-time group by" ## v0.4.1 - 2025-08-08 ### Under the Hood * Upgrade dbt-sl-sdk ## v0.4.0 - 2025-08-08 ### Enhancement or New Feature * Tool policies * Added Semantic Layer tool to get compiled sql ### Under the Hood * Fix JSON formatting in README * Document dbt Copilot credits relationship ### Bug Fix * Make model_name of get_model_details optional ## v0.3.0 - 2025-08-05 ### Enhancement or New Feature * Add ToolAnnotations * Add alias field to GET_MODEL_DETAILS GraphQL query ### Under the Hood * Test remote tool equality * Fix initialization integration test * Refactor README * Rename Remote Tools to SQL Tools * Document Remote MCP * Improved Remote MCP instructions ### Bug Fix * Apply dbt_cli_timeout to all dbt commands ## v0.2.20 - 2025-07-25 ### Enhancement or New Feature * Allow for disabling CLI tools ### Under the Hood * Update codeowners * Improve DISABLE_TOOLS configuration * Remote MCP example * Add unit tests for env vars combinations * Add instructions for Claude Code in README * Add new example for OpenAI + HTTP Streamable MCP ## v0.2.19 - 2025-07-22 ### Under the Hood * Create list of tool names ## v0.2.18 - 2025-07-22 ### Enhancement or New Feature * Move env var parsing to pydantic_settings for better validation ### Under the Hood * Add integration test for server initialization ### Bug Fix * Fix SL validation error message when no misspellings are found ## v0.2.17 - 2025-07-18 ## v0.2.16 - 2025-07-18 ### Under the Hood * Adding the ability to exclude certain tools when registering * OpenAI responses example ## v0.2.15 - 2025-07-16 ### Under the Hood * Refactor sl tools for reusability * Update VSCode instructions in README ## v0.2.14 - 2025-07-14 ### Enhancement or New Feature * Make dbt CLI command timeout configurable ### Bug Fix * Allow passing entities in the group by ## v0.2.13 - 2025-07-11 ### Under the Hood * Decouple discovery tools from FastMCP ## v0.2.12 - 2025-07-09 ### Bug Fix * Catch every tool error and surface as string ## v0.2.11 - 2025-07-03 ### Bug Fix * fix order_by input ## v0.2.10 - 2025-07-03 ### Enhancement or New Feature * Upgrade MCP SDK ## v0.2.9 - 2025-07-02 ### Enhancement or New Feature * Decrease amount of data retrieved when listing models ### Under the Hood * OpenAI conversational analytics example * README updates * Move Discover headers to config ## v0.2.8 - 2025-07-02 ### Enhancement or New Feature * Raise errors if no node is selected (can also be configured) ### Bug Fix * Fix when people provide `DBT_PROJECT_DIR` as a relative path * Fix link in README ## v0.2.7 - 2025-06-30 ### Under the Hood * Timeout dbt list command * Troubleshooting section in README on clients not finding uvx * Update Discovery config for simpler usage ### Bug Fix * Fixing bug when ordering SL query by a metric ## v0.2.6 - 2025-06-16 ### Under the Hood * Instructing the LLM to more likely use a selector * Instruct LLM to add limit as an argument instead of SQL * Fix use of limit in dbt show * Indicate type checking ## v0.2.5 - 2025-06-06 ### Under the Hood * Small improvements to improve logging and code organization. * Move `--selector` to the code instead of the prompt * Cursor deeplink setup * Fix Cursor deeplinks * Fix Cursor env var mess up ### Bug Fix * Fix Discovery API config enablement ## v0.2.4 - 2025-06-03 ### Bug Fix * Add the missing selector argument when running commands ## v0.2.3 - 2025-06-02 ### Under the Hood * Fix release action to fetch tags ## v0.2.2 - 2025-06-02 ### Under the Hood * Update README to run the MCP server with uvx * Logging usage events * Improve remote tools error logging * Move create-release-tag to release Action * Update release process documentation ### Bug Fix * Fix typo in GH action to create release ## v0.2.1 - 2025-05-28 ### Under the Hood * Remove hatch from tag action * Manually triggering release ## v0.2.0 - 2025-05-28 ### Enhancement or New Feature * Using `--quiet` flag to reduce context saturation of coding assistants * Add a tool `get_model_children` * Added optional uniqueId parameter to model lookup methods for more precise model identification * Enable remote tools in production * Add selector for dbt commands * Set pre-changie value to 0.1.13 ### Under the Hood * Require changelog entries for each PR * Log Python version in install script * Update license to full Apache 2.0 text * Roll back installation script and instructions * Re-enable tests in CI * Refactor config for modularity * Document remote tools * Usage tracking scaffolding * Update docs to clarify service token permissions required * Increase remote tools timeout * Update release process for new versions * Point to the correct diagram in README * Install hatch in release process * Remove hatch from release process ### Bug Fix * Fix diagram according to feature set ## v0.1.3 and before * Initial releases before using changie