Which integrations are available for this server?

Provides tools for PostgreSQL database interactions including listing tables, retrieving database information, and executing read-only SQL queries with security-first validation

How do I use Enterprise PostgreSQL MCP Server?

1. Click on "Deploy Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@Enterprise PostgreSQL MCP Server list all tables in the production database" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

Enterprise PostgreSQL MCP Server v2

A production-ready Model Context Protocol (MCP) server for PostgreSQL database interactions.

Features

✅ Working MCP Server: Simple and reliable PostgreSQL MCP implementation
✅ Read-only by Default: Security-first approach with query validation
✅ Multiple Tools: Database listing, table inspection, and SQL queries
✅ Cursor Integration: Ready for Cursor IDE integration
✅ FastMCP Support: Both simple and FastMCP implementations included

Quick Start

1. Setup Environment

python -m venv venv
source venv/bin/activate  # On Windows: venv\Scripts\activate
pip install -r requirements.txt

2. Configure Database

Set your PostgreSQL connection string:

export PG_DSN="postgresql://postgres:@localhost:5432/your_database"

3. Test the Server

# Test simple MCP server
echo '{"jsonrpc": "2.0", "id": 1, "method": "tools/list", "params": {}}' | python enterprise_mcp_server.py

# Test list_tables tool
echo '{"jsonrpc": "2.0", "id": 2, "method": "tools/call", "params": {"name": "list_tables", "arguments": {}}}' | python enterprise_mcp_server.py

Cursor Integration

Add to your Cursor MCP configuration (~/.cursor/mcp.json):

{
    "mcpServers": {
        "enterprise-postgres": {
            "command": "/path/to/venv/bin/python",
            "args": ["/path/to/enterprise_mcp_server.py"],
            "env": {
                "PG_DSN": "postgresql://postgres:@localhost:5432/your_database"
            }
        }
    }
}