MCP PostgreSQL Server

Integrations

Provides database operations for PostgreSQL, enabling CRUD operations on User and Post entities with type-safe queries through the MCP interface
Utilizes Prisma for type-safe database operations, providing a structured interface to interact with the PostgreSQL database schema

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

Clone the repository
Install dependencies:

git clone https://github.com/a21071/mcp-postgres.git
cd mcp-postgres
npm install

Set up PostgreSQL database:

docker-compose up -d

Run database migrations:

npx prisma migrate dev

Build the project:

npm run build

Usage

Run the server:

npm start

Available MCP Tools

getData: Retrieve user data from PostgreSQL
{ "tableName": "user" }
addUserData: Add new user to database
{ "email": "user@example.com", "name": "John Doe", "age": 30 }
deleteUserData: Delete user by ID, email or name
{ "id": "clxyz...", "email": "user@example.com", "name": "John Doe" }
updateUserData: Update user information
{ "id": "clxyz...", "email": "new@example.com", "name": "New Name" }

Database Schema

The server uses the following Prisma schema:

model User {
  id        String   @id @default(cuid())
  email     String   @unique
  name      String?
  age       Int?
  createdAt DateTime @default(now())
  posts     Post[]
}

Development

Watch mode:

npm run watch

Dependencies

@modelcontextprotocol/sdk - MCP server SDK
Prisma - Type-safe database client
TypeScript - Type checking

License

MIT

This server cannot be installed

security - not tested

license - not found

quality - not tested

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

A Model Context Protocol server that enables performing PostgreSQL database operations (create, read, update, delete) on User and Post entities through MCP tools.

Related MCP Servers

PostgreSQL
modelcontextprotocol
-
security
A
license
-
quality
A Model Context Protocol server that provides read-only access to PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
Last updated -
1
16,948
47,105
JavaScript
MIT License
MCP Postgres Server
MadeByNando
-
security
F
license
-
quality
A server implementing the Model Context Protocol (MCP) for Cursor that allows using a PostgreSQL database as storage for model contexts, enabling secure database exploration and querying.
Last updated -
JavaScript
Enhanced PostgreSQL MCP Server
GarethCott
-
security
F
license
-
quality
A Model Context Protocol server providing both read and write access to PostgreSQL databases, enabling LLMs to query data, modify records, and manage database schemas.
Last updated -
4
JavaScript
PostgreSQL MCP Server
hthuong09
-
security
F
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 -
16,948
JavaScript

View all related MCP servers

MCP PostgreSQL Server