Postgres (read-only)
Read-only Postgres: drop-in for the archived server-postgres, with schema context.
Connector by contextflo · GitHub account verified by the MCP Registry
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
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.
About
Reviews
Write a reviewNo 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 by what they do 4
Read from the source code; the running server may list different tools.
Read 2 · Look things up without changing anything.
get_table_contextlist_tables
Write 1 · Create, change, send or run things.
add_table_context
Not yet classified 1 · We could not tell from the name and description.
query
Secrets and settings it asks for
Secrets: values you paste in that let it act as you.
DATABASE_URL
Network hosts it talks to 3
contextflo.com· found in codegithub.com· found in codeglama.ai· found in code
Files it touches
- Your home directory (~)
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_contextRecord 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_contextDescribe 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_tablesList 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.
queryRun 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
Cite this page
Postgres (read-only) MCP server. Agent Mart. https://agentmart.dev/connectors/contextflo-postgres-mcp (last updated 2026-10-25)