Simple PostgreSQL MCP Server

An MCP server for executing SQL queries on PostgreSQL databases with configurable permissions.

A minimal Model Context Protocol (MCP) server for executing SQL queries on PostgreSQL databases with configurable permissions.

- Execute SQL queries with optional read-only or write access
- Server-level mode (read-only/write) configurable via command line
- Returns structured results with metadata
- Simple setup using a PostgreSQL connection string
- Clone the repository

git clone https://github.com/perrypixel/Simple-Postgres-MCP cd Simple-Postgres-MCP

Add the following to your MCP client configuration (mcp.json):

{ "mcpServers": { "simple-postgresql-mcp": { "command": "node", "args": [ "/path/to/build/index.js", "postgresql://username:password@localhost:5432/database_name", "write" ] } } }

{ "mcpServers": { "simple-postgresql-mcp": { "command": "node", "args": [ "/path/to/build/index.js", "postgresql://username:password@localhost:5432/database_name", "readonly" ] } } }

Note:Update the path in the configuration to point to theindex.jsfile inside yourbuildfolder.
- Copy the appropriate MCP configuration (read-only or write mode) to your tool’smcp.json(e.g., Cursor, Windsurf, Copilot, etc.).
- Start your MCP client. The server is now ready to use!

If you find this tool helpful, you can support the development by:

- Buying me a coffee athttps://ko-fi.com/perrypixel
- UPI to kevinp@apl

Maritime intelligence for tracking vessels, analysing ports, and exploring ship data.