What is Postgis Mcp

PostGIS MCP Server is a server application that enables connections to a PostGIS database using the Model Context Protocol (MCP). It is designed for developers who need to interact with spatial databases while leveraging modern JavaScript features through TypeScript.

Use cases

Use cases for the PostGIS MCP Server include building applications that require geographic data manipulation, integrating with mapping services, creating spatial analysis tools, and developing geo-enabled applications for urban planning, logistics, and environmental management.

How to use

To use the PostGIS MCP Server, first clone the repository and install the dependencies with npm. Configure your database connection in a .env file. For development, run ‘npm run dev’ to start the server with hot-reload capability. For production, build the application with ‘npm run build’ and then start it using ‘npm start’.

Key features

Key features of the PostGIS MCP Server include TypeScript development, integration with Model Context Protocol (MCP) for streamlined data management, support for PostGIS databases, customizable configurations for both development and production environments, and hot-reload capabilities for efficient development.

Where to use

The PostGIS MCP Server can be utilized in environments where spatial data management is vital, such as geographic information systems (GIS), backend services for web and mobile applications needing geospatial data, and any application where location-based data processing is required.

PostGIS MCP Server

English | Türkçe

PostGIS MCP Server

This project is a server application that provides PostGIS database connection using Model Context Protocol (MCP).

🚀 Features

• Developed with TypeScript
• Model Context Protocol (MCP) integration
• PostGIS database support
• Configuration for development and production environments
• Hot-reload support

📋 Requirements

• Node.js (v14 or higher)
• PostgreSQL (with PostGIS extension)
• npm or yarn

🛠️ Installation

1. Clone the project:

git clone https://github.com/receptopalak/postgis-mcp.git
cd postgis-mcp

2. Install dependencies:

npm install

3. Create .env file:

NODE_ENV=development
DB_PORT=5432
DB_HOST=localhost
DB_NAME=your_database_name
DB_USER=your_username
DB_PASSWORD=your_password

🚀 Usage

Development Mode

npm run dev

Production Mode

npm run build
npm start

🔧 MCP Configuration

You can use the following example configuration for MCP server:

{
  "mcpServers": {
    "postgis": {
      "command": "npx",
      "args": [
        "tsx",
        "server.ts"
      ],
      "env": {
        "NODE_ENV": "development",
        "DB_PORT": "5432",
        "DB_HOST": "host",
        "DB_NAME": "dbname",
        "DB_USER": "user",
        "DB_PASSWORD": "pass"
      }
    }
  }
}

📦 Dependencies

• @modelcontextprotocol/sdk: ^1.12.1
• dotenv: ^16.5.0
• pg: ^8.16.0
• zod: ^3.25.64

🤝 Contributing

1. Fork this repository
2. Create your feature branch (git checkout -b feature/amazing-feature)
3. Commit your changes (git commit -m 'feat: Add some amazing feature')
4. Push to the branch (git push origin feature/amazing-feature)
5. Open a Pull Request

📝 License

This project is licensed under the ISC License. See the LICENSE file for more information.

📧 Contact

Project Owner - @receptopalak

Project Link: 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

1. Projeyi klonlayın:

git clone https://github.com/receptopalak/postgis-mcp.git
cd postgis-mcp

2. Bağımlılıkları yükleyin:

npm install

3. .env dosyası oluşturun:

NODE_ENV=development
DB_PORT=5432
DB_HOST=localhost
DB_NAME=your_database_name
DB_USER=your_username
DB_PASSWORD=your_password

🚀 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_PORT": "5432",
        "DB_HOST": "host",
        "DB_NAME": "dbname",
        "DB_USER": "user",
        "DB_PASSWORD": "pass"
      }
    }
  }
}

📦 Bağımlılıklar

• @modelcontextprotocol/sdk: ^1.12.1
• dotenv: ^16.5.0
• pg: ^8.16.0
• zod: ^3.25.64

🤝 Katkıda Bulunma

1. Bu depoyu fork edin
2. Yeni bir özellik dalı oluşturun (git checkout -b feature/amazing-feature)
3. Değişikliklerinizi commit edin (git commit -m 'feat: Add some amazing feature')
4. Dalınıza push edin (git push origin feature/amazing-feature)
5. 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