Skip to main content
Glama
pdichone

SQLite Geography Server

by pdichone
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault

No arguments

Instructions

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

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

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

Tools

Functions exposed to the LLM to take actions

NameDescription
search_countriesB
Search for countries by name.

Args:
    name: Country name to search for (partial matches allowed)

Returns:
    List of countries matching the search
get_countriesB
Simple country search by name.

Args:
    name: Country name to search for. This is optional. Default, return all countries from the database.

Returns:
    List of matching countries
get_countryC
Get detailed information about a specific country.

Args:
    country_code: Two-letter ISO country code (e.g., "US", "GB", "FR")

Returns:
    Complete country information
get_countries_by_regionC
Get all countries in a specific region.

Args:
    region: Region name (e.g., "Europe", "Asia", "Africa")

Returns:
    List of countries in the region
get_countries_by_currencyA
Find all countries that use a specific currency.

Args:
    currency: Currency code (e.g., "USD", "EUR", "GBP")

Returns:
    List of countries using the currency
search_citiesA
Search for cities by name and optionally filter by country.

Args:
    name: City name to search for (partial matches allowed)
    country_code: Two-letter country code to filter by (optional)

Returns:
    List of cities matching the search criteria
get_cities_in_countryA
Get cities in a specific country.

Args:
    country_code: Two-letter country code (e.g., "US", "GB", "FR")
    limit: Maximum number of cities to return (default 50)

Returns:
    List of cities in the country
search_statesB
Search for states/provinces by name and optionally filter by country.

Args:
    name: State/province name to search for (partial matches allowed)
    country_code: Two-letter country code to filter by (optional)

Returns:
    List of states/provinces matching the search criteria
get_states_in_countryA
Get all states/provinces in a specific country.

Args:
    country_code: Two-letter country code (e.g., "US", "CA", "AU")

Returns:
    List of states/provinces in the country
get_all_regionsB
Get all world regions.

Returns:
    List of all regions
get_subregions_in_regionB
Get all subregions within a specific region.

Args:
    region_id: The ID of the parent region

Returns:
    List of subregions in the region
get_database_statsB
Get statistics about the database contents.

Returns:
    Dictionary with counts of countries, cities, states, regions, and subregions
get_countries_summaryA
Get a summary of all countries with basic information.

Returns:
    List of countries with just name, code, capital, and region
get_popular_currenciesA
Get the most commonly used currencies and how many countries use them.

Returns:
    List of currencies with usage counts, ordered by popularity
get_top_chattersB

Retrieve the top chatters sorted by number of messages.

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Deploy Server
One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

TDQS

B3.4/5.0

Scored across 15 tools

Disambiguation3/5

search_countries and get_countries overlap almost entirely—both search by name with partial matches, and get_countries even defaults to all countries. get_countries_summary also returns country lists, so an agent could easily pick the wrong tool, though other tools are distinct.

Naming Consistency5/5

All 15 tools use snake_case with a consistent verb_noun structure (get_, search_). The pattern is predictable and readable throughout, including the odd get_top_chatters.

Tool Count4/5

15 tools is a reasonable count for a geography database covering countries, cities, states, regions, and currencies. However, get_top_chatters is out of scope and a couple of country-listing tools are redundant.

Completeness4/5

Core geography entities are well covered with search and list operations for countries, cities, states, and regions. Minor gaps include no dedicated get_city, get_state, or get_region detail endpoints, but search functions largely compensate.

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources