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 "Install 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 ServerWhat 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?"