PostGIS MCP Server
Servidor MCP de PostGIS
Servidor MCP de PostGIS
Este proyecto es una aplicación de servidor que proporciona conexión a bases de datos PostGIS utilizando el Protocolo de Contexto de Modelo (MCP).
🚀 Características
Desarrollado con TypeScript
Integración con el Protocolo de Contexto de Modelo (MCP)
Soporte para bases de datos PostGIS
Configuración para entornos de desarrollo y producción
Soporte para recarga en caliente (hot-reload)
Related MCP server: GeoServer MCP Server
📋 Requisitos
Node.js (v14 o superior)
PostgreSQL (con la extensión PostGIS)
npm o yarn
🛠️ Instalación
Clona el proyecto:
git clone https://github.com/receptopalak/postgis-mcp.git
cd postgis-mcpInstala las dependencias:
npm installCrea el archivo
.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_threeLas variables heredadas de base de datos única DB_HOST / DB_NAME / DB_USER / DB_PASSWORD siguen siendo compatibles como respaldo.
Opcional: personaliza los alias de tablas/dominios en
domain-aliases.jsonpara mejorar la selección de tablas mediante lenguaje natural.
🚀 Uso
Modo de desarrollo
npm run devModo de producción
npm run build
npm start🔧 Configuración de MCP
Puedes usar el siguiente ejemplo de configuración para el servidor 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"
}
}
}
}📦 Dependencias
@modelcontextprotocol/sdk: ^1.12.1
dotenv: ^16.5.0
pg: ^8.16.0
zod: ^3.25.64
🤝 Contribución
Haz un fork de este repositorio
Crea tu rama de características (
git checkout -b feature/amazing-feature)Confirma tus cambios (
git commit -m 'feat: Add some amazing feature')Sube los cambios a la rama (
git push origin feature/amazing-feature)Abre una Pull Request
📝 Licencia
Este proyecto está bajo la Licencia ISC. Consulta el archivo LICENSE para más información.
📧 Contacto
Propietario del proyecto - @receptopalak
Enlace del proyecto: https://github.com/receptopalak/postgis-mcp
Servidor MCP de PostGIS
Este proyecto es una aplicación de servidor que proporciona conexión a bases de datos PostGIS utilizando el Protocolo de Contexto de Modelo (MCP).
🚀 Características
Desarrollado con TypeScript
Integración con el Protocolo de Contexto de Modelo (MCP)
Soporte para bases de datos PostGIS
Configuración para entornos de desarrollo y producción
Soporte para recarga en caliente (hot-reload)
📋 Requisitos
Node.js (v14 o superior)
PostgreSQL (con la extensión PostGIS)
npm o yarn
🛠️ Instalación
Clona el proyecto:
git clone https://github.com/receptopalak/postgis-mcp.git
cd postgis-mcpInstala las dependencias:
npm installCrea el archivo
.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_threeLas variables heredadas de base de datos única DB_HOST / DB_NAME / DB_USER / DB_PASSWORD siguen siendo compatibles como respaldo.
Opcional: personaliza los alias de tablas/dominios en
domain-aliases.jsonpara mejorar la selección de tablas mediante lenguaje natural.
🚀 Uso
Modo de desarrollo
npm run devModo de producción
npm run build
npm start🔧 Configuración de MCP
Puedes usar el siguiente ejemplo de configuración para el servidor 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"
}
}
}
}📦 Dependencias
@modelcontextprotocol/sdk: ^1.12.1
dotenv: ^16.5.0
pg: ^8.16.0
zod: ^3.25.64
🤝 Contribución
Haz un fork de este repositorio
Crea tu rama de características (
git checkout -b feature/amazing-feature)Confirma tus cambios (
git commit -m 'feat: Add some amazing feature')Sube los cambios a la rama (
git push origin feature/amazing-feature)Abre una Pull Request
📝 Licencia
Este proyecto está bajo la Licencia ISC. Consulta el archivo LICENSE para más información.
📧 Contacto
Propietario del proyecto - @receptopalak
Enlace del proyecto: 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-