mcp-postgres

mcp-postgres

0
databases

The MCP PostgreSQL Server is a Model Context Protocol server designed to facilitate PostgreSQL database operations via MCP tools. It supports CRUD operations for user and post entities using a type-safe approach with Prisma and TypeScript.

MCP PostgreSQL Server

  • A Model Context Protocol (MCP) server that provides PostgreSQL database operations through MCP tools.

Features

  • CRUD operations for User and Post entities
  • Type-safe database operations using Prisma
  • MCP-compatible tool interface
  • Built with TypeScript for type safety

Installation

  1. Clone the repository
  2. Install dependencies
  3. Set up PostgreSQL database
  4. Run database migrations
  5. Build the project

Usage

  • Run the server and utilize MCP tools such as getData, addUserData, deleteUserData, and updateUserData to manage user data.