Allows querying and inspecting a PostgreSQL database schema, including listing tables, describing columns, and executing read-only SQL queries.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@mcp-postgres show me the columns of the users table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
An MCP server that connects to a PostgreSQL database and exposes schema inspection and safe query execution as tools and resources — ready to plug into Claude Desktop or any MCP-compatible client.
Tool | Description |
| List all tables in the public schema |
| Show columns, types, and nullability for a table |
| Execute a SELECT query and return results (mutating statements are blocked) |
Related MCP server: @yawlabs/postgres-mcp
URI | Description |
| Full schema dump — all tables with their columns |
git clone <repo-url>
cd mcp-postgres
python -m venv .venv
source .venv/bin/activate # Windows: .venv\Scripts\activate
pip install -e .cp .env.example .env
# Edit .env — set DATABASE_URL to your PostgreSQL connection stringmcp-postgresOr directly:
python -m mcp_postgres.serverAdd to your claude_desktop_config.json:
{
"mcpServers": {
"postgres": {
"command": "/path/to/.venv/bin/mcp-postgres",
"env": {
"DATABASE_URL": "postgresql://user:password@localhost:5432/mydb"
}
}
}
}src/mcp_postgres/
__init__.py — package marker
db.py — psycopg2 connection context manager
server.py — FastMCP server, tools, and resourcesrun_query rejects any statement that does not begin with SELECT. This prevents accidental or malicious data modification through the MCP interface.
This server cannot be deployed
PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.
Query your Postgres from ChatGPT or Claude without exposing the database or handing over credentials. Run npx boltschema connect next to your database and it dials out over HTTPS — no inbound firewall rule, no open port, works with localhost and VPC-private databases. Read-only is enforced by a SQL guard, a Postgres READ ONLY transaction, and a scoped role generated for you.
Query PostgreSQL databases in plain English — LLM-generated, safety-validated SQL.
