Inspect PostgreSQL schemas and run read-only queries with the archived MCP reference server. Review its maintenance status before choosing it.
This PostgreSQL MCP listing covers the archived Model Context Protocol reference implementation. It exposes table schemas as resources and a query tool that runs SQL in a read-only transaction. It is a reference example rather than a currently maintained PostgreSQL vendor integration.
A useful evaluation task is to identify the tables involved in a question, then run a small SELECT query. Keep the SQL, filters and row limit with the result. Connect with a database role whose permissions match the data you intend to expose.
The documented package is @modelcontextprotocol/server-postgres and accepts a database connection URL as an argument. The source now lives in the archived servers repository. Review a maintained alternative if you need ongoing fixes or deployment support; the presence of a published package alone does not establish current maintenance.
Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.
| Tool | What it does |
|---|---|
| query | Run SQL in the reference server’s read-only transaction. |
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-postgres",
"postgresql://READ_ONLY_USER:PASSWORD@HOST:5432/DATABASE"
]
}
}
}Replace the connection URL with your own database credentials. Review the archived maintenance status before use.
Node.js with npx and a PostgreSQL connection URL. This reference implementation is archived.
Connect the Notion MCP server to search workspace content and work with pages and databases through Notion’s hosted OAuth service.
Use the Supabase MCP server to inspect database schemas, query project data and retrieve docs through a project-scoped connection.
Pre-action risk gate: AI agents call before any irreversible action (money, SQL, delete).
A Model Context Protocol (MCP) server for Google BigQuery that enables AI agents to interact with BigQuery databases through natural language queries and schema exploration.
Recreation.gov MCP — wraps the Recreation Information Database (RIDB) API v1
CData JDBC Driver connects to Excel Online by exposing them as relational SQL models.