The problem I’m having
I am setting up dbt Core and the MCP server in the local environment. Are Symantec Layer and SQL tools (Text To SQL) available as part of this setup?
The context of why I’m trying to do this
What I’ve already tried
I have configured the dbt-Core, MCP server. and the Claude MCP client. Enabled SEMANTIC_LAYER and SQL by setting DISABLE_SQL and DISABLE_SEMANTIC_LAYER to ‘False‘. Still seeing SEMANTIC_LAYER and SQL disabled in Claude MCP client log.
Some example code or error messages
Claude: claude_desktop_config.json
{
"mcpServers": {
"dbt": {
"command": "D:\\work\\ad_metric\\.venv\\Scripts\\uvx.exe",
"args": ["dbt-mcp"],
"env": {
"DBT_CLI_TIMEOUT": "120",
"DBT_PATH": "D:\\work\\ad_metric\\.venv\\Scripts\\dbt.exe",
"DBT_PROJECT_DIR": "D:\\work\\ad_metric",
"DBT_MCP_LOG_LEVEL": "DEBUG",
"DISABLE_SQL": "False",
"DISABLE_SEMANTIC_LAYER": "False",
"DISABLE_DISCOVERY": "False"
}
}
}
}
-------------
Claude: mcp-server-dbt.log
INFO [dbt_mcp.config.settings] Settings: {'dbt_host': None, 'dbt_mcp_host': None, 'dbt_prod_env_id': None, 'dbt_env_id': None, 'dbt_dev_env_id': None, 'dbt_user_id': None, 'dbt_account_id': None, 'dbt_token': None, 'multicell_account_prefix': None, 'host_prefix': None, 'dbt_lsp_path': None, 'dbt_project_dir': 'D:\\work\\ad_metric', 'dbt_path': 'D:\\work\\ad_metric\\.venv\\Scripts\\dbt.exe', 'dbt_cli_timeout': 120, 'dbt_warn_error_options': None, 'dbt_profiles_dir': None, 'disable_dbt_cli': False, 'disable_dbt_codegen': True, 'disable_semantic_layer': True, 'disable_discovery': True, 'disable_remote': None, 'disable_admin_api': True, 'disable_sql': True, 'disable_tools': [], 'disable_lsp': None, 'enable_tools': [], 'enable_semantic_layer': False, 'enable_admin_api': False, 'enable_dbt_cli': False, 'enable_dbt_codegen': False, 'enable_discovery': False, 'enable_lsp': False, 'enable_sql': False, 'do_not_track': None, 'send_anonymous_usage_data': None, 'file_logging': False, 'log_level': 'DEBUG'}