mcp-server-postgres
About
mcp-server-postgres is a Model Context Protocol (MCP) server for PostgreSQL databases. It lets LLMs inspect database schemas and execute read-only queries, providing safe, read-only access to PostgreSQL through the MCP interface.
Details
- Author
- yuru-sha
- Downloads
- 216
- Categories
- Database
Jump to
- Read-only access to PostgreSQL databases
- Schema inspection capabilities
- Queries executed within READ ONLY transactions
- Docker support for easy deployment
- Available as an NPM package
- Secure by default—enforces read-only operations
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
mcp-server-postgresCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Install via Docker (build with make docker and run with docker run -i --rm mcp/postgres postgresql://host:port/dbname) or install via Smithery (npx -y @smithery/cli install @yuru-sha/mcp-server-postgres --client claude). For Claude Desktop, add a configuration entry to claude_desktop_config.json specifying the Docker command and connection URL.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mcp-server-postgres": {
"mcp-server-postgres-yuru-sha": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp/postgres",
"postgresql://host:port/dbname"
]
}
}
}
}McpServers
{
"mcp-server-postgres-yuru-sha": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp/postgres",
"postgresql://host:port/dbname"
]
}
}mcp-server-postgres
Model Context Protocol Server for PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
Features
- Read-only access to PostgreSQL databases
- Schema inspection capabilities
- Safe query execution within READ ONLY transactions
- Docker support
- NPM package available
Installation
Using Docker
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
