How do I connect Postgres MCP Server to Claude?

Run `claude mcp add javimaligno-postgres-mcp -- npx -y @javiagui/postgresql-mcp` in Claude Code, or add the same command and arguments under mcpServers in Cursor's mcp.json or Claude Desktop's claude_desktop_config.json, then restart the client. The blocks above are ready to paste.

Is Postgres MCP Server free?

The listed licence is MIT. Check the upstream terms for permitted use and commercial requirements; a public repository does not by itself mean the software is free or open source. Connected APIs and hosted services may have separate charges.

What can Postgres MCP Server do?

Postgres MCP Server documents 15 tools to the agent, including describe_table, describe_view, execute. The descriptions above come from project documentation. A live handshake does not test individual tool behavior.

Postgres MCP

Unclaimed

by JaviMaligno

The only postgress MCP server I have been able to connect to my docker postgres

Set up this server

Compare servers My Stack

01 / Choose your client

02 / Before you connect

Authentication is not specified. Check the project instructions before connecting.

Install the runtime required by the project and make it available to your client.

Project instructionsEnvironment variable names (optional)

Use names from the project instructions, separated by commas. Enter names only, never secret values.

03 / Add the configuration

Source: generated from public install instructions

claude mcp add --transport stdio 'javimaligno-postgres-mcp' -- 'npx' '-y' '@javiagui/postgresql-mcp'

Run in your terminal after replacing any placeholders.

04 / Check it in your client

Open your client’s MCP settings and confirm the server connects and lists its tools. A copied configuration does not confirm a working connection.

Is this your MCP server?

This listing was auto-indexed from the public record. Claim it to edit the page, set compatibility and unlock growth tools. Takes under two minutes.

Claim this server

Security profile

Claimed and verified servers get a weekly static scan that shows what the code can reach: external services, environment variables, shell commands, agent configuration folders, plus any dependencies with known advisories. Claim this listing to get one. How the security profile works

15 of 15 tools

Documented tools (15)

From project documentation. A server handshake does not verify each tool’s description or behavior.

describe_table

Get table structure (columns, types, constraints)

describe_view

Get view definition and columns

execute

Execute write operations (INSERT/UPDATE/DELETE) when enabled

explain_query

Get EXPLAIN plan for query optimization

get_database_info

Get database version and connection info

list_constraints

List constraints (PK, FK, UNIQUE, CHECK)

list_databases

List the configured connections by alias, with host, database, write permission and which is the default. Never returns credentials.

list_functions

List functions and procedures

list_indexes

List indexes for a table

list_schemas

List all schemas in the database

list_tables

List tables in a specific schema

list_views

List views in a schema

query

Execute read-only SQL queries against the database

search_columns

Search for columns by name across all tables

table_stats

Get table statistics (row count, size, bloat)

Tool change history

Compared across complete checks of the same configuration. Tools were listed, not invoked. Input-schema changes are not measured here.

No complete tool checks yet.

FAQ

Questions about Postgres MCP Server

How do I connect Postgres MCP Server to Claude?: Run `claude mcp add javimaligno-postgres-mcp -- npx -y @javiagui/postgresql-mcp` in Claude Code, or add the same command and arguments under mcpServers in Cursor's mcp.json or Claude Desktop's claude_desktop_config.json, then restart the client. The blocks above are ready to paste.
Is Postgres MCP Server free?: The listed licence is MIT. Check the upstream terms for permitted use and commercial requirements; a public repository does not by itself mean the software is free or open source. Connected APIs and hosted services may have separate charges.
What can Postgres MCP Server do?: Postgres MCP Server documents 15 tools to the agent, including describe_table, describe_view, execute. The descriptions above come from project documentation. A live handshake does not test individual tool behavior.