Skip to main content
Glama

PostGIS MCP Server

by receptopalak

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
  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ı 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
  1. Bağımlılıkları yükleyin:
npm install
  1. .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

Install Server
A
security – no known vulnerabilities
F
license - not found
A
quality - confirmed to work

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

A server application that provides PostGIS database connection using Model Context Protocol (MCP), enabling spatial database functionality through natural language interactions.

  1. PostGIS MCP Server
    1. 🚀 Features
    2. 📋 Requirements
    3. 🛠️ Installation
    4. 🚀 Usage
    5. 🔧 MCP Configuration
    6. 📦 Dependencies
    7. 🤝 Contributing
    8. 📝 License
    9. 📧 Contact
  2. PostGIS MCP Server
    1. 🚀 Özellikler
    2. 📋 Gereksinimler
    3. 🛠️ Kurulum
    4. 🚀 Kullanım
    5. 🔧 MCP Yapılandırması
    6. 📦 Bağımlılıklar
    7. 🤝 Katkıda Bulunma
    8. 📝 Lisans
    9. 📧 İletişim

Related MCP Servers

  • A
    security
    A
    license
    A
    quality
    A Model Context Protocol server that enables powerful PostgreSQL database management capabilities including analysis, schema management, data migration, and monitoring through natural language interactions.
    Last updated -
    18
    438
    89
    TypeScript
    AGPL 3.0
    • Linux
    • Apple
  • -
    security
    F
    license
    -
    quality
    A Model Context Protocol server that enables performing PostgreSQL database operations (create, read, update, delete) on User and Post entities through MCP tools.
    Last updated -
    TypeScript
  • -
    security
    A
    license
    -
    quality
    A Model Context Protocol server that enables interaction with PostgreSQL databases to list tables, retrieve schemas, and execute read-only SQL queries.
    Last updated -
    35
    JavaScript
    MIT License
    • Linux
    • Apple
  • A
    security
    A
    license
    A
    quality
    A Model Context Protocol server that enables interaction with PostgreSQL databases for analyzing setups, debugging issues, managing schemas, migrating data, and monitoring performance.
    Last updated -
    1
    1
    TypeScript
    MIT License

View all related MCP servers

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/receptopalak/postgis-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server