PostGIS MCP Server
PostGIS MCPサーバー
PostGIS MCPサーバー
このプロジェクトは、Model Context Protocol (MCP) を使用してPostGISデータベース接続を提供するサーバーアプリケーションです。
🚀 特徴
TypeScriptで開発
Model Context Protocol (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
🤝 貢献
このリポジトリをフォークします
フィーチャーブランチを作成します (
git checkout -b feature/amazing-feature)変更をコミットします (
git commit -m 'feat: Add some amazing feature')ブランチにプッシュします (
git push origin feature/amazing-feature)プルリクエストを作成します
📝 ライセンス
このプロジェクトは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-