SQLite Geography Server
<!-- @format -->
For the sqlite_server project:
Here's a comprehensive list of questions/queries you can ask Claude's desktop app to trigger these MCP tools:
🌍 Country Exploration
Basic Country Searches
"Find countries with 'United' in the name"
"Search for countries containing 'Stan'"
"What countries have 'Republic' in their name?"
"Show me countries with 'Island' in the name"
"Find all countries that start with 'A'"
Specific Country Information
"Tell me about the United States"
"Get information about Japan"
"What's the capital of France?"
"Show me details about Brazil"
"Get country information for Germany"
Regional Queries
"What countries are in Europe?"
"Show me all African countries"
"List countries in Asia"
"What countries are in North America?"
"Find countries in Oceania"
Currency-Based Queries
"What countries use the Euro?"
"Which countries use the US Dollar?"
"Show me countries that use the British Pound"
"What countries have their own currency called 'Dollar'?"
"Find countries using the Japanese Yen"
🏙️ City Exploration
City Searches
"Find cities named London"
"Search for cities with 'New' in the name"
"What cities are called Paris?"
"Show me cities named Alexandria"
"Find cities that start with 'San'"
Country-Specific City Queries
"What are the major cities in the United States?"
"Show me cities in Japan"
"List cities in the United Kingdom"
"What cities are in Canada?"
"Find cities in Australia"
Geographic Location Queries
"What cities are near coordinates 40.7, -74.0?" (New York area)
"Find cities near London's coordinates"
"Show me cities around 48.8, 2.3" (Paris area)
"What cities are near 35.6, 139.7?" (Tokyo area)
"Find cities close to 51.5, -0.1" (London coordinates)
📍 State/Province Exploration
State Searches
"Find states with 'New' in the name"
"Search for states containing 'Carolina'"
"What states have 'Island' in their name?"
"Show me states that start with 'M'"
"Find provinces with 'British' in the name"
Country-Specific State Queries
"What states are in the United States?"
"Show me provinces in Canada"
"List states in Australia"
"What administrative divisions does Germany have?"
"Find states in Brazil"
🗺️ Regional Analysis
Region Exploration
"What are all the world regions?"
"Show me the different regions of the world"
"List all continental regions"
"What subregions exist?"
"How is the world divided into regions?"
Subregion Queries
"What subregions are in Asia?" (region_id 3)
"Show me European subregions" (region_id 4)
"What are the subregions of Africa?" (region_id 1)
"List American subregions" (region_id 2)
📊 Statistical and Summary Queries
Database Statistics
"How many countries are in the database?"
"What are the database statistics?"
"Give me a count of all the data"
"How many cities and countries do you have?"
"What's the total amount of geographical data?"
TDQS
Scored across 15 tools
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.
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.
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.
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.