MCP Postgres Server

This server implements the Model Context Protocol (MCP) for Cursor, allowing a PostgreSQL database to be used as storage for model contexts.

Prerequisites

Docker
Docker Compose

Installation and startup

Clone this repository
Start the server with Docker Compose:

docker-compose up -d

Configuration in Cursor

Open Cursor
Go to Settings > MCP
Add a new connection with the following settings:
- Name: MCP Postgres Server
- Type: command
- Command: docker exec -i mcp-postgres-server node dist/index.js

Troubleshooting

If the server does not start correctly:

Check the container logs:
docker logs mcp-postgres-server
To restart the server:
docker-compose restart

MCP Server Features

The MCP PostgreSQL server exposes the following tools for Cursor:

postgres_query - Execute a read-only SQL query
postgres_list_tables - List all tables in the database
postgres_describe_table - Get the schema of a specific table

These tools allow Cursor to securely explore and query the database.

This server cannot be installed

security - not tested

license - not found

quality - not tested

How are these scores calculated?

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 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.

Related Resources

Reddit Discussion about this server

Related MCP Servers

db-mcp-tool
wirdes
A
security
A
license
A
quality
A powerful Model Context Protocol (MCP) tool for exploring and managing different types of databases including PostgreSQL, MySQL, and Firestore.
Last updated -
9
3
TypeScript
MIT License
mcp-turso-cloud
spences10
A
security
A
license
A
quality
🗂️ A Model Context Protocol (MCP) server that provides integration with Turso databases for LLMs. This server implements a two-level authentication system to handle both organization-level and database-level operations, making it easy to manage and query Turso databases directly from LLMs.
Last updated -
8
109
8
TypeScript
MIT License
Cursor MCP Installer
matthewdcage
-
security
A
license
-
quality
A Model Context Protocol (MCP) server for Cursor IDE that simplifies the installation and configuration of other MCP servers.
Last updated -
882
23
JavaScript
MIT License
MCP PostgreSQL Server
a21071
-
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

View all related MCP servers

MCP Postgres Server