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
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
Related MCP Servers
- AsecurityAlicenseAqualityA powerful Model Context Protocol (MCP) tool for exploring and managing different types of databases including PostgreSQL, MySQL, and Firestore.Last updated -93TypeScriptMIT License
- AsecurityAlicenseAquality🗂️ 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 -8874TypeScriptMIT License
- -securityAlicense-qualityA Model Context Protocol (MCP) server for Cursor IDE that simplifies the installation and configuration of other MCP servers.Last updated -88223JavaScriptMIT License
- -securityFlicense-qualityA 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