PostgreSQL MCP Server
← Back to gallery 
PostgreSQLExecute QueryPostgreSQLGet Table InfoPostgreSQLExecute Query
PostgreSQL MCP Server
AIMCP ServerPostgreSQL
With AI assistants, one of the biggest challenges is safely exposing your internal data and services to the model.
With Flows you can easily expose anything as an MCP server - safely, with guardrails, OAuth2 authorization, and full auditability.
With private agents you can even expose private resources (e.g. databases) to public AI assistants, in a safe and easy way.
Warning: If you use this template verbatim, make sure to use a constrained database user limited to what you want your AI assistant to access.
AI (built-in)MCP Tool
List Tables Tool
AI (built-in)MCP Tool
Get Table Schema Tool
AI (built-in)MCP Tool
Run Query Tool
PostgreSQLExecute QueryList Tables
PostgreSQLGet Table InfoGet Table Info
PostgreSQLExecute QueryRun Query
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.