[{'Text': 'Found 4 matches:\n\n## Matches in point-topic-mcp/src/point_topic_mcp/context/datasets/tariffs.py\n\n### L49-59\n```\nDB_SCHEMA = """\nresearch.reports.rpt_tariff (\n    tariff_id varchar comment \'unique identifier for tariff snapshot\',\n    group_id varchar comment \'persistent identifier across periods for change tracking\',\n    operator varchar comment \'isp name (global data, varies from upc naming)\',\n    date timestamp_ntz comment \'report date\',\n    period varchar comment \'quarterly period (e.g. 2024Q1)\', \n    country varchar comment \'country (filter: United Kingdom for uk data)\',\n    domain varchar comment \'residential/business\',\n    name varchar comment \'tariff/plan name\',\n    tech varchar comment \'technology (can be comma-separated)\',\n```\n\n43 lines remaining in ancestor node. Read the file to see all.\n\n### L126-136\n```\n    {\n        \'request\': \'Compare average broadband pricing across UK regions\',\n        \'response\': """\nselect \n    u.government_region,\n    count(distinct t.tariff_id) as available_plans,\n    round(avg(t.monthly_subscription), 2) as avg_monthly_price,\n    round(min(t.monthly_subscription), 2) as cheapest_plan\nfrom upc_client._src_research_app.upc_tariffs_time_series t\njoin upc_client._src_research_app.upc_tariff_postcode_time_series tp using (tariff_id, period)\njoin upc_core.reports.upc_output u using (postcode)\n```\n\n7 lines remaining in ancestor node. Read the file to see all.\n\n## Matches in point-topic-mcp/src/point_topic_mcp/context/datasets/upc_take_up.py\n\n### L91-95\n```\n   - rpt_all_quarterly_results_*: one row per postcode/operator/tech/quarter\n   - OMITS rows where lines=0 (no presence = no row)\n   - use for time-series, aggregations across periods\n\nCRITICAL: ZERO-LINE HANDLING\n```\n\n## Matches in point-topic-mcp/src/point_topic_mcp/tools/server_info_tools.py\n\n### def get_mcp_server_capabilities › L66-70\n```\n    Environment Variables Guide:\n    • SNOWFLAKE_USER + SNOWFLAKE_PASSWORD → Database tools (execute_query, assemble_dataset_context, etc.)\n    • GITHUB_TOKEN → GitHub organization tools (search_issues_across_org, create_issue, etc.)\n    • PT_RESEARCH_DATABASE_URI → GBS tools (list_operators, get_gbs_status, add_statistic, create_source)\n    • CHART_API_KEY → Authenticated chart generation (generate_authenticated_chart_url)\n```\n'}]