Skip to main content
Glama

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MARKET_SQL_SERVER_URLNoThe connection string or URL for the SQL Server database.
MARKET_SQL_SERVER_USERNoThe username for SQL Server authentication.
MARKET_SQL_SERVER_DATABASENoThe database name to connect to.
MARKET_SQL_SERVER_PASSWORDNoThe password for SQL Server authentication.
MARKET_SQL_SERVER_TRUST_CERTNoWhether to trust the server certificate (e.g., 'true' or 'false').

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

Counts of UK companies registered in a period that are still live in one Companies House snapshot, or including those dissolved by the snapshot date, and the share not dissolved within a year. Always quote summary word for word and both must-quote caveats (answer holds all three together, for clients that pass on one field). Start the reply with them and keep any extra explanation brief. If the user asked for rows or a table, include the rows they asked for. If a bundle was used, say it is approximate and what it misses. Otherwise offer more detail (the rows, the other caveats, what the codes cover) rather than giving it unasked. Never state an exact number for a count shown as 'under 10 (rounded)' or 'too few to number for certain', and never work one out by subtracting other numbers. Answers about one area at a time are rounded estimates: putting them in order doesn't show which of the areas a breakdown leaves unnumbered truly has more companies. Always say which SIC codes an answer covers: the choice of codes can change the answer. If a code is rejected, ask the user which industry they meant; never answer for a different code in its place. To say which of two places has more or grew faster, use compare_two_areas, not two separate answers. For what is growing or shrinking in a place across all industries, use breakdown_by_industry. For how many companies are live in a place now, whatever year they were registered, use count_companies_live_now. For where most companies in an industry are, use largest_areas; for a place's biggest industries, use largest_industries. Never order places or industries yourself from separate answers or breakdown rows. In a largest list, keep rows whose likely ranks overlap together as a group in any order: never say one is next, follows or is ahead of another, and never call them tied. To ask whether more companies were registered or dissolved in a period, as in 'more opening than closing' or 'closing faster than they open', use registrations_against_closures: it compares counts in one period, and can't show whether closures are speeding up. For everyday industries (AI, e-commerce, coffee shops, barbers...), find_sic offers ready-made bundles: pass the bundle id in sic_codes and tell the user it is approximate and what it misses. Regions and nations (London, North West, Wales, Scotland and so on) work in the count and compare tools: find them with find_area. Never add up council areas yourself; ask for the region or nation. This data can't answer some questions; say so and name the source instead of offering a figure from here as if it answered them: sole traders and partnerships (the government's yearly 'Business population estimates for the UK and regions', which are estimates); yearly business births and deaths before 2021, or of businesses rather than companies (ONS 'Business demography, UK'); businesses trading now (ONS 'UK business: activity, size and location', which counts VAT- or PAYE-registered businesses, a stand-in for those trading). Postcode or street level isn't available, to protect single companies: offer the council area.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": false
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}

Tools

Functions exposed to the LLM to take actions

NameDescription
find_sicB

Find SIC 2007 codes for an industry. Everyday words (AI, coffee shop, barber, e-commerce) first return ready-made bundles: approximate code sets, with what they include and miss. Pass a bundle's id in sic_codes and say it is approximate. Then codes for that activity, then codes whose description contains the words (whole words, up to 15, sorted by code, not relevance: keep only the ones for the activity asked about), then their 3-digit groups. For a broad industry ("cleaning"), pass the group code (e.g. "812") so every code in it is counted. Name the codes you used in your answer.

find_areaA

Find areas by name, matching from the start of any word: regions and nations first (London means all 33 London council areas; the City of London is one small council area), then local authority districts (England, Wales, Scotland). A county isn't an area here, so a county's name may find one district in it: check the name. Northern Ireland has no area breakdown.

count_incorporations_still_liveA

Count companies (private limited, PLC and LLP) registered in the period with these primary SIC codes that are still live in the snapshot, or with include_closed the companies in this data registered, including those dissolved by the snapshot date (use this to compare periods fairly). Area answers leave out formation-agent postcodes.

compare_area_with_great_britainA

One-call brief: is this industry growing faster or slower in this area than across Great Britain? Compares a period (default the latest four quarters) with the same quarters a year before, or the period just before: the area's count, Great Britain's, the area's share of GB with a significance test, how concentrated the industry is here (location quotient), and the quarterly trend. Formation-agent addresses are left out on both sides. If you picked this area from rank_areas_against_great_britain, quote the ranking's verdict instead: this tool tests one area on its own. To say which of two areas grew faster, use compare_two_areas.

compare_two_areasA

Head to head: which of two places has more new companies in this industry, and which grew faster? Gives each area's count for a period (default the latest four quarters) and the earlier one, a test of whether one has more, and a test of whether one area's share of the two together changed (that is, one grew faster, or fell less if it fell). Both tests allow for rounding. Formation-agent addresses are left out.

rank_areas_against_great_britainA

Hotspots: in which council areas did this industry's share of Great Britain's new companies rise (or fall) most, in a period (default the latest four quarters) against an earlier one (see against)? Every area is tested, so the bar for "stands out" is raised to allow for testing hundreds of areas at once. Only areas that stand out are listed, strongest evidence first. Areas without at least 10 companies for certain in both periods aren't tested. Counts include companies dissolved since, so an area isn't made to look like a hotspot by closures in the older period. This doesn't say which area grew fastest: an area missing from the rows may have grown as fast on less evidence. To check one named area, use compare_area_with_great_britain.

breakdown_by_industryA

What's growing here? New companies in every 2-digit SIC industry division (plus no activity stated) for a period (default the latest four quarters) against an earlier one, with a test of each change and, for an area, the same test across Great Britain. Every division is tested, so the bar for a clear change is raised for testing them all at once. Rows are in SIC order, not by size. Counts are shown only for divisions with a clear change, and even those rounded counts don't reliably show which division is bigger or moved more: don't rank divisions. Formation-agent addresses are left out of area answers.

count_companies_live_nowA

How crowded is it? Count companies (private limited, PLC and LLP) with these primary SIC codes that are live (not dissolved) in the snapshot, whatever year they were registered. Live includes companies that don't trade. Rows split it into those registered before 2021 and since. Area answers leave out formation-agent postcodes.

registrations_against_closuresA

Were more companies registered or dissolved? In one place (default the UK) and period (default the latest four quarters), compares companies registered with companies dissolved, whatever year those were registered, and tests which was higher, allowing for rounding. A period under a year gets the counts but no verdict, because closures come in weekly batches. It can't show whether closures are speeding up. Area answers leave out formation-agent addresses.

largest_areasA

Where are most of these companies? The council areas (or regions and nations) of Great Britain with the most companies registered with these codes in a period (default the latest four quarters), largest first, each with a likely range and a likely rank. Size, not growth: for where an industry is growing, use rank_areas_against_great_britain. Formation-agent addresses are left out.

largest_industriesA

Which industries are biggest here? The 2-digit SIC industry divisions (plus no activity stated) with the most companies registered in a place in a period (default the latest four quarters), largest first, each with a likely range and a likely rank. Size, not growth: for what is growing, use breakdown_by_industry. Area answers leave out formation-agent addresses.

one_year_survivalA

Of the companies registered in the period with these primary SIC codes, what share were not dissolved within a year? For one area, compares it with the rest of Great Britain with a significance test; for 'UK', gives the national rate and lists the council areas whose rate passes a test for a difference (the bar is raised for testing hundreds of areas). Only quarters whose companies have all had a full year are allowed.

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

TDQS

A3.9/5.0

Scored across 12 tools

Disambiguation4/5

Most tools have clearly distinct analytical purposes, and descriptions explicitly cross-reference alternatives (e.g. largest_areas vs rank_areas_against_great_britain, breakdown_by_industry vs largest_industries). The main overlap is among the counting tools: count_incorporations_still_live, count_companies_live_now, and registrations_against_closures address similar-sounding company counts but differ in period and live/dissolved treatment.

Naming Consistency4/5

All names are snake_case and mostly follow a verb_noun or action-object pattern (find_sic, find_area, count_*, compare_*, rank_*). A few are noun phrases rather than actions (breakdown_by_industry, registrations_against_closures, largest_areas, one_year_survival), but the overall convention remains readable and predictable.

Tool Count5/5

Twelve tools is well scoped for a focused market-intelligence server covering lookups, counts, comparisons, rankings, and survival analysis. Each tool appears to earn its place without obvious redundancy.

Completeness4/5

The surface covers the core workflow well: finding SIC codes and areas, counting live/registered/dissolved companies, comparing areas and industries, ranking hotspots, and survival analysis. Minor gaps remain around explicit time-series exploration and custom multi-area or multi-industry comparisons, but agents can work around them using the existing comparison tools.

Maintenance

ActivityMaintained
ResponsivenessNo recent community issues