PostGIS MCP Server

spatial-join

Perform spatial joins between two tables using specified geometry columns and join types such as intersects, within, contains, or touches. Ideal for analyzing spatial relationships in PostGIS databases via the MCP server.

Instructions

İki tablo arasında mekansal join işlemi yap

Input Schema

Name	Required	Description
`geometry_column1`	No	Tablo1 geometri kolonu (varsayılan: geom)
`geometry_column2`	No	Tablo2 geometri kolonu (varsayılan: geom)
`join_type`	Yes	Join tipi
`limit`	No	Sonuç limiti (varsayılan: 100)
`table1`	Yes	Birinci tablo adı
`table2`	Yes	İkinci tablo adı

Input Schema (JSON Schema)

{
  "properties": {
    "geometry_column1": {
      "description": "Tablo1 geometri kolonu (varsayılan: geom)",
      "type": "string"
    },
    "geometry_column2": {
      "description": "Tablo2 geometri kolonu (varsayılan: geom)",
      "type": "string"
    },
    "join_type": {
      "description": "Join tipi",
      "enum": [
        "intersects",
        "within",
        "contains",
        "touches"
      ],
      "type": "string"
    },
    "limit": {
      "description": "Sonuç limiti (varsayılan: 100)",
      "type": "number"
    },
    "table1": {
      "description": "Birinci tablo adı",
      "type": "string"
    },
    "table2": {
      "description": "İkinci tablo adı",
      "type": "string"
    }
  },
  "required": [
    "table1",
    "table2",
    "join_type"
  ],
  "type": "object"
}

Install Server

HTTP connection URL

Related Tools

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/receptopalak/postgis-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server