gogo-backend-mcp

A lightweight MCP-powered backend for serving curated travel spots straight from model.spot. The FastMCP server in trip.py exposes tools that let any compatible client request the latest main attractions, supporting sites, and the top ten most popular destinations.

Features

• major_views, sub_views, and top_10_spots tools implemented via FastMCP.

• SQLAlchemy ORM mapped through model/spot.py with GeoAlchemy spatial support.

• Environment-driven configuration with .env plus sensible defaults in util/database.py.

Related MCP server: SQL Query MCP Server

Requirements

python -m pip install -r requirements.txt

Environment

Copy .env.example (if you create one) or create a .env file with at least:

DATABASE_URL=postgresql+psycopg://user:password@localhost/spot_db
LOG_LEVEL=INFO

util/database.py will fall back to postgresql+psycopg://postgres:password@localhost/spot_db when nothing is provided.

Database

• The app expects a PostgreSQL database with a public.spot table matching model.spot.Spot.

• The table requires the PostGIS extension for the location geometry column.

• Apply your own migrations or schema creation outside this service; SQLAlchemy will not auto-create tables here.

Running locally

python trip.py

The MCP server listens on stdio and exposes three async tools:

1. major_views – active spots with popularity > 3000.

2. sub_views – active spots with 1 < popularity < 3000.

3. top_10_spots – ten most popular active spots.

Each tool returns JSON data from the respective helper in src/action.py.

Logging

util/logging_setup.py configures a single console handler; change LOG_LEVEL or wrap calls with your own handlers if you need file logging.

MCP Setup

This project uses FastMCP to create an MCP server. The server exposes three tools that clients can call to retrieve travel spot data.

{
    "servers": {
        "trip-mcp": {
            "command": "uv",
            "args": [
                "--directory",
                "/{Project Parent Location}",
                "run",
                "trip.py"
            ],
            "env": {
            }
        }
        // add your MCP stdio servers configuration here
        // example:
        // "my-mcp-server": {
        //     "type": "stdio",
        //     "command": "my-command",
        //     "args": [],
        //     "env": {
        //         "TOKEN": "my_token"
        //     }
        // }
    }
}

gogo-backend-mcp6