{"serverId":"mcp-registry/com.sidecardata/sidecar","tools":[{"name":"advanced_search","fixed":{"name":"advanced_search","description":"Search for data assets using identifier matching, keyword search, semantic similarity, or hybrid fusion.\n\nUse 'identifier' mode (default) when you know the asset name or a pattern (supports * wildcards).\nUse 'keyword' when searching by domain terms or metadata keywords.\nUse 'semantic' for natural language queries about what the data represents.\nUse 'hybrid' to combine all approaches for the best recall.\n\nReturns a ranked list of matching assets with identifiers, types, and relevance scores.","inputSchema":{"type":"object","required":["query"],"properties":{"mode":{"type":"string","default":"identifier","description":"Search mode. 'identifier' (default): exact/wildcard match on asset_identifier. 'keyword': full-text search over indexed keywords. 'semantic': vector similarity search. 'hybrid': fuses identifier + keyword + semantic results via RRF."},"tags":{"anyOf":[{"type":"array","items":{"type":"string"}},{"type":"null"}],"default":null,"description":"Filter to assets with any of these tags (OR semantics)."},"limit":{"type":"integer","default":20,"description":"Maximum number of results (1-50)."},"query":{"type":"string","description":"Search query. For identifier mode: asset name or wildcard pattern (e.g. 'fct_orders', 'stg_*', 'analytics.*customers'). For keyword/semantic/hybrid: natural language query (e.g. 'revenue metrics', 'user activity tracking')."},"tool_type":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"Filter to a specific tool. UPPERCASE, e.g. SNOWFLAKE, DBT_CLOUD, BIGQUERY."},"asset_type":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"Filter to a specific asset type. snake_case, e.g. snowflake_table, dbt_model."},"importance":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"Filter to a specific importance level: 'high', 'medium', or 'low'."}},"additionalProperties":false},"annotations":{"readOnlyHint":true}},"changes":[{"kind":"annotations","detail":"Added readOnlyHint: true (inferred from the name).","verify":true}],"tokensBefore":542,"tokensAfter":542},{"name":"calculate_downstream_impact","fixed":{"name":"calculate_downstream_impact","description":"Find everything downstream of a data asset — tables, dashboards, and reports that would\nbreak or be affected if this asset changes.\n\nCall this automatically after the user modifies any SQL file, dbt model, or source definition,\nor whenever they ask 'what depends on X?' or 'what breaks if I change Y?'\n\nReturns a breakdown of affected assets by tool type and a full list of downstream nodes.","inputSchema":{"type":"object","required":["asset_identifier"],"properties":{"max_depth":{"type":"integer","default":5,"description":"Downstream depth to traverse for impact analysis."},"tool_type":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"Optional tool/source hint (e.g., DBT_CLOUD, SNOWFLAKE)."},"asset_identifier":{"type":"string","description":"Asset name or Sidecar asset identifier to analyze (e.g., 'fct_reviews' or 'model.jaffle_shop.fct_reviews')."}},"additionalProperties":false},"annotations":{"readOnlyHint":true}},"changes":[{"kind":"annotations","detail":"Added readOnlyHint: true (inferred from the name).","verify":true}],"tokensBefore":271,"tokensAfter":271},{"name":"describe_asset","fixed":{"name":"describe_asset","description":"Fetch detailed information about a data asset by its identifier.\n\nResolves the asset, then fetches the requested sections in parallel. Use this after\nadvanced_search or resolve_asset_id to get deeper information about a specific asset.\n\nSections:\n- overview: asset description, importance, owner, metadata\n- columns: full column schema with types and descriptions\n- tests: dbt test coverage (only for assets with a dbt parent)\n- context_counts: cheap count of linked tickets and Slack threads\n- ticke","inputSchema":{"type":"object","required":["asset_identifier","include"],"properties":{"include":{"type":"array","items":{"type":"string"},"description":"Which sections to fetch. One or more of: 'overview' (description, importance, owner), 'columns' (schema), 'tests' (dbt test coverage), 'context_counts' (ticket/slack counts), 'tickets' (full ticket content), 'slack' (full slack thread content). Pick only what you need to keep payloads small."},"tool_type":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"Optional tool/source hint to disambiguate (e.g. SNOWFLAKE, DBT_CLOUD)."},"asset_identifier":{"type":"string","description":"Asset name or Sidecar asset identifier (e.g. 'fct_orders' or 'model.jaffle_shop.fct_orders')."}},"additionalProperties":false},"annotations":{"readOnlyHint":true}},"changes":[{"kind":"annotations","detail":"Added readOnlyHint: true (inferred from the name).","verify":true}],"tokensBefore":372,"tokensAfter":372},{"name":"get_catalog_overview","fixed":{"name":"get_catalog_overview","description":"Get a summary of everything available in this customer's Sidecar catalog.\n\nReturns the connected tools (e.g. SNOWFLAKE, DBT_CLOUD, LOOKER), asset type breakdown\nwith counts, all available tag names, and a customer-provided company summary describing\nthe company's domain and data landscape (if set).\n\nCall this at the start of any open-ended exploration (e.g. 'what data do we have?',\n'show me all Snowflake tables'), or when a search returns no results and you need to\nunderstand what's actually in ","inputSchema":{"type":"object","properties":{},"additionalProperties":false},"annotations":{"readOnlyHint":true}},"changes":[{"kind":"annotations","detail":"Added readOnlyHint: true (inferred from the name).","verify":true}],"tokensBefore":176,"tokensAfter":176},{"name":"get_column_lineage","fixed":{"name":"get_column_lineage","description":"Trace column-level lineage — which upstream columns feed into a column and which downstream columns consume it.\n\nUse this when the user asks 'where does this column come from?', 'what columns feed into X.col?',\nor needs to understand column-level data flow.\n\nReturns the target column, upstream columns (with levels), and downstream columns (with levels).","inputSchema":{"type":"object","required":["asset_identifier","column_name"],"properties":{"tool_type":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"Optional tool/source hint (e.g., DBT_CLOUD, SNOWFLAKE) to disambiguate when multiple assets share the same identifier."},"column_name":{"type":"string","description":"The column name to trace lineage for (case-insensitive)."},"upstream_depth":{"type":"integer","default":1,"description":"Levels of upstream column lineage to include."},"asset_identifier":{"type":"string","description":"Asset name or Sidecar asset identifier (e.g., 'fct_orders' or 'model.jaffle_shop.fct_orders')."},"downstream_depth":{"type":"integer","default":1,"description":"Levels of downstream column lineage to include."}},"additionalProperties":false},"annotations":{"readOnlyHint":true}},"changes":[{"kind":"annotations","detail":"Added readOnlyHint: true (inferred from the name).","verify":true}],"tokensBefore":337,"tokensAfter":337},{"name":"get_context_repo","fixed":{"name":"get_context_repo","description":"Return the clean OSI semantic contract currently deployed to this MCP token's Context Garage surface.","inputSchema":{"type":"object","properties":{},"additionalProperties":false},"annotations":{"readOnlyHint":true}},"changes":[{"kind":"annotations","detail":"Added readOnlyHint: true (inferred from the name).","verify":true}],"tokensBefore":62,"tokensAfter":62},{"name":"get_knowledge_base_file_content","fixed":{"name":"get_knowledge_base_file_content","description":"Fetch the full text content of a file from the customer's knowledge base.\n\nUse this after calling list_knowledge_base_files to get file IDs. Works with any file in\nthe knowledge base — playbooks, metric definitions, nuances, or captured context summaries.","inputSchema":{"type":"object","required":["file_id"],"properties":{"file_id":{"type":"string","description":"UUID of the knowledge base file to retrieve. Get file IDs from list_knowledge_base_files."}},"additionalProperties":false},"annotations":{"readOnlyHint":true}},"changes":[{"kind":"annotations","detail":"Added readOnlyHint: true (inferred from the name).","verify":true}],"tokensBefore":153,"tokensAfter":153},{"name":"list_knowledge_base_files","fixed":{"name":"list_knowledge_base_files","description":"List all files in the customer's knowledge base.\n\nThe knowledge base contains company-specific reference material — playbooks, metric definitions,\nbusiness nuances, and conventions — uploaded by the customer's team.\n\nReturns file names, paths, types, and IDs. Pass a file ID to `get_knowledge_base_file_content`\nto read its content. Use the optional folder_path parameter to narrow results to a specific folder.","inputSchema":{"type":"object","properties":{"folder_path":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"Optional folder path to filter results (e.g. '/Playbooks', '/Metrics and Drivers'). When omitted, returns all files across the entire knowledge base."}},"additionalProperties":false},"annotations":{"readOnlyHint":true}},"changes":[{"kind":"annotations","detail":"Added readOnlyHint: true (inferred from the name).","verify":true}],"tokensBefore":219,"tokensAfter":219},{"name":"resolve_asset_id","fixed":{"name":"resolve_asset_id","description":"Look up any data asset by name across the full catalog (dbt, Snowflake, BigQuery, Looker, etc.).\n\nReturns the asset's columns, description, owner, tags, and its **Sidecar asset identifier**\n(`asset_identifier` field) — the fully-qualified internal name used by lineage and impact tools\n(e.g. `model.jaffle_shop.fct_orders`, `PROD_DB.ANALYTICS.FCT_ORDERS`).\n\nWhen a single asset is resolved, the response also includes a `context_summary` with\ncounts of linked tickets (Jira/Linear) and Slack threads.","inputSchema":{"type":"object","required":["asset_name"],"properties":{"tool_type":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"Narrow to a specific tool. UPPERCASE, e.g. SNOWFLAKE, DBT_CLOUD, DBT_CORE, BIGQUERY, LOOKER, METABASE, FIVETRAN, POWER_BI, REDSHIFT. Call get_catalog_overview to see which tools are connected for this customer."},"asset_name":{"type":"string","description":"Name or query for the asset to look up. Plain name ('fct_reviews'), wildcard ('fct_*'), or filters inline ('fct_reviews tool_type:SNOWFLAKE', 'tag:finance'). Filter keys: tool_type (UPPERCASE, e.g. SNOWFLAKE, DBT_CLOUD, BIGQUERY), asset_type (snake_case, e.g. snowflake_table, dbt_model), tag (exact tag name). Call get_catalog_overview to see all valid values for this customer."},"asset_type":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"description":"Narrow to a specific asset type. snake_case, e.g. snowflake_table, dbt_model, dbt_source, looker_dashboard. Call get_catalog_overview to see all asset types present for this customer."}},"additionalProperties":false},"annotations":{"readOnlyHint":true}},"changes":[{"kind":"annotations","detail":"Added readOnlyHint: true (inferred from the name).","verify":true}],"tokensBefore":460,"tokensAfter":460}],"toolsChanged":9,"tokensSaved":0,"todo":[],"note":"Deterministic fixes. Changes marked verify need a human look before shipping (renames, inferred annotations, inferred types, removed text). Parameter descriptions in `todo` need to be written by someone who knows the API."}