# PostGIS

> Use this tool when you need to integrate spatial data analysis and geographic information systems (GIS) into your application, or perform location-based queries on PostgreSQL databases. It solves problems related to spatial data processing, such as analyzing geographic datasets and executing spatial queries, by providing a secure and validated interface to PostgreSQL databases with PostGIS extension support. It accepts SQL queries and environment variable configurations as inputs and returns query results, making it ideal for applications that require both traditional relational data and spatial/geographic data capabilities.

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

## Description

This MCP server provides direct PostgreSQL database integration with PostGIS spatial extension support, built by Recepto Palak using TypeScript with the pg library and Zod for schema validation. The implementation enables SQL query execution against PostgreSQL databases with geographic and spatial data capabilities through PostGIS, offering secure database connectivity via environment variable configuration and strict input validation. It's valuable for applications requiring spatial data analysis, geographic information systems (GIS), location-based queries, and general PostgreSQL database operations where AI assistants need to interact with both traditional relational data and spatial/geographic datasets.

## Trust

- **Trust score (0–1):** 0.94
- **Verification tier:** verified
- **Last scanned:** 2026-09-28

## Facts

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

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/receptopalak-postgis)
- **Repository:** <https://github.com/receptopalak/postgis-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": "receptopalak-postgis"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/receptopalak-postgis` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/receptopalak-postgis/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