PostgreSQL exposes database schemas and SQL queries through a locally running MCP server. An agent can inspect database schemas and run SQL queries for data work. Add your DATABASE_URI when you install the PostgreSQL MCP server in Longwave.
Add your DATABASE_URI when you install the PostgreSQL MCP server in Longwave.
Ask for the result in any thread, for example: “Inspect a table before writing a query”. The agent picks the PostgreSQL function and calls it.
Use cases
Inspect a table before writing a query
Read query results for an operations report
Review a query plan during an investigation
Questions people ask
Which PostgreSQL diagnostics does the listed MCP server expose?
The server includes schema inspection, query plans and database health tools. It also provides SQL execution tools. PostgreSQL documentation
Can the PostgreSQL server run in a restricted mode?
The listed server supports a restricted access mode. Its documentation describes the SQL and diagnostic operations available in that mode. PostgreSQL documentation
How do I add the PostgreSQL MCP server to Claude Code?
Run claude mcp add postgres -- uvx --with mcp<2 postgres-mcp in a terminal. Add your DATABASE_URI when you install the PostgreSQL MCP server in Longwave.
Who publishes the PostgreSQL MCP server?
Crystal DBA publishes the PostgreSQL MCP server that Longwave installs. Source code
Use PostgreSQL in Longwave
Call PostgreSQL from any agent thread, on your machine or in the cloud.