Postgresql MCP Server

🚀 PostgreSQL MCP Server

A Model Context Protocol (MCP) server that offers direct execution capabilities for PostgreSQL database queries. It allows custom SQL query execution on PostgreSQL databases, supporting parameterized queries and configurable timeouts. This project is specifically designed for use with the Cursor IDE.

🚀 Quick Start

This is a Model Context Protocol (MCP) server that provides the ability to directly execute queries on a PostgreSQL database. It enables users to run custom SQL queries against PostgreSQL databases, with support for parameterized queries and configurable timeouts. This project is specifically designed for use with the Cursor IDE.

📦 Installation

Installing via Smithery

To automatically install the PostgreSQL Database Query Server for Claude Desktop via Smithery, use the following command:

npx -y @smithery/cli install @1Levick3/postgresql-mcp-server --client claude

Manual Installation

1. Clone the repository.
2. Install dependencies:

   npm install
   

3. Build the server:

   npm run build
   

4. Add to the MCP settings file:

    {
      "mcpServers": {
        "postgresql-mcp": {
          "command": "node",
          "args": ["/Users/1Levick3/Desktop/postgresql-mcp-server/build/index.js"],
          "disabled": false,
          "alwaysAllow": [],
          "env": {
            "POSTGRES_CONNECTION_STRING": "postgresUrl",
            "POSTGRES_SSL_CERT_PATH": "/Users/1levick3/Desktop/root.crt"
          }
        }
      }
    }
   

💻 Usage Examples

Development

• npm run dev - Start the development server with hot reload.
• npm run lint - Run ESLint.
• npm test - Run tests.

🔧 Technical Details

Security Considerations

1. Connection Security
   • Uses connection pooling.
   • Implements connection timeouts.
   • Validates connection strings.
   • Supports SSL/TLS connections.

🤝 Contributing

1. Fork the repository.
2. Create a feature branch.
3. Commit your changes.
4. Push to the branch.
5. Create a Pull Request.