Postgres (read-only)

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/contextflo-postgres-mcp

About

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, install config and code. Checked Oct 25, 2026.

Tools

2 read · 1 write · 0 delete · 1 not yet classified

Secrets

1 (API keys, tokens or passwords)

Install scripts

None found

Runs as

Node.js package

Tools (4)

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

• add_table_context

  Record a durable fact about a table or its columns that you learned from working with the data and that someone writing SQL against it later would otherwise get wrong: units ("amount is in cents"), undocumented values ("status also contains 'void' for rows before 2022"), required filters ("exclude rows where deleted_at is set"), or which table is the source of truth. The note is appended to the team's context file and shown by get_table_context from then on. Do not record what the schema already says (types, nullability, keys), one-off query results, or anything you have not verified against t…

• get_table_context

  Describe one or more tables: columns, types, nullability, primary keys, foreign key targets, and any curated descriptions. Pass every candidate table at once rather than calling repeatedly. Read this before writing SQL against a table you have not used yet.

• list_tables

  List the tables, views, and materialized views this connection can read, with their descriptions. Call this first when you need to know what data exists — do not guess table names. Pass `pattern` to narrow by a word appearing anywhere in the table name or its description; call it again with a different word to try a synonym. For anything more specific — searching column names, types, or comments — query information_schema and pg_catalog directly with the query tool, they are ordinary tables.

• query

  Run a read-only SQL query against the Postgres database. Accepts a single SELECT (including WITH ... SELECT), EXPLAIN, or SHOW statement. Writes, DDL, multiple statements, and SET are rejected. information_schema and pg_catalog are readable, so schema questions this server has no tool for can be answered with plain SQL.

Signals

Stars

4

Forks

0

Open issues

0

Weekly downloads

141

Last commit

Sep 28, 2026 (1 month ago)

Last release

Sep 28, 2026 (1 month ago)

Last package publish

Sep 28, 2026 (1 month ago)

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

Details

Registry name

io.github.contextflo/postgres-mcp

Version

0.1.4

Auth

API key

Packages

npm @contextflo/postgres-mcp

License

MIT

Repository

github.com/contextflo/postgres-mcp

Website

contextflo.com/postgres-mcp

First seen

Oct 24, 2026

Last checked

Oct 25, 2026

Source

Official MCP Registrygithub-graphql