Read Only Local Postgres MCP server
{
"mcpServers": {
"hove-read-only-local-postgres": {
"command": "npx",
"args": [
"-y",
"@hovecapital/read-only-postgres-mcp-server@latest"
],
"env": {
"DB_HOST": "<db_host>",
"DB_DATABASE": "postgresql://user:password@host:5432/db",
"DB_USERNAME": "<db_username>",
"DB_PASSWORD": "<db_password>"
}
}
}
}{
"mcpServers": {
"hove-read-only-local-postgres": {
"command": "npx",
"args": [
"-y",
"@hovecapital/read-only-postgres-mcp-server@latest"
],
"env": {
"DB_HOST": "<db_host>",
"DB_DATABASE": "postgresql://user:password@host:5432/db",
"DB_USERNAME": "<db_username>",
"DB_PASSWORD": "<db_password>"
}
}
}
}{
"mcpServers": {
"hove-read-only-local-postgres": {
"command": "npx",
"args": [
"-y",
"@hovecapital/read-only-postgres-mcp-server@latest"
],
"env": {
"DB_HOST": "<db_host>",
"DB_DATABASE": "postgresql://user:password@host:5432/db",
"DB_USERNAME": "<db_username>",
"DB_PASSWORD": "<db_password>"
}
}
}
}{
"servers": {
"hove-read-only-local-postgres": {
"command": "npx",
"args": [
"-y",
"@hovecapital/read-only-postgres-mcp-server@latest"
],
"env": {
"DB_HOST": "${input:db_host}",
"DB_DATABASE": "${input:db_database}",
"DB_USERNAME": "${input:db_username}",
"DB_PASSWORD": "${input:db_password}"
}
}
},
"inputs": [
{
"id": "db_host",
"type": "promptString",
"description": "Db host",
"password": true
},
{
"id": "db_database",
"type": "promptString",
"description": "Db database",
"password": true
},
{
"id": "db_username",
"type": "promptString",
"description": "Db username",
"password": true
},
{
"id": "db_password",
"type": "promptString",
"description": "Db password",
"password": true
}
]
}{
"mcpServers": {
"hove-read-only-local-postgres": {
"command": "npx",
"args": [
"-y",
"@hovecapital/read-only-postgres-mcp-server@latest"
],
"env": {
"DB_HOST": "<db_host>",
"DB_DATABASE": "postgresql://user:password@host:5432/db",
"DB_USERNAME": "<db_username>",
"DB_PASSWORD": "<db_password>"
}
}
}
}file .mcp.json (in your project root)file claude_desktop_config.jsonfile ~/.cursor/mcp.jsonfile .vscode/mcp.jsonfile ~/.codeium/windsurf/mcp_config.jsoninstall npx -y @hovecapital/read-only-postgres-mcp-serverversion 0.1.0
What it does
An MCP server that allows Claude to execute read-only SQL queries against PostgreSQL databases. It connects to local or remote PostgreSQL instances and returns query results as JSON, with built-in statement validation and database-enforced read-only transactions.
- Query database schema and table structure using natural language through Claude Desktop or Claude Code.
- Retrieve data from PostgreSQL databases by describing what information you need in plain English.
- Explore and analyze database contents without risk of modification, as all queries run in read-only mode.
Tools this server exposes
| Tool | Does |
|---|---|
| query | Execute a read-only SQL query against the connected PostgreSQL database and receive results in JSON format. |
Before you enable it
An MCP server runs with whatever access you give it. Start with a development account rather than production, and check which tools the server exposes before you let an agent call them unattended.