pgsql-mcp-server

pgsql-mcp-server

5
databases

The PostgreSQL MCP Server is a Model Context Protocol server tailored for managing and interacting with PostgreSQL databases. It facilitates SQL operations for AI assistants, ensuring secure and efficient database interactions.

PostgreSQL MCP Server

A Model Context Protocol (MCP) server that provides tools for interacting with a PostgreSQL database. This server enables AI assistants to execute SQL queries, create tables, and list database tables through the MCP protocol.

Features

  • Execute SELECT, INSERT, UPDATE, or DELETE queries
  • Create new tables
  • List all user tables with optional schema filtering
  • EXPLAIN a query

Prerequisites

  • Go 1.23 or later
  • PostgreSQL database server

Configuration

Requires database connection details through environment variables.

Security Considerations

  • Query type validation and input sanitization
  • Use of a dedicated database user with limited permissions is recommended
  • SSL should be enabled in production environments

Dependencies

  • github.com/joho/godotenv
  • github.com/lib/pq
  • github.com/mark3labs/mcp-go