MCP Postgres Server

MCP Postgres Server

This project implements an MCP protocol server based on PostgreSQL, providing model context storage for Cursor and supporting database queries and structure exploration.

Database Developer tools #PostgreSQL #MCP protocol #Database tool #Cursor integration Local .TypeScript

rating : 2 points

downloads : 8.7K

update time : 2025-04-23

What is the MCP PostgreSQL Server?

The MCP PostgreSQL Server is a tool based on the PostgreSQL database that allows you to access and manage data through Cursor. It supports functions such as executing SQL queries, listing database tables, and viewing table structures.

How to use the MCP PostgreSQL Server?

First, you need to install Docker and Docker Compose. Then start the server and configure the connection through Cursor. You can easily run SQL queries and manage your data in Cursor.

Applicable scenarios

Suitable for users who need to integrate the PostgreSQL database into the Cursor workflow, such as data analysts and developers.

Main features

postgres_query

Execute read-only SQL queries to retrieve data.

postgres_list_tables

List all tables in the database.

postgres_describe_table

Get the structure information of a specific table.

Advantages

Seamlessly integrate the PostgreSQL database into the Cursor workflow.

Support powerful SQL query functions.

Easy to deploy and use.

Limitations

Requires a Docker environment to be installed.

Limited to read-only operations and cannot directly modify data.

How to use

Clone the project repository

Clone the code of this project via Git.

Start the server

Start the MCP PostgreSQL Server using Docker Compose.

Configure Cursor

Add a new MCP connection in the Cursor settings.

Usage examples

Query user information

Demonstrate how to query user information from the database.

List all tables

Show how to list all tables in the database.

Frequently Asked Questions

What if the server fails to start?

Does it support write operations?

Related resources

Official documentation

Detailed user manual and technical reference.

GitHub repository

Source code and example code.

A Python-based MCP Server that provides advanced to-do list management and content organization functions through the Notion API, enabling seamless integration between AI models and Notion.

Markdownify MCP

Markdownify is a multi-functional file conversion service that supports converting multiple formats such as PDFs, images, audio, and web page content into Markdown format.

Gitlab MCP Server

The GitLab MCP server is a project based on the Model Context Protocol that provides a comprehensive toolset for interacting with GitLab accounts, including code review, merge request management, CI/CD configuration, and other functions.

Duckduckgo MCP Server

The DuckDuckGo Search MCP Server provides web search and content scraping services for LLMs such as Claude.

UnityMCP is a Unity editor plugin that implements the Model Context Protocol (MCP), providing seamless integration between Unity and AI assistants, including real - time state monitoring, remote command execution, and log functions.

Figma Context MCP

Framelink Figma MCP Server is a server that provides access to Figma design data for AI programming tools (such as Cursor). By simplifying the Figma API response, it helps AI more accurately achieve one - click conversion from design to code.

Gmail MCP Server

A Gmail automatic authentication MCP server designed for Claude Desktop, supporting Gmail management through natural language interaction, including complete functions such as sending emails, label management, and batch operations.

Minimax MCP Server

The MiniMax Model Context Protocol (MCP) is an official server that supports interaction with powerful text-to-speech, video/image generation APIs, and is suitable for various client tools such as Claude Desktop and Cursor.

AIBase

Zhiqi Future, Your AI Solution Think Tank

English 简体中文繁體中文にほんご

© 2025AIBase