[{'Text': '|----------|-------------|\n| `server_info_tools_get_mcp_server_capabilities` | Debug missing credentials |\n\n# Data Models\n\n## Snowflake (UPC_CORE database, REPORTS schema)\n\n| Table (prefix: `upc_core.reports.`) | Key Columns | Granularity |\n|--------------------------------------|-------------|-------------|\n| `upc_output` | postcode, premises, households, reported_at, la_name | Postcode |\n| `fact_operator` | postcode, operator, tech, reported_at | Postcode+operator+tech |\n| `upc_take_up` | operator, subscribers, reported_at | Operator+LA+period |\n| `upc_forecast` | operator, premises, year | Operator+year |\n| `tariffs` | operator, package_name, price | Operator+package |\n| `ontology` | tech_category, tech_subcategory, operator | Tech+operator |\n\n**CRITICAL**: `fact_operator` joins to `upc_output` can duplicate rows (multiple techs per postcode). Always deduplicate by postcode for operator footprint.\n\n## MongoDB (pt-research-app via Prisma)\n\n| Collection | Key Fields | Used By |\n|-----------|------------|---------|\n| `Operator` | name, country, technologies, _id | list_operators |\n| `Statistics` | operatorId, period, type, channel, domain, subscribers, tech | get_gbs_status, add_statistic |\n| `Sources` | operatorId, year, quarter, type, url, fileUrl | create_source |\n| `GlobalVariables` | isCurrent, ... | find_global_variables_current |\n\n# Environment Variables\n\n| Variable | Required For | Notes |\n|----------|-------------|-------|\n| `SNOWFLAKE_USER` | database_tools | Snowflake login |\n| `SNOWFLAKE_PASSWORD` | database_tools | Snowflake password |\n| `CHART_API_KEY` | chart_tools (disabled) | Charts API key |\n| `PT_RESEARCH_DATABASE_URI` | gbs_tools | MongoDB connection string |\n| `PT_RESEARCH_TLS_SKIP_VERIFY` | gbs_tools | Set to `1` to skip TLS verify |\n| `GITHUB_TOKEN` | github_tools | GitHub PAT |\n| `AUTH0_DOMAIN` | server_http | Default: `point-topic.eu.auth0.com` |\n| `AUTH0_CLIENT_ID` | server_http | Auth0 app client ID |\n| `AUTH0_CLIENT_SECRET` | server_http | Auth0 app secret |\n| `AUTH0_AUDIENCE` | server_http | Default: `https://point-topic-mcp.fastmcp.app/` |\n| `MCP_BASE_URL` | server_http | Public server URL |\n| `ADMIN_API_KEY` | stdio auth | Grants ptAdmin in local mode |\n\n# Adding New Features\n\n'}]