jwest33/mcp_snowflake_dbt
If you are the rightful owner of mcp_snowflake_dbt and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
MCP dbt-Snowflake Server is designed to automate analytics engineering by integrating dbt with Snowflake.
Tools
Functions exposed to the LLM to take actions
discover_sources
Discovers available schemas and tables in Snowflake with pattern matching capabilities.
profile_table_tool
Provides comprehensive statistical analysis of a table including column profiles, data samples, and candidate keys.
infer_keys_tool
Identifies primary key candidates using statistical analysis including uniqueness, null ratios, and naming conventions.
build_join_map_tool
Discovers relationships between tables using Jaccard similarity on column values.
propose_model_plan
Suggests optimal modeling strategy based on table profile and user intent.
generate_dbt_project
Creates complete dbt project structure with profiles, configurations, and documentation.
generate_models
Generates staging, intermediate, and mart models based on profiling and planning.
run_dbt_tool
Executes dbt commands with full audit trail and error handling.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client