Postgresql Database

🚀 Model Context Protocol PostgreSQL Server

This project implements a Model Context Protocol (MCP) server that supports connections to a PostgreSQL database. It allows AI models to interact with your database through a standardized protocol.

🚀 Quick Start

The Model Context Protocol PostgreSQL Server enables AI models to interact with a PostgreSQL database. Here's how to get started:

Prerequisites

• Node.js 20 or higher
• PostgreSQL database
• Database access credentials

Installation

1. Clone this repository.
2. Install dependencies:

npm install

Configuration

The server reads configuration from the .env file in the project root directory. Make sure the file contains the following:

DB_HOST=your-database-host
DB_PORT=your-database-port
DB_NAME=your-database-name
DB_USER=your-database-user
DB_PASSWORD=your-database-password

Usage

1. Start the server:

node server.js

2. Access the management interface: Open http://localhost:3000 in your browser.

✨ Features

• Connect to a PostgreSQL database using a connection pool.
• Implement the Model Context Protocol (MCP) for AI model interaction.
• Provide database table structure information as a resource.
• Support the execution of SQL queries with retry logic.
• Handle connection errors smoothly.

📚 Documentation

Environment Variable Configuration

Ensure the following environment variables are set correctly:

• DB_HOST: Database host address
• DB_PORT: Database port number
• DB_NAME: Database name
• DB_USER: Database username
• DB_PASSWORD: Database user password

Project Structure

project/
├── server.js          # Main server file
├── package.json      # Dependency management file
└── .env              # Environment variable configuration file

📄 License

This project is licensed under the MIT license.