The PostGIS MCP Server is a TypeScript-based server that connects to PostGIS databases via the Model Context Protocol (MCP), enabling natural language queries and spatial data operations.

Database Management

• Test PostGIS database connections

• Analyze database schemas and collect table information (with optional cache refresh)

• Retrieve detailed information about specific tables

• Create spatial indexes on table geometry columns

• Support multiple database connections via environment variables (e.g., DB_URL_1, DB_URL_2)

Natural Language Querying

• Ask questions in English or Turkish (e.g., "How many stations are in Istanbul?") and have them automatically translated into SQL queries

• Improve table selection using customizable domain-aliases.json

Geometry Creation

• Create point geometries from longitude/latitude coordinates

• Create linestring geometries from coordinate arrays

• Create polygon geometries with exterior and optional interior rings

Geometry Analysis & Operations

• Get detailed info about a geometry (area, length, dimensions) from WKT format

• Validate geometry correctness

• Find the centroid or convex hull of a geometry

• Find intersections between two geometries

• Union multiple geometries into one

Spatial Calculations

• Calculate distance between two points (with optional geographic calculation)

• Create buffers around geometries at a specified distance

• Simplify geometries using the Douglas-Peucker algorithm

• Transform coordinates between different spatial reference systems (SRIDs)

Spatial Queries

• Find nearby features within a specified distance from a point

• Perform spatial joins between two tables (intersects, within, contains, touches)

Raster Data

• Retrieve metadata and information about raster data in a table

• Extract raster values at specific coordinates

Enables environment variable configuration for development and production environments, supporting database connection parameters and application settings.

Enables version control and collaborative development workflow for the project codebase.

Hosts the project repository, allowing for project sharing, issue tracking, and collaboration.

Runs the server application on Node.js runtime (v14 or higher), providing the execution environment for the MCP server.

Manages package dependencies and provides scripts for development, building, and running the application.

Provides PostGIS database connection capabilities, allowing spatial data querying and manipulation through PostgreSQL with the PostGIS extension.

Implements server functionality with TypeScript, providing type safety and modern JavaScript features for robust application development.

Offers an alternative package manager for installing dependencies and running the application.

Provides schema validation for data structures, ensuring type safety and data integrity when processing database queries and responses.

1. Click on "Install Server".

2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.

3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@PostGIS MCP Server find all coffee shops within 2 miles of my current location"

That's it! The server will respond to your query, and you can continue using it as needed.

Here is a step-by-step guide with screenshots.