local-only server
The server can only run on the client’s local machine because it depends on local resources.
Integrations
Provides tools for exploring and querying a PostgreSQL database, including executing read-only SQL queries, listing tables, and obtaining schema information for specific tables.
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:
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:Copy
- To restart the server:Copy
MCP Server Features
The MCP PostgreSQL server exposes the following tools for Cursor:
postgres_query
- Execute a read-only SQL querypostgres_list_tables
- List all tables in the databasepostgres_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
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.
- Prérequis
- Installation et démarrage
- Configuration dans Cursor
- Résolution des problèmes
- Fonctionnalités du serveur MCP