F
licenseNot graded
qualityD
maintenanceProvides tools to retrieve and compare detailed information about countries, including population, region, and currency data. It allows users to search for specific countries or list them by region.
-
SQLite Geography Server
by pdichone
Provides tools for querying geographical data stored in SQLite databases, enabling search and retrieval of information about countries, cities, states/provinces, regions, and their associated metadata like currencies, coordinates, and administrative divisions.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@SQLite Geography Server What countries are in Europe?"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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?"
Available Tools
15 toolsget_all_regionsB
Get all world regions.
Returns:
List of all regions
Inputs: no named parameters. Returns: result
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
Inputs: country_code (required), limit. Returns: result
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
Inputs: name. Returns: result
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
Inputs: currency (required). Returns: result
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
Inputs: region (required). Returns: result
get_countries_summaryA
Get a summary of all countries with basic information.
Returns:
List of countries with just name, code, capital, and region
Inputs: no named parameters. Returns: result
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
Inputs: country_code (required). Returns: result
get_database_statsB
Get statistics about the database contents.
Returns:
Dictionary with counts of countries, cities, states, regions, and subregions
Inputs: no named parameters. Returns: result
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
Inputs: no named parameters. Returns: result
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
Inputs: country_code (required). Returns: result
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
Inputs: region_id (required). Returns: result
get_top_chattersB
Retrieve the top chatters sorted by number of messages.
Inputs: no named parameters.
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
Inputs: name, country_code. Returns: result
search_countriesB
Search for countries by name.
Args:
name: Country name to search for (partial matches allowed)
Returns:
List of countries matching the search
Inputs: name. Returns: result
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
Inputs: name, country_code. Returns: result
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
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.
Related MCP Connectors
Look up any country's capital, population and borders, or play geography quizzes with your AI.
Geodata for any place, inside your agent: map data, terrain, routes, satellite images, GIS files.
Search and explore a global travel points-of-interest catalog (cities, countries, POIs).
Free GeoNames MCP: countries, cities, POIs, distance & nearby. Remote HTTP + agent token signup.
Related MCP Servers
- AlicenseBqualityDmaintenanceProvides access to the GeoDB Cities API for retrieving global geographic data including city details, populations, and local time. It enables users to find nearby locations, calculate distances between places, and browse administrative divisions across countries.18MIT
- AlicenseNot gradedqualityBmaintenanceProvides complete world location data (countries, states, cities) as an MCP server for AI assistants, enabling search and retrieval of geographic information through 11 tools and 5 resources.1,399 npm1MIT
- AlicenseAqualityCmaintenanceServes country facts, administrative boundary GeoJSON, and per-region population, area, and capital statistics as structured data, letting an AI assistant build interactive maps, comparisons, and multilingual geography content instead of reciting prose. It also normalises region names across sources so boundary shapes can be joined to their statistics.3MIT