pg-readonly-mcp
io.github.les-k/pg-readonly-mcp ยท version 0.1.1
Community listing. Not installed or verified by cosmic-mcp. Read the source and its permissions before you run it.
A read-only Postgres MCP server that parses SQL rather than pattern-matching it.
https://github.com/les-k/pg-readonly-mcpQuick facts
- Listing: Community
- Published Oct 2, 17:34 UTC
- Transport: stdio
- Package: pypi
pg-readonly-mcp0.1.1 - Listed by cosmic-mcp: Nov 9, 04:26 UTC
Details
- Repository: https://github.com/les-k/pg-readonly-mcp
- PyPI: https://pypi.org/project/pg-readonly-mcp/
- Website: https://les-k.github.io/field-notes.html
- Needs settings:
PG_READONLY_MCP_DSN
Setup snippets
Generated from the registry entry. cosmic-mcp has not run or reviewed this server; values in angle brackets are yours to fill in.
Run it locally (pypi)
uvx 'pg-readonly-mcp==0.1.1'Claude Desktop (claude_desktop_config.json)
{
"mcpServers": {
"pg-readonly-mcp": {
"args": [
"pg-readonly-mcp==0.1.1"
],
"command": "uvx",
"env": {
"PG_READONLY_MCP_DSN": "<your pg readonly mcp dsn>"
}
}
}
}Claude Code
claude mcp add 'pg-readonly-mcp' -- uvx 'pg-readonly-mcp==0.1.1'Cursor (.cursor/mcp.json)
{
"mcpServers": {
"pg-readonly-mcp": {
"args": [
"pg-readonly-mcp==0.1.1"
],
"command": "uvx",
"env": {
"PG_READONLY_MCP_DSN": "<your pg readonly mcp dsn>"
}
}
}
}VS Code (.vscode/mcp.json)
{
"servers": {
"pg-readonly-mcp": {
"args": [
"pg-readonly-mcp==0.1.1"
],
"command": "uvx",
"env": {
"PG_READONLY_MCP_DSN": "<your pg readonly mcp dsn>"
},
"type": "stdio"
}
}
}Related servers
- spotdb Verified domain
Ephemeral data sandbox for AI workflows with guardrails and security - Reasonbook Verified domain
Reasonbook: decisions that survive the session, in a local record AI agents keep. - AI for Database Verified domain
Ask your databases questions in plain English, run read-only SQL and set up data alerts. - AI2SQL Verified domain
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema - AICasePredict Verified domain
Search a large legal database of 325M+ US court records: cases, attorneys, judges and courts. - APC Security Reference Server
Reference MCP server for synthetic APC action-security evaluation and local SQLite sandbox testin...