PostGIS MCP Server

spatial-join

Perform spatial joins between two tables in a PostGIS database, using criteria like intersects, within, contains, or touches, to merge datasets based on geometric relationships.

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"
}

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