PostGIS MCP Server
PostGIS MCP 服务器
PostGIS MCP 服务器
本项目是一个使用模型上下文协议 (MCP) 提供 PostGIS 数据库连接的服务器应用程序。
🚀 特性
使用 TypeScript 开发
模型上下文协议 (MCP) 集成
支持 PostGIS 数据库
提供开发和生产环境配置
支持热重载
Related MCP server: GeoServer MCP Server
📋 要求
Node.js (v14 或更高版本)
PostgreSQL (需安装 PostGIS 扩展)
npm 或 yarn
🛠️ 安装
克隆项目:
git clone https://github.com/receptopalak/postgis-mcp.git
cd postgis-mcp安装依赖:
npm install创建
.env文件:
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_three旧版的单数据库 DB_HOST / DB_NAME / DB_USER / DB_PASSWORD 变量仍作为后备方案支持。
可选:在
domain-aliases.json中自定义表/域别名,以改善自然语言的表选择效果。
🚀 使用方法
开发模式
npm run dev生产模式
npm run build
npm start🔧 MCP 配置
您可以将以下示例配置用于 MCP 服务器:
{
"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 本仓库
创建您的功能分支 (
git checkout -b feature/amazing-feature)提交您的更改 (
git commit -m 'feat: Add some amazing feature')推送到分支 (
git push origin feature/amazing-feature)开启 Pull Request
📝 许可证
本项目采用 ISC 许可证。更多信息请参阅 LICENSE 文件。
📧 联系方式
项目所有者 - @receptopalak
项目链接: https://github.com/receptopalak/postgis-mcp
PostGIS MCP 服务器
Bu proje, Model Context Protocol (MCP) kullanarak PostGIS veritabanı bağlantısını sağlayan bir sunucu uygulamasıdır.
🚀 Özellikler
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
📋 Gereksinimler
Node.js (v14 veya üzeri)
PostgreSQL (PostGIS eklentisi ile)
npm veya yarn
🛠️ Kurulum
Projeyi klonlayın:
git clone https://github.com/receptopalak/postgis-mcp.git
cd postgis-mcpBağımlılıkları yükleyin:
npm install.envdosyası 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.jsondosyasını özelleştirin.
🚀 Kullanım
Geliştirme Modu
npm run devÜretim Modu
npm run build
npm start🔧 MCP Yapılandırması
MCP 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"
}
}
}
}📦 Bağımlılıklar
@modelcontextprotocol/sdk: ^1.12.1
dotenv: ^16.5.0
pg: ^8.16.0
zod: ^3.25.64
🤝 Katkıda Bulunma
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
📝 Lisans
Bu proje ISC lisansı altında lisanslanmıştır. Daha fazla bilgi için LICENSE dosyasına bakın.
📧 İletişim
Proje Sahibi - @receptopalak
Proje Linki: https://github.com/receptopalak/postgis-mcp
Available Tools
22 toolsanalyze-databaseC
Veritabanı şemasını analiz et ve tablo bilgilerini topla
Inputs: force_refresh.
calculate-distanceC
İki nokta arasındaki mesafeyi hesapla
Inputs: point1_lat (required), point1_lon (required), point2_lat (required), point2_lon (required), +1 more.
create-bufferC
Geometri etrafında buffer oluştur
Inputs: distance_meters (required), geometry_wkt (required).
create-linestringB
Koordinat dizisinden çizgi geometrisi oluştur
Inputs: coordinates (required), srid.
create-pointC
Koordinatlardan nokta geometrisi oluştur
Inputs: latitude (required), longitude (required), srid.
create-polygonC
Koordinat dizisinden poligon geometrisi oluştur
Inputs: exterior_ring (required), interior_rings, srid.
create-spatial-indexD
Mekansal indeks oluştur
Inputs: table_name (required), geometry_column.
extract-raster-valueC
Belirli koordinattaki raster değerini çıkar
Inputs: latitude (required), longitude (required), table_name (required), raster_column.
find-nearbyC
Belirli bir noktanın çevresindeki özellikleri bul
Inputs: distance_km (required), latitude (required), longitude (required), table_name (required), +1 more.
geometry-centroidC
Geometrinin merkez noktasını bul
Inputs: geometry_wkt (required).
geometry-convex-hullC
Geometrinin konveks zarfını hesapla
Inputs: geometry_wkt (required).
geometry-infoC
Geometri hakkında detaylı bilgi al (alan, uzunluk, boyut vs.)
Inputs: geometry_wkt (required).
geometry-intersectionC
İki geometrinin kesişimini bul
Inputs: geometry1_wkt (required), geometry2_wkt (required).
geometry-unionC
Birden fazla geometriyi birleştir
Inputs: geometries_wkt (required).
get-table-infoC
Belirli bir tablo hakkında detaylı bilgi al
Inputs: table_name (required).
raster-infoC
Raster verisinin bilgilerini al
Inputs: table_name (required), raster_column.
simplify-geometryC
Geometriyi basitleştir (Douglas-Peucker algoritması)
Inputs: geometry_wkt (required), tolerance (required), preserve_collapsed.
smart-queryC
Doğal dilde sorulan soruyu anla ve uygun veritabanı sorgusuna çevir
Inputs: question (required), language.
spatial-joinC
İki tablo arasında mekansal join işlemi yap
Inputs: join_type (required), table1 (required), table2 (required), geometry_column1, +2 more.
test-connectionB
PostGIS veritabanı bağlantısını test et
Inputs: no named parameters.
transform-coordinatesD
Koordinat sistemini dönüştür
Inputs: geometry_wkt (required), source_srid (required), target_srid (required).
validate-geometryC
Geometrinin geçerliliğini kontrol et
Inputs: geometry_wkt (required).
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
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.
Maintenance
Related MCP Connectors
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
Related MCP Servers
- AlicenseBqualityDmaintenanceA Model Context Protocol server that enables powerful PostgreSQL database management capabilities including analysis, schema management, data migration, and monitoring through natural language interactions.1810,856 npm204AGPL 3.0
- AlicenseAqualityDmaintenanceA Model Context Protocol server that connects Large Language Models to the GeoServer REST API, enabling AI assistants to query and manipulate geospatial data through natural language.997MIT
- FlicenseNot gradedqualityDmaintenanceA Model Context Protocol server implementation that provides a simple interface to interact with PostgreSQL databases, enabling SQL queries, database operations, and schema management through MCP.-
- FlicenseNot gradedqualityDmaintenanceAn MCP server that transforms natural language questions into SQL, executes queries on PostgreSQL, and returns human-friendly responses, with Redis memory for context.1-