Skip to content
Agentmart
Submit a tool

Postgres MCP

PostgreSQL MCP wrapper with.env credential mapping, tool selection, and safe read-only defaults.

Connector by edelciomolina · GitHub account verified by the MCP Registry

IndexedMITLocal (stdio)★ 5
Write a review

Install

Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.

npx agentmarket install connector/edelciomolina-postgres-mcp

Asks which of your tools to add it to (Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI, Claude Desktop) and shows the change first. See https://agentmart.dev/cli.

Get the weekly diff

The weekly diff: one email a week with new agent tools, notable updates and grade changes, plus security alerts for tools you follow. Double opt-in, one-click unsubscribe.

We use your email only for this newsletter. Privacy

About

PostgreSQL MCP wrapper with .env credential mapping, tool selection, and safe read-only defaults.

Reviews

Write a review

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this server can do and what it asks for, from its tool list and install config. Checked Oct 25, 2026.

Tools
7 read · 3 write · 6 delete · 4 not yet classified
Secrets
3 (API keys, tokens or passwords)
Install scripts
Not scanned yet
Runs as
Node.js package

Tools by what they do 20

Read from the source code; the running server may list different tools.

Read 7 · Look things up without changing anything.

  • pg_analyze_database
  • pg_classify_query_risk
  • pg_describe_table_semantics
  • pg_find_related_tables
  • pg_get_setup_instructions
  • pg_inspect_schema
  • pg_monitor_database

Write 3 · Create, change, send or run things.

  • pg_manage_query
  • pg_manage_rls
  • pg_manage_schema

Delete 6 · Delete, drop, revoke or wipe things.

  • pg_execute_mutation
  • pg_manage_constraints
  • pg_manage_functions
  • pg_manage_indexes
  • pg_manage_triggers
  • pg_manage_users

Not yet classified 4 · We could not tell from the name and description.

  • pg_debug_database
  • pg_execute_query
  • pg_execute_sql
  • pg_inspect_database_graph

Secrets and settings it asks for

Secrets: values you paste in that let it act as you.

  • MCP_KEY_NAME
  • MCP_KEY_PASS
  • MCP_KEY_SSLMODE

Other settings (environment variables or headers).

  • MCP_KEY_HOST
  • MCP_KEY_PORT
  • MCP_KEY_USER

Tools (20)

Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].

  • pg_analyze_database

    Analyze PostgreSQL database performance and configuration.

  • pg_classify_query_risk

    Classify the risk level of a SQL query WITHOUT executing it. Returns safe | warning | review | blocked with reasons and suggestions. Use this before pg_execute_query to understand potential issues.

  • pg_debug_database

    Diagnose common PostgreSQL issues - connections, locks, performance, replication.

  • pg_describe_table_semantics

    Describe a table with semantic context: probable purpose, risk level, column roles, sensitive columns, related tables (via FK and inferred), and allowed operations. Use this before writing any query against an unfamiliar table.

  • pg_execute_mutation

    Execute data modification operations - INSERT, UPDATE, DELETE, or UPSERT. NOT enabled by default; must be opted-in via tool= arg.

  • pg_execute_query

    Execute SELECT queries and data retrieval operations - operation="select/count/exists" with query and optional parameters.

  • pg_execute_sql

    Execute arbitrary SQL statements with optional transaction support. NOT enabled by default; must be opted-in via tool= arg.

  • pg_find_related_tables

    Find tables related to a given table via explicit foreign keys and inferred naming patterns. Useful for understanding join paths before writing multi-table queries.

  • pg_get_setup_instructions

    Get platform-specific PostgreSQL setup and connection instructions.

  • pg_inspect_database_graph

    Build and return a structural knowledge graph of the database: schemas, tables, columns, foreign keys, indexes, inferred relations, and business domains. Use this as a starting point before querying unfamiliar databases. All inferred fields are clearly tagged - treat them as hints, not facts.

  • pg_inspect_schema

    Inspect PostgreSQL schema - list tables and columns, view ENUM types. Read-only.

  • pg_manage_constraints

    Manage PostgreSQL constraints - get, create foreign keys, drop constraints.

  • pg_manage_functions

    Manage PostgreSQL functions - get, create, or drop functions.

  • pg_manage_indexes

    Manage PostgreSQL indexes - get, create, drop, reindex, and analyze usage.

  • pg_manage_query

    Manage PostgreSQL query analysis and performance - EXPLAIN plans, slow queries, statistics.

Show 5 more tools
  • pg_manage_rls

    Manage PostgreSQL Row-Level Security - enable/disable RLS and manage policies.

  • pg_manage_schema

    Manage PostgreSQL schema - get schema info, create/alter tables, manage enums.

  • pg_manage_triggers

    Manage PostgreSQL triggers - get, create, drop, enable/disable.

  • pg_manage_users

    Manage PostgreSQL users and permissions - get permissions, create/drop/alter users, grant/revoke.

  • pg_monitor_database

    Get real-time monitoring information for a PostgreSQL database.

Signals

Stars
5
Forks
0
Open issues
0
Weekly downloads
25
Last commit
Jun 13, 2026 (4 months ago)
Last release
Jun 11, 2026 (4 months ago)
Last package publish
Jun 13, 2026 (4 months ago)

From GitHub (fetched Oct 24, 2026) and the package registry.

Details

Registry name
io.github.edelciomolina/postgres-mcp
Version
1.7.0
Auth
No auth
Packages
npm @edelciomolina/postgres-mcp
License
MIT
Repository
github.com/edelciomolina/postgres-mcp
First seen
Oct 24, 2026
Last checked
Oct 24, 2026
Source
Official MCP Registrygithub-graphql
Cite this page

Postgres MCP. Agent Mart. https://agentmart.dev/connectors/edelciomolina-postgres-mcp (last updated 2026-10-24)