# PostGIS Yukon

> Use this tool when you need to perform PostGIS-enabled database operations using natural language, converting text to SQL queries with AI-powered integration. It solves problems in GIS workflows, spatial data analysis, and enables non-technical users to interact with PostGIS databases through conversational interfaces. The tool accepts natural language inputs and outputs SQL queries, spatial analysis results, and database operations, making it ideal for use cases where traditional spatial queries and text-to-SQL capabilities are required.

Canonical page: https://skillsregistry.net/skills/zmgiser-postgis-yukon  
JSON: https://api.skillsregistry.net/v1/skills/zmgiser-postgis-yukon

## Description

Provides PostGIS-enabled database operations with AI-powered natural language to SQL conversion through Vanna AI integration. Combines traditional PostGIS spatial queries with text-to-SQL capabilities using OpenAI and Anthropic models, featuring tools for geometry operations, spatial analysis, data import from various formats (Shapefile, GeoJSON, CSV), and administrative functions like user management and database schema operations. Built with FastMCP framework and asyncpg for async database operations, includes a separate Vanna service for training and querying spatial databases using natural language, making it valuable for GIS workflows, spatial data analysis, and enabling non-technical users to interact with PostGIS databases through conversational interfaces.

## Trust

- **Trust score (0–1):** 0.27
- **Verification tier:** scanned
- **Last scanned:** 2026-09-01

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-01

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/zmgiser-postgis-yukon)
- **Repository:** <https://github.com/zmgiser/postgis_yukon_mcp>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "zmgiser-postgis-yukon"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/zmgiser-postgis-yukon` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/zmgiser-postgis-yukon/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt