Execute the same SQL against multiple selected databases/connections

[g-ozcelik]

Hi,
I'm frequently working with multiple PostgreSQL databases that have the same schema (multi-tenant environments, templete databases).

A common task is running the same maintenance or diagnostic SQL against several databases. At the moment I have to:

expand each database
open a Query Tool for each one
paste the same SQL
execute it separately

This becomes repetitive when working with several databases.

It would be very useful if the Query Tool could execute the current SQL against multiple selected databases/connections.

For example:

Execute → Execute on Multiple Databases...
Select one or more open connections/databases.
Run the SQL sequentially.
Show the result (or any error) for each database separately.

I'm not suggesting cross-database SQL execution inside PostgreSQL itself—just having pgAdmin send the same query to multiple selected connections one after another.
I know this can already be done using psql or custom scripts, but having it built into pgAdmin would make these routine tasks much more convenient.
This would make routine administration tasks much faster for environments with many similar databases.

Thanks for considering it.

[dev-hari-prasad]

Thanks for the detailed proposal. I can see the use case, especially for environments or databases sharing the same schema.

This would be a fairly significant feature for pgAdmin, though. Supporting it would likely require changes across both the Query Tool UI and backend, as well as decisions around things like connection handling, sequential vs. parallel execution, transaction behaviour, error handling, cancellation, and how results from multiple databases should be presented.

Given the scope, I think we would need some traction on the feature and, more importantly, approval and input from the core maintainers before deciding on an implementation.

If the maintainers are interested in pursuing it, we can then work out the expected behaviour and technical design in more detail.