PostGIS MCP Server
PostGIS MCP Server
PostGIS MCP Server
Этот проект представляет собой серверное приложение, обеспечивающее подключение к базе данных PostGIS с использованием протокола Model Context Protocol (MCP).
🚀 Функции
Разработано на TypeScript
Интеграция с Model Context Protocol (MCP)
Поддержка базы данных PostGIS
Конфигурация для сред разработки и продакшена
Поддержка горячей перезагрузки (hot-reload)
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)Откройте Pull Request
📝 Лицензия
Этот проект лицензирован по лицензии ISC. Дополнительную информацию см. в файле LICENSE.
📧 Контакты
Владелец проекта - @receptopalak
Ссылка на проект: https://github.com/receptopalak/postgis-mcp
PostGIS MCP Server
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-