1. Conduid
  2. Search
  3. Postgres Schema MCP
MCP server · Search

Postgres Schema MCP

by · github.com/eric-patton/postgres-schema-mcp

MCP server giving an AI agent read-only access to a PostgreSQL database: schema browsing, foreign-key maps, column search, capped SELECTs, and an offline data dictionary. Writes are rejected, with tests that prove it.

Unclaimed ai-agentsclaudedatabase-toolsmcpmodel-context-protocolpostgresqlread-onlytypescript
InstallView source
34Low

Scored a month ago · breakdown

About Postgres Schema MCP

Postgres Schema MCP is an MCP server published by eric-patton in the Search category: mCP server giving an AI agent read-only access to a PostgreSQL database: schema browsing, foreign-key maps, column search, capped SELECTs, and an offline data dictionary. Writes are rejected, with tests that prove it.

Recent commit activity is the strongest signal that reported issues will get attention.

Install

From source
git clone https://github.com/eric-patton/postgres-schema-mcp

This server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.

Tools (9)

describe_tableColumns, types, nullability, defaults, keys, indexes, constraints and comments

Parameters not published.

explain_queryThe plan for a query. `ANALYZE` is off by default and opt-in

Parameters not published.

export_data_dictionaryWrite a Markdown data dictionary to a file

Parameters not published.

find_columnsSearch column names, and optionally types, across every schema

Parameters not published.

list_schemasSchemas with a count of what each holds. Start here.

Parameters not published.

list_tablesTables and views in one schema, largest first, with estimated rows and on-disk size

Parameters not published.

run_selectOne read-only query, with the guard, the timeout and the caps

Parameters not published.

sample_rowsThe first N rows of a table, redacted and capped

Parameters not published.

table_relationshipsFollow foreign keys in both directions, N hops deep

Parameters not published.

Ask AI

✦

Ask AI about Postgres Schema MCP

Powered by Claude · Grounded in docs

I know everything about Postgres Schema MCP. Ask me about installation, configuration, usage, or troubleshooting.

Security checks

6 checks have not been run yet.

Releases

v0.1.1v0.1.1 · 31 Aug 2026Read-only PostgreSQL access for an AI agent. Nine tools, 182 tests, writes refused three separate times. npx postgres-schema-mcp Or install the attached `.mcpb` bundle in a desktop client that prefers a single file. It carries its own…
Questions

About Postgres Schema MCP

How do I install Postgres Schema MCP?

No package has been published for this server, so install it from source: clone the repository and follow its README.

Is Postgres Schema MCP safe to use with an AI agent?

Its trust score is 34 out of 100 (low). Conduid hasn't run static security checks on this repository yet, so review the source yourself before granting it credentials. It has no ConduID identity yet, so agent calls to it are not receipted.

Is Postgres Schema MCP still maintained?

Yes — the latest release is v0.1.1 (31 Aug 2026), and the last commit was a month ago. The repository has 0 stars.