postgres.exec_dml
operator or admin mode, allowlisted database only
How to use it
postgres.exec_dml is exposed by the MCP Postgres MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the postgres.exec_dml tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install MCP Postgres
$
go install github.com/aparcero/mcp-postgres/cmd/mcp-postgres@latestOther tools in MCP Postgres (10)
postgres.count_rows
Always
postgres.describe_table
Always
postgres.exec_admin
admin mode, allowlisted database only
postgres.get_connection_status
Always
postgres.get_server_metrics
Always
postgres.list_databases
Always
postgres.list_schemas
Always
postgres.list_tables
Always
postgres.query
Always
postgres.sample_table
Always