Postgis Yukon MCP

🚀 PostGIS MCP Server

A PostGIS tool MCP server implementation based on the fastMCP framework, which solves the problem of complex operations on PostGIS databases and provides standardized tool interfaces through the MCP protocol.

🚀 Quick Start

Installation

pip install -r requirements.txt

Configuration

Before using, you need to configure the PostGIS database connection information:

# src/config/database.py
DB_CONFIG = {
    "host": "localhost",
    "port": 5432,
    "database": "your_database",
    "user": "your_user",
    "password": "your_password"
}

Run the Service

python -m src.server

✨ Features

🌟 New Feature: Text-to-SQL

Now support querying the PostGIS database using natural language! No need to write complex SQL statements. Just describe your query requirements in Chinese or English.

Examples:

• "Query buildings within 500 meters of the coordinates 120.5, 30.2 in the table: buildings"
• "Create a 100-meter buffer for the table: roads"
• "Calculate the area of the table: parks"

For detailed information, please refer to the Text-to-SQL Documentation.

Project Introduction

This project uses the fastMCP framework to encapsulate PostGIS geospatial database tools and provides standardized tool interfaces through the MCP (Model Context Protocol).

Project Structure

yukon_mcp_service/
├── src/
│   ├── __init__.py           # Package initialization
│   ├── server.py             # Main entry of the MCP server
│   ├── tools/                # Tool module
│   │   ├── __init__.py
│   │   ├── spatial_query.py  # Spatial query tool
│   │   ├── geometry.py       # Geometric operation tool
│   │   └── analysis.py       # Spatial analysis tool
│   └── config/
│       ├── __init__.py
│       └── database.py       # Database configuration
├── tests/                    # Test files
│   ├── __init__.py
│   └── test_tools.py
├── pyproject.toml            # Project configuration
├── requirements.txt          # Dependency list
└── README.md                 # Project description

Functionality Details

Spatial Query Tools (3)

• query_nearby - Query nearby geographic features based on coordinates.
• query_bbox - Spatial range query.
• query_attribute - Query features based on attributes.

Geometric Operation Tools (5)

• buffer_geometry - Create a geometric buffer.
• get_area - Calculate the geometric area.
• get_length - Calculate the geometric length.
• transform_coords - Coordinate system transformation.
• simplify_geom - Simplify geometric objects.

Spatial Analysis Tools (5)

• measure_distance - Calculate the distance between two geometric objects.
• test_intersection - Check the intersection relationship of geometric objects.
• test_containment - Check the containment relationship of geometric objects.
• union_geoms - Merge multiple geometric objects.
• get_centroid - Calculate the centroid of a geometric object.

Database Management Tools (9)

• postgis_version - Get the PostGIS version information.
• list_extensions - List the installed database extensions.
• discover_spatial_tables - Discover tables containing spatial fields.
• table_info - Get detailed spatial information of a table.
• create_index - Create a GIST index for a spatial column.
• analyze - Analyze a table to update statistical information.
• vacuum - Clean up a table to reclaim space.
• spatial_extent - Get the spatial range of a table.
• validate_geometries - Check the validity of geometric objects.

Advanced Spatial Analysis Tools (8)

• join_spatial - Perform a spatial join operation.
• find_nearest - Find the nearest K neighbors.
• cluster_spatial - Perform spatial clustering using DBSCAN.
• compute_convex_hull - Calculate the convex hull.
• generate_voronoi - Generate Voronoi polygons.
• interpolate_line - Interpolate points along a line segment.
• snap_geometry - Snap a geometric object to a grid.
• split_line - Split a line segment using a point.

Text-to-SQL Tools (2)

• nl_to_sql - Convert natural language to PostGIS SQL statements.
• execute_sql - Safely execute SQL queries (requires user confirmation).

A total of 32 professional PostGIS tools

💻 Usage Examples

Call tools through the MCP protocol:

# Query features near the specified coordinates
result = await mcp_client.call_tool(
    "query_nearby",
    {
        "longitude": 120.123,
        "latitude": 30.456,
        "radius": 1000
    }
)

📚 Documentation

Development Guide

Add a New Tool

1. Create a new tool module in the src/tools/ directory.
2. Define the tool function using the @mcp.tool() decorator.
3. Register the new tool in server.py.

Example:

@mcp.tool()
async def my_spatial_tool(param1: str, param2: float) -> dict:
    """Tool description"""
    # Implementation logic
    return {"result": "data"}

Technology Stack

• Python 3.8+
• fastMCP
• PostGIS
• psycopg2
• asyncio

📄 License

MIT License