PostGIS MCP Server

English | Trke

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

1. Install dependencies:

npm install

1. 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 balantsn salayan bir sunucu uygulamasdr.

zellikler

• TypeScript ile gelitirilmi
• Model Context Protocol (MCP) entegrasyonu
• PostGIS veritaban destei
• Gelitirme ve retim ortamlar iin yaplandrma
• Hot-reload destei

Gereksinimler

• Node.js (v14 veya zeri)
• PostgreSQL (PostGIS eklentisi ile)
• npm veya yarn

Kurulum

1. Projeyi klonlayn:

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

1. Bamllklar ykleyin:

npm install

1. .env dosyas oluturun:

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

Kullanm

Gelitirme Modu

npm run dev

retim Modu

npm run build
npm start

MCP Yaplandrmas

MCP sunucu yaplandrmas iin aadaki rnek yaplandrmay 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"
      }
    }
  }
}

Bamllklar

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

Katkda Bulunma

1. Bu depoyu fork edin
2. Yeni bir zellik dal oluturun (git checkout -b feature/amazing-feature)
3. Deiikliklerinizi commit edin (git commit -m 'feat: Add some amazing feature')
4. Dalnza push edin (git push origin feature/amazing-feature)
5. Bir Pull Request oluturun

Lisans

Bu proje ISC lisans altnda lisanslanmtr. Daha fazla bilgi iin LICENSE dosyasna bakn.

letiim

Proje Sahibi - @receptopalak

Proje Linki: https://github.com/receptopalak/postgis-mcp