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.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
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.
This project is a server application that provides PostGIS database connection using Model Context Protocol (MCP).
Developed with TypeScript
Model Context Protocol (MCP) integration
PostGIS database support
Configuration for development and production environments
Hot-reload support
Related MCP server: GeoServer MCP Server
Node.js (v14 or higher)
PostgreSQL (with PostGIS extension)
npm or yarn
Clone the project:
git clone https://github.com/receptopalak/postgis-mcp.git
cd postgis-mcpInstall dependencies:
npm installCreate .env file:
NODE_ENV=development
DB_URL_1=postgres://user:password@host:5432/database_one
DB_URL_2=postgres://user:password@host:5432/database_two
DB_URL_3=postgres://user:password@host:5432/database_threeLegacy single-database DB_HOST / DB_NAME / DB_USER / DB_PASSWORD variables are still supported as a fallback.
Optional: customize table/domain aliases in domain-aliases.json to improve natural-language table selection.
npm run devnpm run build
npm startYou can use the following example configuration for MCP server:
{
"mcpServers": {
"postgis": {
"command": "npx",
"args": ["tsx", "server.ts"],
"env": {
"NODE_ENV": "development",
"DB_URL_1": "postgres://user:pass@host:5432/db_one",
"DB_URL_2": "postgres://user:pass@host:5432/db_two"
}
}
}
}@modelcontextprotocol/sdk: ^1.12.1
dotenv: ^16.5.0
pg: ^8.16.0
zod: ^3.25.64
Fork this repository
Create your feature branch (git checkout -b feature/amazing-feature)
Commit your changes (git commit -m 'feat: Add some amazing feature')
Push to the branch (git push origin feature/amazing-feature)
Open a Pull Request
This project is licensed under the ISC License. See the LICENSE file for more information.
Project Owner - @receptopalak
Project Link: https://github.com/receptopalak/postgis-mcp
Bu proje, Model Context Protocol (MCP) kullanarak PostGIS veritabanı bağlantısını sağlayan bir sunucu uygulamasıdır.
TypeScript ile geliştirilmiş
Model Context Protocol (MCP) entegrasyonu
PostGIS veritabanı desteği
Geliştirme ve üretim ortamları için yapılandırma
Hot-reload desteği
Node.js (v14 veya üzeri)
PostgreSQL (PostGIS eklentisi ile)
npm veya yarn
Projeyi klonlayın:
git clone https://github.com/receptopalak/postgis-mcp.git
cd postgis-mcpBağımlılıkları yükleyin:
npm install.env dosyası oluşturun:
NODE_ENV=development
DB_URL_1=postgres://user:password@host:5432/database_one
DB_URL_2=postgres://user:password@host:5432/database_two
DB_URL_3=postgres://user:password@host:5432/database_threeEski tek veritabanlı DB_HOST / DB_NAME / DB_USER / DB_PASSWORD değişkenleri de fallback olarak desteklenir.
Opsiyonel: doğal dilde tablo seçimini iyileştirmek için domain-aliases.json dosyasını özelleştirin.
npm run devnpm run build
npm startMCP sunucu yapılandırması için aşağıdaki örnek yapılandırmayı kullanabilirsiniz:
{
"mcpServers": {
"postgis": {
"command": "npx",
"args": ["tsx", "server.ts"],
"env": {
"NODE_ENV": "development",
"DB_URL_1": "postgres://user:pass@host:5432/db_one",
"DB_URL_2": "postgres://user:pass@host:5432/db_two"
}
}
}
}@modelcontextprotocol/sdk: ^1.12.1
dotenv: ^16.5.0
pg: ^8.16.0
zod: ^3.25.64
Bu depoyu fork edin
Yeni bir özellik dalı oluşturun (git checkout -b feature/amazing-feature)
Değişikliklerinizi commit edin (git commit -m 'feat: Add some amazing feature')
Dalınıza push edin (git push origin feature/amazing-feature)
Bir Pull Request oluşturun
Bu proje ISC lisansı altında lisanslanmıştır. Daha fazla bilgi için LICENSE dosyasına bakın.
Proje Sahibi - @receptopalak
Proje Linki: https://github.com/receptopalak/postgis-mcp
Veritabanı şemasını analiz et ve tablo bilgilerini topla
Inputs: force_refresh.
İki nokta arasındaki mesafeyi hesapla
Inputs: point1_lat (required), point1_lon (required), point2_lat (required), point2_lon (required), +1 more.
Geometri etrafında buffer oluştur
Inputs: distance_meters (required), geometry_wkt (required).
Koordinat dizisinden çizgi geometrisi oluştur
Inputs: coordinates (required), srid.
Koordinatlardan nokta geometrisi oluştur
Inputs: latitude (required), longitude (required), srid.
Koordinat dizisinden poligon geometrisi oluştur
Inputs: exterior_ring (required), interior_rings, srid.
Mekansal indeks oluştur
Inputs: table_name (required), geometry_column.
Belirli koordinattaki raster değerini çıkar
Inputs: latitude (required), longitude (required), table_name (required), raster_column.
Belirli bir noktanın çevresindeki özellikleri bul
Inputs: distance_km (required), latitude (required), longitude (required), table_name (required), +1 more.
Geometrinin merkez noktasını bul
Inputs: geometry_wkt (required).
Geometrinin konveks zarfını hesapla
Inputs: geometry_wkt (required).
Geometri hakkında detaylı bilgi al (alan, uzunluk, boyut vs.)
Inputs: geometry_wkt (required).
İki geometrinin kesişimini bul
Inputs: geometry1_wkt (required), geometry2_wkt (required).
Birden fazla geometriyi birleştir
Inputs: geometries_wkt (required).
Belirli bir tablo hakkında detaylı bilgi al
Inputs: table_name (required).
Raster verisinin bilgilerini al
Inputs: table_name (required), raster_column.
Geometriyi basitleştir (Douglas-Peucker algoritması)
Inputs: geometry_wkt (required), tolerance (required), preserve_collapsed.
Doğal dilde sorulan soruyu anla ve uygun veritabanı sorgusuna çevir
Inputs: question (required), language.
İki tablo arasında mekansal join işlemi yap
Inputs: join_type (required), table1 (required), table2 (required), geometry_column1, +2 more.
PostGIS veritabanı bağlantısını test et
Inputs: no named parameters.
Koordinat sistemini dönüştür
Inputs: geometry_wkt (required), source_srid (required), target_srid (required).
Geometrinin geçerliliğini kontrol et
Inputs: geometry_wkt (required).
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
Scored across 22 tools
Every tool has a clearly distinct purpose targeting specific PostGIS operations like geometry creation, analysis, spatial queries, and database management. There is no overlap; for example, 'create-point' and 'create-puffer' serve different functions, and descriptions help differentiate even similar-sounding tools like 'geometry-info' and 'get-table-info'.
Tool names follow a consistent verb-noun pattern with hyphens throughout, such as 'create-point', 'calculate-distance', and 'validate-geometry'. This predictable naming scheme makes it easy for agents to understand and select tools without confusion or mixed conventions.
With 22 tools, the count is slightly high but reasonable for a comprehensive PostGIS server covering geometry operations, spatial analysis, raster data, and database utilities. It might feel heavy, but each tool appears to earn its place in the domain without being excessive.
The tool set provides complete coverage for PostGIS operations, including CRUD-like functions (e.g., create, analyze, validate), spatial calculations (e.g., distance, intersection), database management (e.g., test-connection, get-table-info), and advanced features like natural language querying. No obvious gaps are present for the domain.
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
Hosted PostgreSQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Geospatial AI MCP server — satellite imagery, embeddings, weather, GNS governance
